Search results

Hi, I have multiple CSV files in a folder, some of them have a column heading "Employee", some of them don't. I want to click a button in Access that will search through the list of CSV files and return the name of the first CSV file where it finds the "Employee" column heading. I don't want to...

Hi, I want the ability within my Access db to export the current report showing on screen to PDF and copy it to the clipboard then remove the saved PDF (so end result is a PDF of the report copied to the clipboard that can then be pasted anywhere the user chooses). Can someone advise how to go...

Hi, I have a query in Access with a field called TimeStamp. I want this field to export to excel in DDMMMYY HH:NN When I set the field's property Format to DDMMMYY HH:NN in the query it shows fine in Access (eg 04Sep18 23:18) but when exporting to excel it gives an error (We found a problem...

Hi, I have a form with FromDate and a ToDate boxes. These boxes will only appear when a dropdown (called "Status") on the form is set to "Paid". I have a query that needs to be able to restrict the query results between this date range if the dropdown is showing "Paid", otherwise show all...

Hi, I've been programming in Access for umpteen years but have never looked at pass-through queries before. I want to see if it will optimize my db performance in any way. I have multiple SQL tables/views linked via ODBC to my front end Access db. As a typical example: SQL view written to...

Hi I have a database that's been working fine in Access 2013 but since the upgrade to Access 2016 I am getting an error in the VBA code that exports to excel. The error is: Unexpected error occurred: Type mismatch - Number: 13 Below is a snippet of the VBA code, I trapped the error to the...

Hi, Would very much appreciate people's input here as I am struggling to solve this and it is causing our users a lot of headaches. I am at my wit's end. I have an ACCDB 2016 Access database hosted on a single 2012 R2 server, split SQL back end, MS Office 2016. Each user connects to the server...

Hi, I have a large highly complex MS Access database that was previously accessed*by multiple users via*a networked company citrix server (front end)*and SQL server (back end). What are my options for taking this database and making it available to multiple users around the world who do not work...