Search results

Thanks for the replies. I suspected that the problem was some form of corruption. But I was not sure if there was some programming that might help find a problem and fix it. It is good to know that I was able to (hopefully) fix the problem without it. Here is what I did: I deleted the data...

About once a week I run a compact and repair to my database and save a copy for a backup. After the last compact and repair the database has not been able to open any forms. The tables, queries and reports all seem to be running as usual. The problem is with the forms. When I try to open a...

Here is what I don't understand. My tables are currently related through the unique AutoNumber field. Each HSSupply record contains the related HSContcode. Each HSContact record contains the related HSInstcode. If I update or add the number in the original table, then the records will no...

Thanks for your response. I think that I have answered all your question here. If I misunderstood something, please let me know! I previously built the database with separated contact and order tables so that the database would not be storing the same information several times. The database...

I am trying to combine two different sets of related tables into one. Is this possible? In a 97 Access Database I have the following tables. HSInst HSCont HSSupply COLInst COLCont COLSupply Each table PK is an AutoNumber field. The HSCont table contains the HSInstCode, the HSSupply table...

I'm not sure if this will help, because I am pretty new at this, but I thought I would give it a shot. I think I have a similar set-up. I have 2 main tables with forms, Institutions and Contacts. The Contact form is a subform of the Institution form. On the contact form, I have created...

Thanks you so much for your help. I changed all the text fields to Allow Zero Length to yes. Then I did a side by side comparison and found that one field was null in some cases and also a required field. Once I updated all the requirements, the append query worked! Thanks Again!:D

I am having a problem appending data into a table that has the structure and referential integrity already set up. The trouble is that I am getting an error for about 70% of the records due to validation rule violations. However this data is coming from two tables with an identical relationship...