Just returned from a 3 week vacation and tacked this issue afresh
This is more a "work around" rather than a solution
After the DoCmd.TransferSpreadsheet action, if the workbook is programmatically closed and then reopened, the ghost window disappears
If I understand your issue correctly, when you use a form you can
a) Store the non parameterised SQL as a variable
MyVariable = Currentdb.Querydefs("QueryName").SQL
b) Add the parameterised SQL string
Currentdb.Querydefs("QueryName").SQL = "A Text string containing parameterised SQL"
c)...
Hi Ranman 256, I agree this is weird
I used [Task Manager] to see what was running as I stepped through the code and there were no instances of Excel until the transfer spreadsheet command
Equally, when I manually tried to hide the "ghost" the "real" data became hidden leaving two empty...
Hi
I am in the process of migrating users from Access 2010 to Access 2016
I know that Excel 2016 creates a separate instance of Excel for each individual workbook but after.....
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "_Debug", ExportFileName....when I make Excel and...
Hi
I recently had to come up with some code to upload a ZIP file to a sharepoint site and set (existing) document meta tags.
I thought it would be reasonably straightforward use Microsoft Access 2010 to take a ZIP file produced by a Microsoft operating system and upload it to Microsoft...
Access stores -1 against any check boxes which are ticked and zero against any checkboxes which are unticked
When they are ticked your query is basically multiplying -1 by an integer which will produce a minus figure or by zero which will produce zero
I think the last option may have to be....
'#' & format([MyDate],'mm/dd/yyyy') & '#'
...or else the calculation will be returned as a string instead of a date ?
If you only have a few cities, use could the SWITCH function ?
SELECT Switch(City='San Diego','CA',City='Las Vegas','NV') as State
...not recommended though if you have thousands of cities and 50 states
You can use the code below to open Excel and copy the contents of a worksheet to the clipboard which you can then paste into word
Rem *********************************
Rem Open Excel Workbook
Rem *********************************
Dim WB As Object
Dim WS As Object
Dim XL As...
Hi
Am I understanding your problem correctly ?
a) You want to use Access to open an Excel file
b) Then use Dynamic Data Exchange to transfer data in the Excel worksheet into Word
You can explore using VBA to hide stuff
Rem*******************************************
Rem 2015.04.20.01 Set Title
Rem*******************************************
Dim prp As Property
On Error Resume Next
CurrentDb.Properties.Delete "AppTitle"
On Error...
The problem is your criteria
You have field names with the same name in more than one table in the same recordset
try rst![TableName.ShippingServiceID] =7 or.....