Replies

The syntax is correct (I tried pasting it into a query). Be careful that you are pasting all and only that into the control source of the control in your report.

I just open the table from the database window, then hit Ctrl-A and the delete key. HansV’s comments about Cascaded Deletes apply to this method as well.

If remote images are not blocked, the sender can tell that you have seen the message (and thus, at a minimum, knows that your e-mail address is valid) by appropriately coding the URL of the remote image. It’s a sneakier way of confirming receipt of a message than asking for a read receipt (which many people also block).

I’m another one that uses the /wrkgrp option as part of a shortcut to open any of our databases. Works like a charm and allows multiple databases to be open at the same time, with no problem. Making it part of a shortcut means that the user can double-click the shortcut to open the database using the appropriate workgroup but any other use of Access (without using a shortcut that includes a workgroup) leaves Access using the default workgroup.

Method: IIf([Call Start] Is Not Null,”IVR,iif([MinOfDate] Is Not Null & [Call Start] Is Null,”LMS”, iif([Call Start] Is Null & [MinOfDate] Is Null,”N/A”)))

What about testing the system after it’s all put together? That should be a SIGNIFICANT chunk of time.

If you wish to continue using Windows on that computer, you have no choice. I take it you made some hardware changes to your computer a few weeks ago?

At the extreme, a file that is completely random will very likely be LARGER after you try to compress it no matter what program you use since there are no patterns to compress but the compression program still needs to store decompression information. Compression programs like winzip take advantage of patterns in the data – no patterns, no compression. As one example, JPEGs don’t compress well (because the JPEG format is already a compressed format).

What type of data are you trying to compress?

As HansV said, yes you can certainly have A97 and A2000 on the same machine – we briefly had both on our machines here back when we were migrating from one to the other. It worked fine. It was particularly easy for us because shortcuts are used to open all of our departmental databases (to point Access to our Workgroup security file), so it was easy to make sure the shortcuts pointed to the correct version of Access.

See http://support.microsoft.com/kb/241141/en-us%5B/url%5D for some more details, particularly if you already have A2000 on your machine and need to install A97. I don’t know if there’s anything similar to watch out for with A2003 – we no longer have a need for multiple versions, so I haven’t checked.

I’ve been playing around with this (the idea in my case is to get users in any of several databases to be able to record questions in a single database). What I did was define the other database as a reference in the first database (Alt-F11 in the first database, go to Tools | References…, click the Browse button, change the “Files of type” dropdown to “Microsoft Office Access Databases”, and find the other database).

Once I set the other database as a reference, in the first database I called a public subroutine that is in the other database (no special syntax – it will look there as well as your current database once the reference is set). That public subroutine opened the form that I wanted in the other database.

Also check the code that opens the form (assuming you’re opening it from another form).

That is normally the case for any of our users that has a computer at their desk. We open Outlook first thing in the morning and close it when we shut down in the afternoon. So, that’s not the source of the problem. Like I said, I have been unable to find any pattern to when recall works or doesn’t work.

I have NEVER been able to figure out the pattern when a recall works within the company and when it doesn’t (other than the obvious case that you can’t recall what somebody has already read). We have one Exchange server, and it’s happened enough times with enough different recipients that I’m quite sure message rules aren’t involved. If it’s important that a recipient know that a message should be ignored I recall it AND send a new message saying to ignore the bad one if they received it.

That’s also a reason not to trust the recall feature as an option for changing your mind – make sure you get important messages right the first time!

Did you check the hosts file as Leif suggested? To answer your question a while back as to why – the hosts file contains site names and numeric addresses. Any time you type the name of a site (e.g. http://www.usmc.mil) your hosts file is checked to see if the site is in there – if it is then the address in there is used and the site’s name is not looked up on the Internet. If the address in there is 127.0.0.1 the site is effectively disabled (actually, the site points back to your own computer, but unless you have a web server running to catch that, you’ll just get an error).

It would be surprising to have .mil sites end up in your hosts file, but if none of the other suggestions are working you might at well check that.

Create a macro called autoexec. Use that macro to call a startup function.