Search results

Hello, I have a problem with a database that is full of data. It is used to enter a reference number and then the DB generates an Autonumber as a unique ID and primary key. the problem is the people that issue the original reference number have changed from a 9 digit number to a 10 digit...

I am manipulating an excel spreadsheet from my access database. I am having problems stopping excel prompt when I delete data in the spread sheet. I have setwarnings to false in access but that doesn't seem to effect Excel and I have also used application.displayalerts = False But it...

I have added a webBrowser control to one of my forms to allow people to get extra information from a sister web page. Everytime it loads the standard domain logins popup. Is there a way to pass the username and password to this popup through VBA? Cheers!

Can someone explain how to change printers when i Print a report. I have been playing with Set Application.Printer = Application.Printers("Myprinters") But i'm not sure if i am calling this correct can you just add a DoCmd.Print after ? Cheers

Hi I’m trying to convert some old queries into VBA to be run on the Fly. I’m having a problem with this. strSQLhistory = "DELETE tblCasualtyHistory.PeriodStartDate, tblCasualtyHistory.Comment, * FROM tblCasualtyHistory WHERE PeriodStartDate >31/12/ 2004 And Comment is null;" DoCmd.RunSQL...

Hi First post here so hope the topic is in the right place. I have inherited a DB and I am trying to automate alot of old stuff and convert the macros into better functioning VBA. My problem is one of the tasks that is performed is relying on a table that simply has dates listed to drop into...