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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Comparing records between tables in Access using loop
I have to be able to link one record in the reschedule table to one record in the po table while decrementing the qty. If the first reschedule record states Qty Needed: 100 and the first po record states Qty: 500 and the second reschedule record states Qty Needed: 400 - I don't need to find...- guzzo
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Comparing records between tables in Access using loop
I am a beginner VBA user. I need to compare two tables in Access (97) and display results in a column in each table. The 'reschedule' table has the following fields: Item, NeededQty, NeededDate, count. The 'po' table has the following fields: Item, PO, Qty, DueDate, count1. I need to be able...- guzzo
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Record Locked - cannot access record
Already tried the .ldb - noone is locking the database. It's a 'locked record' that's causing the error - yet noone has access to lock any records (records are being downloaded directly - no data entry). If I open the database exclusively there aren't any errors - only if I open the database in...- guzzo
- Post #3
- Forum: Microsoft: Access Other topics
-
Record Locked - cannot access record
I cannot download information into Access 97 tables. Receiving the error "Cannot access record. Record locked by another user." Noone is locking/accessing/using/updating any records/tables during time of download. I need to find a way to clear record locks. Any idea of what's...- guzzo
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
