Search results

Dim strQry As String Dim strSaveFile As String If (srchFrame = 1) Then strQuery = "qry_in" Else strQuery = "qry_out" End If strSaveFile = Application.CurrentProject.Path & "\" & strQuery & "_" & Format(Date, "yyyymmdd") & ".xlsx" DoCmd.TransferSpreadsheet...

Task manager in Access? (where to find?) The problem at transferspreadsheet is that i have to use a file i want the data to transfer to, which is not an option for me as mentioned above, that is a shared database and everybody saves it to their own directory.

Not much, 2-4 seconds? Give or take, not longer. Opening the query itself is fast but when trying to run the query in form takes long.

You mean the query in the database or when its exported to an file? When i scroll to the last record, how long does it take or how many records are there?

Sometimes it doesnt open at all, freezes the whole screen and the only way to get out of it is to close the database. Sometimes theres an option to restore the program but sometimes it opens after few 5-10minutes or not at all. If it opens then usually takes 15minutes minimum if i had to stopped...

Thats not it ... tried to use a direct file and path, but still doing the same problem also when set as false for auto opening the file. Office repair? Everything is closed and when I try to save it, i save it under a different name or to a different path, so that's not the problem also.. 😪

Well I put True to open the excel right after i exports to an excel file, if u meant this. But this is a shared database so usually it exports to the default file where the user saves it himself, thats why theres no direct file to save the excel.

Hello, I've searched this problem everywhere, but couldnt find any solution, that would help my case... I have a form, where in a frame with the option boxes i can choose either out or in data, by choosing the selected option i then click on a button, that has a code to export the data to...

The query is created as view in the backend. I've tried to create a query in the frontend, but the performance of query was to slow so made one in the backend. The query looks like a table in access so i suppose its not changeable in the frontend and have to update it in backend? Not sure where...

Hello everybody! I'm new to Accessworld. My name is Tea and I'm beginner in programming, also working on projects in Access, but still getting to know access. Hope to learn few tricks and get more knowledge in Access here.:)

Hello, I'm trying to solve this problemfor a quite a while and still can't find solution for this. I have a form where in details are checkboxes (fixed, not fixed, in process,... ) placed that should be editable, but can't check any of them. Check boxes are Enabled and aren't locked. Edits are...