check out eh naming conventions
If you are on
Main form Sub 1
To refer to a form property, like RecordSource
On Mainform Me.RecordSource Me.Parent.Recor dSource
On Sub 1 Me!Subform1.For m.RecordSource Me.RecordSource
On Sub 2 Me!Subform1.For m!Subform2.Form .
RecordSource Me!Subform2.For m.RecordSource
To refer to a control
On Mainform...
User Profile
Collapse
-
You might try a union query for the two tables and then summarizeLeave a comment:
-
-
Try debuging as follows
dim sql as string
sql = "UPDATE IndividualSetti ngsTbl SET IndividualSetti ngsTbl.Date = #" & stDate & "# "
sql = sql & "Where IndividualSetti ngsTbl.UserName = 'ZMoor';"
debug.print sql
docmd.runsql sqlLeave a comment:
-
Why not just append the old info to the new table and let not have two tables storing the same info?Leave a comment:
-
In the query use format to as follow:
Format([eventdate], "w")
then group by on the employee id and the above column and sum on the hours fieldLeave a comment:
-
Try
field5: iif(field4 = 0, "Yes", iif(field2 > field3, "Yes", "No")Leave a comment:
-
Archive value for combo box.
I would like to have the ability to archive values in a lookup table. Take the following example
lookup table
luid, label, archive
1, green, No
2, red, No
3, blue, No
select * from lookup table where archive = false
I insert the above rowsource into a combo box. It works perfectly.
The users decide blue is no longer a valid color. You change the table as follows:...
No activity results to display
Show More
Leave a comment: