Good Morning, Afternoon or Evening,
I am certain this question has been answered somewhere, but I cannot find the specific answer, or just don't understand it. Thus, my query here.
Can someone tell me how I can write individual records on my home computer and then, without having to cut and paste every field, copy or import these individual records into the office database.
I work in an office that operates a server which I do not have access to when I am not in the office. On that server, there is a database of all the information entered into individual report forms we use. You open Access and you start at the last record entered. I gather information while I am home and on-call that has to be entered into an Access 2013 form at the office.
I have access to the entire database of records while at the office and have copied the entire database to a thumb drive, so I have access to records at home, but that is not my problem.
What I want to do is write the records at home, on my home computer on the company form, copy them to the thumb drive and import them as individual records in the database at the office. There is one piece of data, a case number, that does not get assigned to the form until I get to the office, but everything else, I have at home. I can add the case number at the office before I import the data if need be.
I am aware I could complete the form, save it to the database on my thumb drive and then overwrite the entire database on the server, but I REALLY don't want to do this as it would screw up a couple of thousand records if I messed up. Thus, my desire to import individual records.
I appreciate your tolerance as I am a newbie to Access as well as forum posting. My knowledge of coding is non-existent, so any kind of programming requirement would be lost on me.
Thanks for any help!!
Bill