Search results

I haven't looked at all the code, but the query should be something like this for it to work: Private Sub cmdOutputXLSX_Click() Dim strSQL As String Dim strQry As String Dim myPath As String Dim sFileName As String 'Don't know what strQry is about, but hopefully fixing for...

Using DoEvents also helps if the form doesn't respond while the process is running.

Another simple way to debug is to let it provide a msgbox to show the result of the query string. Then look at that query string and see what's missing. strSQL = strSQL & " WHERE [Policy No] BETWEEN " & Me.PolicyFrom & " AND " & Me.PolicyTo & ";" msgbox strSQL Then look for the discrepancies...

I recently experienced issues with a query that works on MSA2016 64-bit (Windows 10) but throws an empty query result in MSA2010 32-bit (Windows 7). No errors ever came up, but the result is empty. Do you guys have any idea what could cause this? The SQL for the query is as follows: (not sure...

Yep Sorry - I replied but then wanted to do more research and put up a more accurate post so deleted mine. But looks like you nailed it mate. You guys are like machines with your quick-draw responses lol

1. Yes, that would probably help. How would you schedule a task like this, do you need to leave the MS Access application open or can you invoke this from outside MSA? However, manually updating the report should still be available to the end user. It is also dependent on another external...

I've gone through the code and it's using btWarning as the variable to pass through to ShowBalloonTooltip ShowBalloonTooltip "INFO - New version available", GetProgramName() & " version " & intWebVer & _ " is available for download from the " & GetCompanyName() & " website"...

This code works. However, I have a few more questions as I don't have a great understanding of the balloon popup code which I bastardized from another project. 1. I am unable to pass through another icon value, so the default displays MS Access icon. How do you assign a value to a variable of...

I'm reading through folders that contain data in the data storage area. The code reads the contents of specified text files in almost 20,000 folders on a remote machine. The information in these files are not saved in the SQL database, but we need to report their contents and link them to the...

Why don't you turn this into a sub where you pass along the name of the records? Then in your main code you simply run the same sub for every record.

Hi all As you cannot run threads in VBA, I was thinking of using a notification in the action centre to update the user with the status of the report. The report code runs for about an hour, so I want to update now and then just to indicate what the status is. (I can roughly calculate the...