Search results for query: *

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...

Sorry for the late response to your postings, I got side-tracked with other problems. Thanks for the suggestions guys, I especially like the simplicity of mac318's idea; it would be more adaptable to what we already have in use at the moment. Any idea where I would find help/examples for doing...

Sorry, forgot to mention. I have checked out the SendObject method which doesn't seem to be able to handle boxes, lines and other such formatting. ideally I need to be able to fax an exact copy of what I have on the form. Any ideas? Dave

Hi guys, I have a requirement to fax an Access 97 form, any ideas on the easiest way to go about it? Is there any built-in function to do it? Thanks in advance Dave

Hi guys, hope you can help me with this one. We have successfully been using an Access 97 dB on Windows 95 and 98 in a multi user environment (about 20 users max). The problem is, when users open the dB under Windows 2000 (via Access 97) their machines completely reset. I appreciate that this is...

Hi guys, I have a continuous form that auto updates (requeries) every few minutes. There are several buttons for users to use, which simply use ApplyFilter to display relevent info. My problem is when there is a requery (which lasts a few secs) AND a user clicks a filter button, the form...