Search results for query: *

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

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

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

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

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

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

Hi guys, I have a DB(97) that is on a contstant loop, updating every 1.5 minutes approx. Two tables have their contents deleted and refiled with about 1000 records, from a .txt import. Iv'e checked the tables and nothing is accumulating anywhere. After a few days the DB crashes because it is...

Simple one this, just can't find the solution!! I have a table with one field with one entry (a time/date stamp from another DB). What I need to do is set a variable based on the tables contents. I am currently using a 'round-the-houses' approach, but this involves a maketable, which I don't...

Hi all, I am using the shell command to open an .exe file, that works fine. The problem is I can't find a way of shutting down the .exe from within Access. I assume an API call would do the trick. Any suggestions? Thanks Dave Detec123@aol.com

Hi all, I am using the shell command to open an .exe file, that works fine. The problem is I can't find a way of shutting down the .exe from within Access. I assume an API call would do the trick. Any suggestions? Thanks Dave Detec123@aol.com

Hi there. Can anyone tell me if there is a snippet of code that I can use to detect if an instance of a DB is already open? Basiclly, I only ever need one instance open over a network, and more seem to mess up the goings-on. Thanks, Dave Detec123@aol.com