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...

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...

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 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

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 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...

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...

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...

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...

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...

How do I SET A CRITERIA TO QUERY A DATA BANK OF DATES, TO FIND DATES LESS THAN

I would like to create a dynamic subcategory listbox that displays only options appropriate to the initial main category selection. For example, I have a main...

THIS IS STUPID, I'M SURE, BUT I HAD WORKS 4.0 AND WAS ABLE TO SET UP FORM LETTERS WITH AN EXISTING DATABASE. NOW THE SPREADSHEET AND DATABASES WON'T MERGE. HOW...

Hello, I've got a database that I'm importing and then generating a primary key and MS is generating an error say Dup. Key. The two fields in question is...

I am trying to create a query in Microsoft Access that allows me to get the maximum of multiple variables. For instance I have a field for vitals for timepoint...

I received error 3197 when I tried to start my access database. It stated that the jet engine could not continue because another user and myself were trying...

I've been told that you can improve the performance of a Jet database if you index all fields used as criteria fields in queries. Of course I'd always like to...

I have two questions: 1) I am creating a table with a SQL statement that takes data from another ODBC linked table. The PK of the source table is created as a...

How do I add leading zeroes to a field? For example I have a field named "Course_ID" when a user enters 10 I would like to show it as 00010. Your help is...

How would I get the drop-down to display the recognizable Name and input the corresponding Key? I've got a couple of tables, one for expenses, and one for...