Recent content by DavidMark

Jeremy, I utilised your deployment method and it is working well, thanks. I also force the users to update if a new FE is available for download by means of a time/date stamp comparison between the FE and BE (held in tables). That's working quite nicely too. I think I'll be adopting this update...

Hi Kraeg, I'm using that call to check the OS. I'll see if the build is different on Win2000 SP2 machines. Thanks Dave

Hi everyone, I am trying to find a snippet of code that will allow me to detect if service pack 3 has been installed on win2000 via access. Any ideas? thanks in advance Dave

Hi everyone, I am trying to find a snippet of code that will allow me to detect if service pack 3 has been installed on win2000 via access. Any ideas? thanks in advance Dave

Thanks Neil, a simple answer that does the trick.

Is there a simple snippet of code that I can use that will stop people accessing a master front end? I want people to have a copy of the front end on their desktops for obvious speed/traffic issues, but they are accessing a networked copy. Any ideas? Thanks in advance, Dave

Thanks for the reply Tom. I should have mentioned that the address lines on the original table are on different record lines and they are under the same field. Dave

I am trying to convert address data within one table to a single record entry per address. The tables below show what I need to do: ID001 Address Line 1 Address Line 2 Address Line 3 ID002 Address Line 1 Address Line 2 Address Line 3 ID003 Address Line 1...

Hi guys, I've spent a lot of time designing a 'live' scheduling system at my workplace only to find that the users have been doing a form print first thing in the morning and using that instead. They say it's easier than clicking on the access/scheduler button. The lazy buggers won't be doing...

How about I send you guys a stripped down demo of my dB that shows the problem? Dave

Hi guys, I have spent the past few days chewing off my own left leg in an attempt to sort this one out. I have a 97dB on the network whose job it is to periodically change the data in a table (every few minutes). What I am doing is running a delete query to empty the table then running an append...

Hi mbiro, That doesn't work either. Access assumes that 'wdDoNotSaveChanges' is a variable. trying 'MyWord.Quit False' works, I can print the text and quit without saving. Passing false (or 0) seems the only way, since access can't appreciate Word constants. I think I will call it a day on this...

Hi sadcow (could do with a name here!), I get an error saying 'Object doesn't support this property or method' If I try 'MyWord.Application.Quit 0' it quits word without saving, which is what I want to do. Is this the correct way? Dave

This should be a simple one for those in the know. My demo code below opens Word, makes it visible, types some text then quits. How do I quit without saving? I have looked under help for 'quit' in Word and tried everything that I can. Help!! Function TryIt() Dim MyWord As Object Set MyWord =...

Hi guys, What I would like to do is click an Access'97 button and send raw text (ok up to here...) to a fancy Word template and automatically have it open up. Then automatically print to FAX. This, I'm sure, is all possible through coding, just don't know where to start! Any idea where I would...