My fishing club sells bait to members. I want to print receipts for each purchase listing items purchased and log the sales for stock inventory. Each product...

I am trying to create an Account Reconciliation Databse which will compare two tables. Two tables are Bank and Ledger. Both tables have same fields. Users...

In Access 97 you are restricted to 255 Attribute Names in a data base. Is that restriction in the 2007 version?

Hi all, as I continue on my awesome journey of Access I am making efforts to improve my design. My question is this. I am adding a new element to my database...

How can you find out the size of tables in a database without having to export each of the tables?

Hi All, I hope someone can help me with this one please. I have a table of students that contains many of their personal details. I've used an autonumber...

I have two tables one is a table of components which has a unique item number as the primary key. The other fields are part numbers, component description,...

I have a question about splitting the database and making into an MDE file to distribute front ends. I have several reports in my database that run and use a...

Hi folks, I'm just wondering if there's a way to add a primary key to an ODBC linked table? The current linked table as it is does not have a primary key and...

I’ve been working with this table for some time now that has about 15 or so fields in it which I know is way too many. For the life of me, I would like to...

Hi, I am suposed to create a database manually. By this I mean using SQL statements. I am unable to figure out how this is done though. The only way I can...

Is there a way to have an icon on my desktop that I could click to open my database switchboard without the access program window opening also? I would like...

hi, After database splitting, would I be able to add more forms in the future? Thanks! -- Message posted via http://www.accessmonster.com

Here is the background info. An employment agency called me and told me there have a client who needs someone with access and excel expertise. They mailed me...

I'm using MS Access 2000 want to make my database a MDE. I tried Tools, Utilities, but the "Make MDE" option is in grey and I can't make MDE. Is there...

I'm using a database to track patients enrolled in research protocols at our medical center. Any one patient may enroll in several protocols. I have a...

I have an order form which requires the names of 3 employees. (1)Order Taken By:, (2)Dispatched By:, (3)Dispatched To:. I have combo boxes set up and...

I have a table full of shipping data with a column for the date. I need to extract the month, and put it in its own column. How should I do this? Thanks!

Can anyone refer me to a source that demonstrates how to thoroughly document a database application? Perhaps something with examples or a sample form...

Hi everyone, Just curious but is it considered poor design to have a query in backtable lookup field? Meaning, I created a lookup field from another table in...