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...

ok, forget about deleting it afterwards, so I still need to be able to take any current report showing on screen and make it ready to paste as a PDF. Can anybody else advise. Thanks

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...

I need the field from the query to export in format DDMMYY HH:NN so how do I achieve that. Thanks

Hi thanks, but can you clarify what you mean there? Note that I'm not using a format function for the query field, I am using the query field's "format" property, so not sure what "create a similar query without formatting" means? Cheers

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...

Thank you both. Mark - that works perfectly. Thank you very much!

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...

Thank you doc man, turns out it was indeed references, I removed the Excel 2016 reference, added it back, everything worked.

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...

thanks, I have the batch file working, where should the batch file reside - network share or local profile. If on network share and say, two people launched their db shortcuts at the same time, so two people running the same batch file at the same time - does that cause issues?

Could you share the details of how your updater works and how to create it. That would be most helpful to me. Thanks

Managed to trace it to group policy File Copy (User Config - Preferences - Files). This is used to copy the accdb from central location to user's documents folder at remote desktop logon. The file seems to copy fine when they log on (replaces the one that's there). They are definitely then using...

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...

They have internet access, I meant they are not part of a company network (no servers). Without any servers the only citrix option is citrix in the cloud which is very expensive. I need a low cost solution of enabling people to access it remotely. Thanks

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...