I have a table of customer journal entries (charges, credits)... I'd like the customer invoice to only show current fiscal year activity. What's the best way...

I am using Access 2000 I made a Db program for non-Access users to use. But someone figured out that you can delete the record. So I set the form for no...

How do I lock an access data base so that the users can't change the design. Better still how can I create stand-alone applications which do not need Access...

Hello, We have a contacts database in MS-Access, and also a lot of contacts in Outlook. It would be nice if we could eliminate one of them, and share...

I have a table that contains car registration plates that are entered everyday into frontpage forms on the web. These are posted into a Access table. I then...

We have a tracking system setup on the network and one of the users performed a local save to their computer and have been working off of the same database as...

I am trying to design a table so that the team shown in the team 1 column will never equal the team shown in the team 2 column

Hello, I am a newbie with Access and have been reading the Access Indide Out from MS and have learned quite a bit. But Where can I learn how to make an Access...

I really need help with a formula to calculate the loan amount based on the mortgage payment, interest rate and term. How would you calculate this in Access...

I am looking for a simple database that allows me to enter in expenses and invoices, which gives a summary table with net, vat, and total amounts. Many...

Hello all, I have a database that keeps records on Companies. What I need to do is know which company can supply other companies products. For example: I...

I have two tables with (1 items) and (2 transactions) on items in "1". (eg. I have equipment in table"1". Maintainance on equipment in Table "2"). this two...

I have create a number of tables with NSW info in one Victoria in another and QLD in another. I am trying to combine all of the data into one large table then...

I'm trying to establish a medical excel file for my mother. She has a complicated medical history and everytime I think I've created an effective excel chart...

Hi, I have what I think might be a really simple question: I have a subform which lists records in datasheet view. This is our view preference for this...

Am I right in presuming that setting a database to Compact on Close is a BAD idea in a multiuser environment? I can envisage all sorts of problems or am I...

I want to create a database of different magazine articles. In particular, articles in Guitar instruction magazines: 1 lessons, concepts 2 transcriptions -...

My database is changing data in fields with wrong information and I am not exactly sure when this happens. This is only occuring in one field and two tables...

When I veiw my table, some of the fields have little boxes between the words instead of spaces. I cannot copy them. I cannot find them when doing a...

When should a look up table be created? What I was thinking is in the IT inventory database, for field type, I created a combo box that pulls what is already...