So I have data that comes off our machines, there isnt much to the data that you can relate back to the access database.
Here are just a basic format of what I am trying to do, this actually didnt work that bad, however it did not put the data with the samples I wanted to, is there a better way of importing data, or can I make some kind of script that will tell the data to look for the matching WrenID (on the database) to the WrenID/SampleID (on the excel spreadsheet).
AccessForum.zip
I also need my database to be put into like a "window mode" not actually opening up access but opening it as an "application" (window mode) or an executable file.
I found this on a couple of forms, but clearly I dont want to pay for this, whats my bests approach? I know its all vba scripts but is there an easier way of doing it? would it need to be a executable file.
http://www.peterssoftware.com/ss.htm