Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Appending data from non related tables
Thank you for you help. I almost have my database setup as you suggest, apart from an events table. How would I set this up to track progress of orders over 10 differant production stages(event stages)? This is basically so as we know how many units of time are waiting to be done at a certain...- cracky141
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Appending data from non related tables
Sorry Forgot to attatch sample code to previous posting. Function AddWorkInProgress2(JobNumber) Dim Criteria As String, StrMsg As String Dim Db As Database Dim rst As Recordset Dim rst1 As Recordset Dim fld As Fields On Error GoTo Err_AddWorkInProgress2 AddWorkInProgress2 = False Set rst =...- cracky141
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Appending data from non related tables
I have a production schedule database that tracks work in progress. Done in A2002. I wan't to get the first value from the first field to contain a value for each customer. Then append this data to a new table. I have a schedule table with ,for example...- cracky141
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
