Search results

I have been using this sort of code to populate Word with great success Dim objWord As Word.Application Dim wrdDoc As Word.Document Dim strPath As String strPath = tempath Set objWord = New Word.Application With objWord .Visible = False .WindowState = wdWindowStateMinimize End With Set wrdDoc...

Got it working, needed objWord.Quit Set objWord = Nothing simple in the end got the sequence the wrong way round. See ya. :)

Tried that thanks but it comes back with Expected Function or Variable

I found a nice piece of Code in the forum to send data to word and populate form fields rather than using mail merging with an exported text file. It works great but the problem I have is Word stays open after the job is complete. I have told it to save as the finished document which it does and...

Hi If you put ?"Name" & Space(20) & "Fred Bloggs" in the intermeadiate window it does exactly what is says it should do and put 20 spaces in, also "Name" & Chr(32) & Chr(32) & "Fred Bloggs" in the window puts in two spaces as I would expect. Something wierd going on, when it arrives at...

Hi I tried the "Name" & Space(20) & "Fred Bloggs" but it still came out Name Fred Bloggs Thanks though.

Silly one really I should know the answer but. I am trying to put spaces into a string that will be used as the body in an email but I am dammed if I can remember which command or chr() to use. The plane is to have a line in the email like: - Name............................................Fred...

It turns out after some investigation that the logon to my database is actually acting the same as the windows logon, so three strikes and your out with a locked windows account. Now I know not a problem.

I found this great piece of code by Karma in the forum and tested it great, all worked first time. I modified it to show the pc user logon automatically and this then looks up the users name from a lookup table, the user enters their windows password and if it is correct they can enter if not...

Access 97 Mouse Blocker Nice one Col thanks, I missed this in my search. Problem solved. :)

I have a problem in Access 97 with needing to stop the use of the mouse wheel, users are scrolling through the records with the mouse wheel and adding multiple records in my slave tables. Short of killing them I need a solution. I have tried the one contained in the mouse_scroll_2000.zip but...

Thanks for the info , I'll investigate the latest dream weaver. No I don't have to use Access for the site I know its not really up to it. Whats better, mysql? Its just I have this software already and I don't have the budget to spent much on extras. Cheers. :)

I need to develop an intranet site to allow not just read only but write access using either Access 2002 or 2007 (maybe). Does anyone have any advice to which is the best tool to use? I have Dream weaver MX already but I’m not that good with it, I have been looking at CodeCharge Studio 3.1...

I am still fun and games trying to get access 2002 runtime to work. The set runs fine but when I try to install it I get this message: - The application your are installing requires updated system components. To continue install the office system pack, for assistance contact your application...

I have created a runtime package for Access 2002, during the set up it told me it could not find some of the language files and asked for the CD. No problem I did this and set up completed without any further problems. When I tried to install the package it gave me this message: - The office...