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

One field, the primary key, was indexed or sorted into a different order. The other fields in the table, however, did not change along with it. Now I have a...

I have created a database of training courses and trainees. Table 1 = Course Data (course name, date, venue, trainer, invoice no. etc.) Table 2 = Trainee Data...

I have a field titled PageNumber in a table that is not showing up in my columns, although it is checked in the design view and is not hidden. On the form...

I am using Access 2000 I created a main Db a while back, with let's say 20 different fields. Now I want to change the Db by eliminating 3 of the fields. At...

What is the longest string of numbers that you can have in a Number Field. I have an eBay database I have created and it was fine inputting the item # into...

Hi All, I am working on a scheduling program. We need to schedule shipments of orders and pull from stock. The orders would be in a FIFO method or First In...

This may be more suitable for the new users section since I'm a new user, but it's about design, so I'll try here first. I've got a monster spreadsheet I'd...

Access 2000 on XP Home Edition I have run into a first-time situation where the Link Text Wizard will not access a legitimate text file. Instead of opening...

So I split my database and noticed performance was way slow so I took suggestions by removing record source from forms and adding to the On Load Event. Well...

Hello, I have two databases that are stored in the network. One of the database is the front-end, the other is the back-end. When trying to enter a...

Databases and spread sheets have developed exceedingly beyond the old fashioned "file card" method. I would like to see a file card software in two forms...

Hello, I am trying to devise a system for checking out files and I have four tables 1)Files in file room 2)People who check out files 3)People who deliver...

I am using Access 2000 and Windows 2000 Pro. I have been trying to debug a MS Access 2000 DB that has the following issue: When I open the Database and go to...

Hi All, I really will appreciate help in this one. I have an Access 2007 client linked to a MySQL database which I connect to using ODBC. At times when...

I am trying to create a dbase for employee file reviews. On paper each review, lists: the employee, manager, district, file #, date of incident, customer...

I'm trying to normalize a table using the analyze feature. The table has student information for each student in the county including their teacher and school...

"File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." What does that mean specifically? I'm trying to split a table into several...

File Sharing Lock Error when Replicating or Setting Replicable property for a table; please advise as to why this is happening. I found info that has fours...

I have an MS Access 2007 database. The data tables (about 5 tables) are only about 4MGs, but when you add the reports (about 10 reports) the file size jumps...