I am in the process of building a small business, but God knows I need a strong and people friendly database for both the clients and employees. I would like...

I would like to create other subfileds after answering a yes/no question so once a answer has been choosen, then other type of fields appear to be answered....

Hi I have a form “Fob File” with a combo box for client, bound column client id and client name displayed. In the Job File Form is a sub-form client, this...

I've removed built-in menus and toolbars from by database, and created a custom menu and two custom toolbars. I want the 2 toolbars to show up together on the...

I am trying to take a date field and a text field and combine them to make a third field , which would be an Invoice number. The problem I have is the date...

I would like to know if the number of carachters in a field name can be increased. I know that the limi is 64.

I need to create an Access field with a fixed length of 2000 characters. This field is part of a fixed length flat file of billing data that will be uploaded...

Hello again, The boss has me working on another database. I guess they liked the first one I created. Anyways, I'm pretty sure this one is more complicated...

Kevin3NF reaches for the popcorn to watch this show continue... -- Kevin Hill President 3NF Consulting Link removed just to make people look for it...

I work at a health center where there are numerous research studies done. Part of my job is software support, and while I keep reading everywhere that...

Hello, I have designed many Access Client Server Applications before where I have the 1 MDB file on the Hard Drive & the data MDB file on the server & have...

Dear all, Please help me how to design table for FIFO method calculation. Thanks. Regards, Vensia

I am setting up a database for employee training records and need some advice about relationships. How should I set up the relationships? Our training records...

Hi, I am using Access 2002 and I am trying to put accounts numbers in a field call account number, the only problem I have is that I am unable to put 017108,...

I have created and APD in Access 2003 connecting to a database in MS SQL Server. When I try and ceate a query and save it, I get a message : 'This version of...

I have a database with parent-child tables where users enter text and numeric information in a form. The form source is a query linking the...

I am building a data base for a reality company and they need to select multiple appliances that are included with the sale, how do I create such a list in...

When selecting a modelID for a related table I have all the fields show from the lookup of the Models table because I have many different years and...

I am looking for an easier way to replace a large amount of text ie A to 01, B to 02 etc.... within two fields, currently i do this outside the datbase within...

How can I use DLookUp or other function in a Form to display data (say a persons name) as soon as the person's ID is entered in the transaction form? Or is...