Search results
-
W
VBA error when trying to break link in Excel Workbook
Hi, Am using VBA code in Access 2010 to create a new Excel Workbook, copy a sheet to it from another Workbook, break links and save: ' Create new spreadsheet for final report Set oXLNewBook = oXLApp.Workbooks.Add oXLBook.Sheets("Report").Copy Before:=oXLNewBook.Sheets(1) ' Define...- Will Sidwell
- Thread
- Replies: 1
- Forum: Modules & VBA
-
W
Problem with OpenForm & SearchForRecord
Hey Folks, Am using a combo box on my Clients form to search for records using: DoCmd.SearchForRecord acDataForm, "frmClients", acFirst, "[numClientID] = " & Str(Nz(Screen.ActiveControl, 0)) This works fine when I open the Clients form myself but when I use OpenForm: DoCmd.OpenForm...- Will Sidwell
- Thread
- Replies: 2
- Forum: Modules & VBA
-
W
Hey Folks
Have been programming on and off for 30 years. Currently living in Greytown at the bottom of the North Island in New Zealand. Its been a while since I last designed in Access but am picking it up. Looking forward to being part of the forum- Will Sidwell
- Thread
- Replies: 1
- Forum: Introduce Yourself