Search results

Hmm... How about... frmItemIssue Autonumber: pkID Lookup: fkEmployeeID Trouser: 1 Helmet: 1 Glasses: 1 frmItemReturn Autonumber: pkID Lookup: fkEmployeeID Trouser: 1 Helmet: 1 Glasses: 1 fkEmployeeID will show the initial transaction with a negative balance ("Employee owes 5 items...

Use your second option. Your manager should be able to easily query work date ranges via an unbound form into a report much more easily the second way. Plus it's proper design. Good job. Also, if you wanted to really get specific, you could instead just have a start-shift and stop-shift...

Soon, I will be starting an access database to inventory an entire building's IT assets which include computers, monitors, laptops, tablets, servers, switches, taclanes, etc... All of these items have Serial#'s that are.... quasi-unique... We are moving 10,000+ items to a new building soon...

I was able to merge the data a while ago by using union...

We have a SharePoint 2010 Issue tracker at work that we pull metrics off of. So we add a record and assign it to a person. Lets say another person ALSO worked on this item, so we MUST give them some credit. So Tech1 has a record of working on an item. Tech2 and Tech3 are placed in the...

Sorry for letting this thread die with no resolution! I talked with a buddy of mine and he simply moved what I was doing over from the Query into a form.. So it was pretty straight forward. I simply needed to write it VBA with SQL references to the data. If anyone is having an issue with...

I have a table with 4 fields. Each field is supposed to be randomized. So i have the following: organizations (50), measures (20), days of month (31*6 to make 186), times of day (200). Each month I want to click a button that creates a table that has 186 records (1, 1, 1, 1, 1, 1, 2, 2...

It sort of depends on how proficient you are in Access.. What used to take me 8 hours takes me about 20 minutes now... So back then, OF COURSE I would copy/paste! But now, it's not worth the trouble since I can write it in the same time and grow a better understanding of how it's going to work.

did you not delete the call to the macro from in the form? (onload)

Thank you for the reply. The reason I need each to be "random" is because my operating instructions state they must be random to be in compliance. To answer your question: yes. I have mutliple tables for each datatype. oragnization is paired w/ organization_ID, action w/ action_ID, detail w/...

I have a need to randomize multiple records against eachother (see below). ONE record should consist of: Random day from 1-32 (each day can only occur 6 times, if possible). Random organization from organization1, organization2...organization200. Random action from action1, action2... action...