I am a pharmacist and am creating a database to help improve inventory control. To do so, I have started with a table (Drugs by NDC) that has an autonumber...

I get the concept of a two key Primary key making a unique identifier. Love that. When I test my database though and put in a record with identical primary...

Hi, Access 2003 adp: In my VBA code, I create a new table in SQL Server and then want to access that same table later in the same sub procedure. After the...

Anyone know any good references or setup techniques for starting a data warehouse using Access exclusively? I need to take data from many different tables...

I am creating a database where my primary key is a panel number. From there it breaks down into cells. So it is possible for a panel number to be listed...

Can someone recommend a sample database that I can look at that will show the table relationship (one to many) and entering in data that will bring up the...

Hi Folks, Is anyone sick of the junk bb's online? I found a new bb that is amazing to say the least. They have all kinds of adult topics that you can post to...

This question is blazing across America and many from all walks of life and child support situations are reading the best selling book: "The Child Support...

I’m relatively new to Access but I have a fairly good understanding of the basics. What I am faced with is creating an application to create, maintain and...

I have two forms linked to different queries. I want to add the values of both the forms in one form so want to copy the values in one form.how to write the...

Is there a (EASY) way to convert a database rfom Lotus Approach to MS Access? I would like to avoid rebuilding it if possible. TIA! Julie

Hi! I'm trying to build an ms-access application (mdb) with different languages support. So the user can select the language that he want (understands) to be...

Dear all, I have designed a database with a Receivable Table and a Payment Table to keep track on the rental income and receivable. The Receivable Table is...

I have a really simple structure for an ISP. I just need to get weekly utilization figures. The problem is when the node is over utilized it gets segmented...

1.665717E-02 Now We Can Help Each Other ... 0.3610508 0.9525692 Now Visit http://www.clicklinknow.com/ss/ 0.5533148

Hi, Please forgive my long sad story of confusion and near despair, but I hope you can hang in there with me and help me figure this out. I don't mean to be...

Looking for a template to record, report and organize data for Masonic Lodges, Grottos, Sword of Bunker Hill and Shriners. Would appreciate any help with any...

Is there a place in access that I can print all the field statistics for a database. I want a way to get it all rather than looking at each field and...

I am new to Access and have the daunting task of creating a DBase in Access 2003. I have created 2 tables one for File Information (file name, client,...

i want to establish a link between two tables in the same database (MS ACCESS) so that if i update a record in one table it automatically gets updated in the...