Search results for query: *

Thanks again MajP, for your help. I put the code you send and I get the same run-time error ‘3078’ and I copied the table name to the code so I know I did not spell it wrong. I am not shore if I understood correctly the line of code about ‘tblTempImport’ I understood it to mean put the name of...

Here is the code thank you for looking at the code. Private Sub Form_Current() Dim rst As DAO.Recordset Dim lngCount As Long 'I named the table SLE_database_study_and_past_medical_History Set rst = CurrentDb.OpenRecordset("SLE_database_study_and_past_medical_History") With rst...

thanks for your help but i still do not quite get it. i tryed to put in the code you suggested (rs.BOF And rs.EOF) Then but i get a run-time error '3078' thanks again for your help.

Thanks Dontremb, I would except the entire Database is based on a paper form that date back some 30 years. So over the years things that were next to each other moved to other parts of the form and so parts became so large I gave them there own Table

I am sorry I don’t follow.

Thank you Dontremb, My tables are related with a one-to-one relationship and I m using accesses 2000.

Thanks FancyPrairie I joined the two tables in a query and changed the Properties in the table and that did it, I can now enter data in this form. (Thank you) Not shore if you will be able to answer this but how do I record the ID(name) field of both tables? Hear is what I mean Both tables...

Hello I am having a little trouble with my database. The Database has a parent table with 5 or 6 children tables in it they are linked by a common id filed. The problem is that the children tables use a VBA to display there Record number in a text box. The code works fine when they are...

The database has a master switch board with 5 main tables and in one form I need a few fields from one table and a few fields from another table to be display together in one form.

Hello I am having a little trouble with by database. The Database has a parent table with 5 or 6 children tables in it they are linked by a common id filed. The problem is that the children tables use a VBA to display there Record number in a text box. The code works fine when they are...

Thanks

I wish to make in amendment on my statement about the two older threads not working the program from the older threads works grate. Except I get the same run-time error as when I put the table in the parent table the error is “run-time error ‘3021’ ”

Populate Record Counter of x of y Hello I am having a little trouble with by database. The Database has a parent table with 5 or 6 children tables in it they are linked by a common id filed. The problem is that the children tables use a VBA to display there Record number in a text box. The...