I have a database that has been split into a front and a backend database for a multi user environment. I needed to add an additional table and I could not...

I'm quite new to this so any help will be very much appreciated! I have a 'master' table that holds the core data on pupils (Each pupil has a unique...

I need to make a form for adding record to multiple tables. I used table relationship but I'm not getting it right I think.. plz can somebody help me with the...

I've been learning about linked tables ( splitting my mdb's to front & back end) and I remember reading some place that the record count property always comes...

I just turned off auto-index & now need to delete the duplicate indexes it caused. How?

Hi and thanks, I have a Journalist database for tracking writers from various magazines and would like a field that could hold the text of their articles as...

In 2000, when running my report I need to leave out all entries when a certain date field is missing data.

I have a database where users can only create one record per day in a table. The table is constructed with ID as primary key, UserID, Date, totalTime etc. How...

I have a databse with an Access front-end on everyone's individual PC sharing an Access back-end on the server. The tables in the back-end data file...

Hi, I've got a database design dilemma and was wondering if I could get some thoughts on it. I have a Goods table that tracks items that are imported from a...

Hiiiiiii first of all i hope u people are doing well. May God Bless , i have a problem with designing a table. i have a Field in my table that is for Date of...

I have a patient database shared among 10 people. Is there any way to prevent these users from going into the design view of the tables? I don't want anyone...

Hi, I am having great trouble getting my relationships correct with these 3 tables and after reading and trying many things, need to be put on a drip and...

Our insurance/financial advisor agency currently uses ACT 6.0 as our CRM to keep track of our customers, marketing to new customers, and reports for how many...

I have a question about indexing multiple fields and whether it's redundant to index the individual fields separately. As I understand it, if there is an...

I'm trying to put in an if/then statement for the C/O line of my address datebase because not all the records have a C/O. This is what I'm entering in the...

I am looking for advice on table and form design as they relate to database performance. I have a Main table with 48 fields. To organize my data better and...

I have the following tables (for business loans): Borrowers - Contains info on the borrower, address, financial info, etc. Loan info - contains details on the...

I have an application who's backend has a relationship defined one to one. I need to update the LIVE version of the database to reflect this for the...

The pressure is on people, need some help! My database has a table of "activities" to store drawings, documents and miscellaneous activities. I put all three...