Search results

Very nice pbaldy. Simple and it works great. Thank you.

Tbl_Customer has 2 fields. IntID - AutoNumber Name - Text Using VBA code in Access I can obtain the value of a newly created Autonumber. Because Access creates the Autonumber when the record is created, the code below assigns iIntID the newly created number. Set rs =...

I actually found what I was looking for. I have a Freeware install application that allows me to start my access application after it installs it. The install application requires that I include the path to the MSACESS.EXE executable in order to run my access application. The version on...

Is there a registry setting that tells me what version of Access is installed on a Windows computer?

CreateInstall works Great. It does everyting I want to. It even runs the access application after it installs it. However... Some of my clients are running Access 2007, others are running Acess 2003. in the "Run Application" portion of the CreateInstall I put in the path to MSACCESS.EXE in...

I would like to make an Access 2007 application available to my clients via a web download. Some have Access installed, other do not. So I have used the Package Solution wizard to make an Installation package which also deploys the access runtime. I'm able to Zip all neccessary files to a...

Right on Bob. What a difference that made. Thanks for your help.

The client resides on the local and has linked tables that reside on the network.

I have a simple for that has a couple of list boxes, a couple of combo boxes and a couple of sub forms. While designing the form, it takes forever to open it and save it.

WOW. You guys are AWESOME... . Changed: Set objWord = GetObject("", "word.application") To: Set objWord = CreateObject("word.application") . Changed: objWord.ActiveDocument.Tables.Add Range:=Selection.Range, NumRows:=1, NumColumns:=2, _ DefaultTableBehavior:=wdWord9TableBehavior...

Using Access 2007, the following codes produces the following error: . Code: Dim objWord As Object Set objWord = GetObject("", "word.application") objWord.Documents.Add objWord.Visible = True objWord.ActiveDocument.Tables.Add Range:=Selection.Range, NumRows:=1, NumColumns:=2, _...

I was using some old code. I changed it and got it to work. See below... Old code: Dim objOutlook Dim ojbOutlookMsg Dim objOutlookRecip Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) With objOutlookMsg Set objOutlookRecip =...

Thanks for the quick response DJKarl. I tried Late binding and it works great for Excel and Word. I can't seem to get it to work with Outlook. (forgot to mention I call on Outlook too) :rolleyes:

Is is possible to set my library references at Application Startup? I have an application that needs to run on a 2003 platform and a 2007 platform. The application refers to Word and Excel libraries. I'd prefer not to use a macro to do this. Tom