Search results

I worked out the issue which was that the column count property was still set to 2. I adjusted to 12 and the update now works but unfortunately, now the dropdown looks a bit of a mess as it has all the additional columns bunched up to the right. Is there any way to have them included in the...

Thanks Trevor, It seems to be updating the first field (i.e. FirstName) only. The SQL for the Combo row source is SELECT tblMaster.ID, tblMaster.Network, tblMaster.FirstName, tblMaster.LastName, tblMaster.Title, tblMaster.Address1, tblMaster.Address2, tblMaster.Address3, tblMaster.City...

Hi all, My Db has a form in which I'd like the user to be able to click a button to copy name and address details from an existing record to the current record. The idea is that the button opens a small data-collection form containing a combo, they select the source record by name (no need to...

Fantastic! works perfectly. Thanks for all your help

This is the Module: Public Function SendTQ2ExcelSheet(strTQName As String, strSheetName As String, Optional strFilePath As String, Optional strRange As String, Optional blnIncludeHeaders As Boolean) ' strTQName is the name of the table or query you want to send to Excel ' strSheetName is the...

Thought it would be more helpful to post the entire call code Private Sub btnGene_Click() On Error GoTo Err_btnGene_Click SendTQ2ExcelSheet "qryGeneReport", "Income Leases", "H:\My Documents\Lease Summary - All Markets.xls", "A2", False SendTQ2ExcelSheet "qryModifiedLastMonth"...

Thanks The Save & Close code is in the Function. the other code is in the OnClick event of a button on a form. It seems to matter which was the active sheet when I previously closed the workbook. If the "Income Leases" was active, it populates that sheet, closes, then fails on the second...

Thanks. This seems like a simple solution but I may not be properly understanding it. I haven't ever put values in a loop. I added the following code to save and close the workbook after the first export: 'save and close Excel File ApXL.Application.DisplayAlerts = False...

Hi, I successfully used the above code, but was curious if/how it could be modified to run two queries and insert them, respectively into two separate sheets in the same workbook? Any help greatly appreciated. Thanks

Thanks for the replies. I don't really know what happened but it seemed to fix itself. 2000 users are happily opening the reports. Strange but true!

Hey, I have a Db in 2000 file format. During development my IT dept upgraded me to Office 2003 and I continued to work on the Db. I have posted the Db and 2000 users can open the Db fine, but attempting to run any reports seems to cause Access to 'encounter a problem' and freeze up. Eventually...