Search results

Thanks, Wayne. I'll try it tomorrow and let you know. Mike

Hello. I would like to have a button on my form that, when pressed, would copy all data that exists on the last record to a new record. However, there is a date field that I would like to update to the following day for that new record. And I would like the button to be visible or enabled only...

Absolutely perfect, jfgambit! Thanks a million! Mike

Hello I have a combo box on my form that lists the values of a date field. It is an unbound control that I set up with the wizard to search for certain records in the table from that date. It works except for two problems: 1). The dates in the combo box are not in chronological order, they are...

Thanks, guys. That OnDirty Event (A2K) for the form will work. Mike

On my form I have a field that is updated automatically to today's date whenever a new record is created. There is another field that I would like to have updated with the current date whenever a change is made to any field(s) for that record on a later date. Otherwise the field should be blank...

Can someone please help me? When trying to create a data access page from an existing table using the wizard (Access 2000). the page is created with no apparent problem. However, when I try to view the page in IE 5.5, I get two error messages. The first says: "Could not find file (path to...

I have a table with six fields. I have a form for data entry to this table. One of the fields in the table is a date field. I would like to add a button to the form that would run a macro that would, after one record is entered, create four more records. These four records would be identical to...

Lyn: Your suggestion worked perfectly! Thanks. Mike

Thanks, Lyn. I'll try it tomorrow and let you know how it works. Mike

Hello. Can someone tell what VB code to use for a button on a form to open a different form with blank fields for a new record? There is an AutoNumber field in this form. Suppose the name of the form to be opened is "NewForm". Thanks. Mike