Search results

Thanks, Jack! That worked! And it was pretty easy. Informative details for anyone else: From my blank new database, File - Get External Data - Import Locate old database to import from. Import all tables (and links), queries, forms, reports, macros, modules, and under Options: custom tool bars...

Attached is a simplified sample of my database. There are 2 forms, frmCustomerNotesWorkingVersion and frmCustomerNotesNONWorkingVersion. If you go into the BeforeInsert event in each and highlight the Date or Time word, right click for the menu, then go to definition, you will see that in the...

I just tried putting in your suggestion: Me![UpdateDate] = Date It gave me the same error message. I am using other Me!FieldName.Value = function code and the other code works fine. The problem seems to be in the definition of Date itself. And ya, I know Updatedate doesn't look good by itself...

I have a form based on a query based on a table. I imported the original table from another database. I initially failed to realize the problem with a field in that table named “Date”. I set up a query using the same name, then a form to display the info with that same field name. Now, when I...

That worked! Your use of the DLookup function solved my problem. I had known that the DLookup function could be used as the following, with Table B being the lookup table: DLookup ( “Table B field name that contains wanted values”, “Table B name”, “Table B field that matches Table A linking...

I am trying to make a Query that looks up info in a table based on the row and field info. The Query gets info from Table A and Table B. Table A has 2 fields of info that are used to lookup info from Table B. Table A C1 C2 (fields) 10 L1 10 L3 22 L2 Table B N L1 L2 L3 (fields) 10...

I have a report grouped by SalesAgents and their Customers. I am printing on a duplex printer. Each SalesAgent gets their own report showing their own customers. The number of customers for each Sales Agent can be anywhere from 1 to 1000. When I print to my duplex printer, any SalesAgent...