regnewby2465
Member
- Local time
- Today, 00:39
- Joined
- Sep 22, 2015
- Messages
- 58
I am very green at VBA and designing Macros so hopefully this can be done without either.... but if not, I can certainly give it a try. I have created database in Access 2013 that is intended to be used to record the employee's activity for the shift. Each employee has their own laptop and on each laptop, I have a front end and back end database. Front end is called WPDTables with a number of tables therein that are linked to WPDCAD database as the front end. The employee enters data while in the field. Just as a side note, each laptop does have connectivity through verizon.
My goal is to design a method either programmaticaly or manually where employees' data can be compiled together so that I can run reports from one "master" source than separate individual sources. If I was doing this in a network environment then I would have employees access the "master" back end db accessed through the the LAN and therefor eliminating the need for each employee to have a back end on their laptop. Unfortunately, the employees do their data entry outside of the network in the field.
I have played around with putting each laptop's back end in One-Drive but as you can imagine, syncing is a nightmare. I have pretty much abandoned that route.
My next thought would be to design a method to programmaticaly or manually append the data that is on each separate back end into one "master" back end in the office. I am believing that to do this, the primary keys in each separate back end would have to be unique to the laptop. If not, when I would try to append, a primary key that was once unique on its own laptop is no long unique in the master.
Does any one have suggestions? I think I can pull this off if someone can help me with a macro or VBA that will create a custom primary key that would be unique to the laptop. Perhaps a combination of the employee's ID and autonumber? Or since there would only be one or two employees working at one time, is there anyway to use the Now() as a primary key without any formatting? Thanks for any help.
My goal is to design a method either programmaticaly or manually where employees' data can be compiled together so that I can run reports from one "master" source than separate individual sources. If I was doing this in a network environment then I would have employees access the "master" back end db accessed through the the LAN and therefor eliminating the need for each employee to have a back end on their laptop. Unfortunately, the employees do their data entry outside of the network in the field.
I have played around with putting each laptop's back end in One-Drive but as you can imagine, syncing is a nightmare. I have pretty much abandoned that route.
My next thought would be to design a method to programmaticaly or manually append the data that is on each separate back end into one "master" back end in the office. I am believing that to do this, the primary keys in each separate back end would have to be unique to the laptop. If not, when I would try to append, a primary key that was once unique on its own laptop is no long unique in the master.
Does any one have suggestions? I think I can pull this off if someone can help me with a macro or VBA that will create a custom primary key that would be unique to the laptop. Perhaps a combination of the employee's ID and autonumber? Or since there would only be one or two employees working at one time, is there anyway to use the Now() as a primary key without any formatting? Thanks for any help.