-------------------------------------
You don't need the field work activity 2.
For each activity, you just create a new record. The date and set are enough to make the information unique. You can then report your acitivy based on grouping by date or set. If you have someone that does an activity more than once a day, you may want to also include a field for session number.
If you plan to use this log for different people,...
jkantner
Last Activity: Sep 22 '06, 08:43 PM
Joined: Sep 19 '06
Location:
-
-------------------------------
I hate to tell you, but you really should already have at least 3 tables. One for the departments, one for supervisors and one for the employees.
The department table would have a department id, department name and whatever else you would like to know about the department. This allows for flexibility of adding/changing/deleting supervisors and employees.
Then the supervisor table would...Leave a comment:
-
------------------------------
Use the query wizard to help you get started. Select query/new/find unmatched query wizard.
This will help you to build a query checking one field in Table A that is mismatched/missing in Table B you are comparing to.
When it is finished, Notice in query design mode that the table B field you selected does not have 'show' checked on and its Criteria = is null.
Now you can add the other Table...Leave a comment:
-
-----------
When you create the list box use the wizard that Access provides. Respond to each question.
-- 1/ look up the values in a table or query...select table
-- 2/ select the table with the values you want to select from
-- 3/ select the fields you want to display in your list
-- 4/ size the box as you want
-- 5/ Now, this is where you get to tell it where to store the value. I am guessing you...Leave a comment:
-
-------------
Microsoft's web site http://support.microso ft.com/kb/q208946/ has good sample queries and result pictures that show how to number and rank your data....Leave a comment:
-
-----------------
I use VB code.
I first import the records into an empty temp table.
'Process found files
If Len(.FileName) > 0 Then
For i = 1 To .Foundfiles.Cou nt
FoundFile_str = .Foundfiles(i)
DoCmd.TransferT ext acImportFixed, "SAP_Incoming_s pec", "Tmp_InBound_SA P", FoundFile_str, False
------
Then I process them into the main table...Leave a comment:
-
capture error message: can't append all the records
I am importing text files and using the data to create the records for a table with keys.
If the user tries to import the same files twice, they get the huge error message that includes 'can't append all the records'. I know this is due to duplicate keys.
What I would like to do is capture that message before it goes to the user and give them a more friendly message like 'You have already imported this data'.
I tried to capture...
No activity results to display
Leave a comment: