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

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

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

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

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

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

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

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

Dinfinition of Claim system : A system whereby it will automatic calculate the amount of claim allows and determine whether the claimant qualify for the claim...

How do I programatically change the field type from Date/Time to "Short Date" using DAO code. Also, how do I assign "programatically" to a table date field an...

Ok..I've taken three classes on Access now and not one has addressed those lovely pop up switchboards. I would LOVE to know how to make one..any help out...

I would like to keep track of the transfers of assets between employees. tblEmployee (one to many with tblHistory) EmployeeID FirstName LastName tblAsset (one...

Hi, I'm have atable with various columns containing information in euros. For some reason it will not let me use cents because it always rounds them up or...

I am attempting to put our paper daily log book into Access. I have twenty beds that have guests checking out and checking in and I need to keep track of the...

what is the best field type for a zip code? Thanks,

I posted a request for advice on table design and received a reply from "Henry" who kindly suggested I should attach a copy of my db to him. I realise no-one...

I am trying to design a db to hold: Patients Name, general Patient info and diagnosis information. I am fairly new at the db thing and just needed someone to...