Search results

Check VISIBLE properties in DETAIL of this form.

Send a short example of your mdb (access 2000 or 2002-2003), and say what is the problem.

Check the properties VISIBLE (for every field). It must be YES.

As I can understand you, in this form put DATA ENTRY = No (properties).

Look at "DemoStartDateEndDateA20022003.mdb" (attachment, zip). Look at Table, Query, Form. Open Form1 and try. Adapt it in your mdb.

You don't need the same data in the table. It means that your tables not normalized wel. Learn something about DATABASE NORMALIZATION.

Did you put the code in "SUB FORM_CURRENT", (instead of "Sub Form_ Load"), in subform ?? Look at attachment, Access help (word, zip).

Ok, I understand.

Put blank i INPUT MASK properties, and put NOW in DEFAULT VALUE properties. For that field i the table DATA TYPE put DATE/TIME, in Format properties put GENERAL DATE.

Send a short example of your MDB, (Access2000 or 2002-2003), and say what you want to do, (what is the problem).

Look at "DemoSubNRecordA2000.mdb" (attachment, zip). Open frmMAIN and see. Put it "ON CURRENT" event (instead "ON LOAD"). Look at VBA.

Try to do this via query, (append query, or update query).

Maybe your husband is a genius, but he have to learn more about Access. Look at "Demo2FormsA20022003.mdb, (attachment, zip). Open Form1 and try. Look at VBA, (Form1, Form2, Report1).

I think you need something like "DemoTwoDataA20022003.mdb", (attachment, zip). Look at Table, Form. Open Form1 and see.

Send a short example of your MDB, (access 2000 or 2002-2003), and say what you want to do.

My mistake, it is Access2000 (not Access 2002-2003), sorry.

OK, I know what you want. I thought you knew a Primary key, or any other data in record. Look at "DemoGoToRecordA20022003, (attachment, zip). Open Form and try. Look at VBA. In the table you have got 10 records. When the form open the first record is on the form.

It must be you make a mistake somewhere.

I think you need something like "DemoFindA2002.mdb" (attachment, zip). Open frmForm1 and try. Look at VBA. Adapt it in your mdb.

Look at "DemoRuningSumA20022003.mdb" (attachment, zip). Look at Tables (I added 1 record), Form1 (VBA), Query, Module1. Open Form1 and try. I made the first query only.