Hi, Having a hard time trying to help myself with this one, so I am posting a question... I want to set a field in my table to have no duplicates allowed...

Can anyone recommend a quality third-party control that meets the following criteria: -Capable of displaying flat table in hierarchical "tree grid" form...

I have a co-worker that would like me to build a database that centralizes a huge amount of data and am wondering if Access would even be the avenue to try...

For Access 2003, 1) What''s the difference betwwen the 3 options in the "join type" section? 2) What''s "cascade update related field"? Thanks

Get your aspirin and other headache pills at the ready... I have already posted this in the thread "one-to-many relationships" in "general questions" but have...

Hi, I have read through the posts but am unclear on how I would create the above database. I am creating a database with ID,Name,Date,Time. A need to track...

I want to create 1 template, save it and later reuse it under a different file name. Is this possible, and if so, how do I do it? Your help is appreciated.

I'm trying to design a DB that will keep track of overtime hours and date. I have a table of employees, table of equipment they work on and table of date and...

Can we rename the acwzusrt.mdt file to the Office 2003 equivalent? We have seen that this works but are not sure of how advisable it is.

Hello all, I was hoping I could get some people to chime in here regarding the various Cursor Types and locations available for working with Jet and SQL...

Hi, I'm in the process of designing a database for certain geographical areas. This is will be one of the first databases I create. I've identified some...

I'm trying to take a simple database I created to track barcode #s and make it so when a new record is created, a specific barcode number is assigned to the...

Hi there, I am trying to get me date/time field in both the table and form to show only 0:00pm... 5:35pm as an example. I have tried a few different input...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

I am a novice at Access. I have just discovered there is a limit to the size of the database which I have just passed. I keep records of a coin collection in...

Hi folks, I have a continuous subform on a main data entry form. Each entry on the subform contains two controls - a combo-box and a textbox beside...

I've been reading past messages on calculated fields and realize the general advice is dont!!... However I need to hold a nominal ledger code against a record...

I have a table here that will store currency values. I've been reading up on the differences between the datatypes available and there seem to be 2 viable...

I need to know the advantage and disadvantage of split databases especially in multi-user updating, database sharing on file server and data corruption and...

I have built a table which has ~ 150 fields, and when I try to add more I get the rather cryptic error 'Property value too large' and the help button gives a...