Search results

Good Monring all, trying to get something working on a form. When creating a new client, due to privacy, we have to create a Unique ID for each one. The ID consists of their initials, the year, a serial number and the location. I have it mostly working except for the year. Let me show you...

Tying to export data to an Excel spreadsheet and it's works with no problem. But what I would like to add is a specific name in the .xlsx file name. I have a table with a single field and a single record with a name in it. I use this for other functions when running the DB. I would also like...

I have data from three sources that is not similar. Each is an Excel spreadsheet that I have imported into Access. Each has a field called LOCATION. The tables are Site1, Site2 and MasterList. The MasterList is the correct format. Here is an example of the data I have in the LOCATION field...

I hope the day finds everbody well. I am working on a project that just has me mind blocked and I'm sure it's a simple little thing, but I just can't get it. I have about 700 seperate Excel spreadsheets that I need to incorporate into a single database. Each spreadsheet has about 15,000...