

StrFilter = ahtAddFilterItem("Excel Files (*.xlsx)", "*.xlsx") 'Open the Save as Dialog to choose location of query save 'MsgBox The_Year & "Data Type = " & VarType(The_Year) 'Change the year from a variant to what we need in the SQL 'Get combobox value and assign relavent values to The_Year Set ctlCurrentControl = Screen.ActiveControl 'Get the name of the control button clicked (corresponds to query name to be run) This is the code I'm using (that refers back to Ken Getz's functions): Function exportData_Click() If your Access version is not in the list, you can search for it via a search engine. We have listed below current filenames, bitnesses and download links for some common installations of Access Runtime. If it is a 32 bit runtime engine, the filename contains either the text 'x86' or no CPU information at all.

It seems to be skipping over opening the actual dialog and runs straight to runtime error 2522 (file name required). If it is a 64 bit runtime engine, the filename contains the text '圆4'. Then build the Setup Project for either x86 or 圆4 as needed. NET Framework 4.0 SQL Server 2008 Express Windows Installer 4.5.
#Access runtime 2010 x64 vb error install
I now have it compiling okay but I am trying to use the file save dialog (code by Ken Getz). NET Framework 4 (x86 and 圆4) Microsoft Data Access Components 2.8 (If this prerequisite is not in the list, downlod and install it) SAP Crystal Reports runtime engine for. The next problem was a missing IPCONFIG.dll which I installed into the client machine. I initially had problems with comdlg32.dll but included the PtrSafe keyword. The client machine is 64bit windows and 64bit office. I've built an application on a 64bit machine (windows 7) running 32bit Microsoft Office.
