Help designing a group update form

[jzwp11]

Another thought about that. Could I add two new fields in the Assets table for "UpdateUsage" and "UpdateUsageDate" ? Then I could bound the text boxes couldn't I? And wouldn't that also make it easier to run an append query on?

In terms of the query, it would not matter since you still need to get the values in the controls whether they are bound or unbound to do the append to the asset usage table..

I would also worry about normalization since you technically would be violating normalization rules.

[10 Gauge]

In terms of the query, it would not matter since you still need to get the values in the controls whether they are bound or unbound to do the append to the asset usage table..

I would also worry about normalization since you technically would be violating normalization rules.

10-4. We'll wipe that idea from the docket!

Any idea why the append query isn't moving any data to my table? It's not throwing me any errors either, but when I check the table nothing has been added.

[jzwp11]

You only built the append query, now you have to execute it

currentDB.execute mySQL, dbfailonerror

[10 Gauge]

Ah, ok.... Didn't know you had to execute it, kind of figured that execution was assumed as a button click event.

Now it works! Thank you greatly, once again sir!

How do I get that line to grey out once it's updated?

[jzwp11]

I don't know if you can since any thing you do will probably carry through to all records. The other option is to only include records in the form that have not been updated in some period of time and then when you do the append query, requery the form's recordsource and have it drop any newly updated records from the recordsource.

[10 Gauge]

I don't know if you can since any thing you do will probably carry through to all records. The other option is to only include records in the form that have not been updated in some period of time and then when you do the append query, requery the form's recordsource and have it drop any newly updated records from the recordsource.

10-4. I'll get feedback from my guy on this and see if he likes it, if so then we'll just go with it!

Thx again!

[jzwp11]

You're welcome

[ssanfu]

PMFJI, I've been following this thread - this is how we handle data entry.


A button opens the data entry form, using, in part, this line:

DoCmd.OpenForm "enter hours", , , "[hbh_hours] = -1111"


In the form open event, we have code that creates a recordset of active employees by company and division. The code loops thru the recordset, entering a new record in the hours table for each employee, entering a -1111 (minus quad ones) in the hours field.

When the form loads and displays, it is filtered to only display records with the hours field = -1111. The form record source is a query with the employee table, the hours table and a few other tables.

The actual hours are entered for each employee, various other fields have data entered, calculations are performed and the record is saved.

When the close button is clicked, we run a delete query to delete any records that has a -1111 in the hours field.
The SQL is: "DELETE FROM hour_bank_hour WHERE [hbh_hours] = -1111"


I'm not real happy about adding/deleting so many records each time the form is opened due to bloat, but it ensures no employees are missed.