I have a table with lots of dates. I would like ONE date to default to the current date, or, better, the day before the current date (I figure the user is...

Does anyone know how to unhide a table? I created a table for update purposes only and hid it so no one would mess with it, but now can't get to it to modify...

Hello there I want to write a code as follows for the table : CheckCriteria = Forms!! .Form!IM_Name The above code have a checkcriteria function...

For a student database you need two addresses, term and home - generally both are the same so it is easier if the second is automatically copied from the first...

I am trying to build a database that will measure performance management in the delivery of a service The table I have built so far allows the user to...

I am in the process of normalizing some tables based on the advice of John Vinson a while back. I'd just like to check on one field in a table: Here's what I...

I have a table in Access2000 that includes an OLE data field which I was hoping to include small (75-500k) jpeg objects, embedded, not linked. However, when I...

I am trying to build a table of Inventory Items including such things as Purchase Cost and various conversion factors to allow a Unit Cost to be calculated. ...

Hello, Is there a way that I can programmatically append the data from one table in Access to another table in the same database? Thanks, Martin Wilson

I am attempting to add a password to a database -- meaning when the db is opened the user is prompted to enter in the appropriate password. I have done this...

I have 3 tables -- tblCounty tblCity tblAddress fldCounty fldCounty fldCounty fldCity fldCity fldName fldAddress...

Does anyone know how to add "x" number of records into a table, where the "x" is a user inputed number, and whose value is not constant. (i.e. add 5 records...

Is there a way to create an autonumber by year, month, day, then sequential number for that day? Something like YYYYMMDD### I'm wanting to "try" and build a...

I was wondering what is the best way to clean and repair databases tables that may have been corrupted. The tables are linked and compact and repair was...

I have an Access DB that grows as the users use it. It starts out at 8000 kb and then grows to 111,000kb by the afternoon. I compact and repair, but I do not...

I have an application that does updating and reporting. When the user selects his name, a subset of his records are captured. My question is this: Do those...

I have designed databases in the past but have had the help of books and the luxury of time. I have no time to get this one done in and would appreciate any...

I wish to record all my paper files -- simple, easy to use -- in Excel or Access

I am having trouble with the design of my database. I am also having a problem attaching my dbase file i'm sorry but you cant look at it! Anyway .... my...

Ok, well, I've been reading a few threads about Primary Keys, and the use of natural vs. surrogate keys. Sadly, a little learning is a dangerous thing, and...