Replies

Do your users need to view something other than reports? You can save Access reports in snapshot format, and the snapshot viewer is free. The snapshots will be static (i.e. you’ll need to recreate them every time you want new information in them).

An alternative to converting to string to isolate the individual digits is to make use of mod and (the latter being the integer division operator). That way you’re not converting to and from strings all the time to calculate your checksum. The rightmost digit is x mod 10. The second (counting from the right) is (x 10) mod 10 etc.

What if something goes wrong with the drive itself? If you lose the drive you lose all the partitions.

Is it in the Parameters list? (With your query open in design, select Query | Parameters… from the menus)

I agree with the others – no. However, you could try making life inconvenient for copiers by checking a bunch of installation specific stuff and booting them out (without giving specific details) if it’s not correct. Naturally, you would need to create an mde to prevent snooping.

Currentdb.name gives the full path name to the database. You can use syscmd (see the builtin help) to get the path to the current workgroup and to where MSACCESS itself is, as well a few other tidbits of information. See
http://www.mvps.org/access/api/api0040.htm to get the current NT domain. etc. etc. Make sure everything is still the way it is on the production copy, and you might be able to secure it enough to keep your boss happy.

Another respondent has answered your basic question. However, I’ll just point out that you should NOT assume that “virus warnings” from anonymous sources are real (particularly if they say that they are impossible to detect); there’s lots of hoaxes out there! Check on your antivirus vendor’s web page (you DO have antivirus software I hope?) for current viruses and updates to get rid of them. http://www.vmyths.com has lots of information on (among other things) virus hoaxes.

Set the format to something other than “General”.

Have you removed all permissions from the default Admin user and ensured that that user is no longer in the Admins group?

How about opening a DOS window and trying

COPY myfile.prn LPT1:

(assuming your printer is connected to your parallel port).

Haven’t played with colours in reports and where to set them is not mentioned in the documentation, but since other formatting (e.g. setting visible/invisible) is supposed to be done in the format event code rather than the print event code, I’d try putting your code there.

Also, I suspect you are missing a bunch of double-quotes, unless draft, obsolete, etc. are variables.

You only have one detail section, but you can have several group headers and footers.

Why do you need positioning accurate to less than a thousandth of an inch?

If I’m not mistaken, positions in forms and reports are stored internally in integer numbers of “twips” (multiples of 1/1440 of an inch). That would explain why the value seems to change slightly, in order to make it an integer number of twips.

Get rid of the Cancel parameter; AfterUpdate event procedures don’t take any parameters. You’ll get that message whenever your event procedures don’t have the correct number of parameters.

IF I understand what you’re getting at (as another respondent said, detailed explanations make answers easier), export your data as text. When the Export Text Wizard pops up, specify Fixed Width and then click the Advanced button on the same screen. Then, change all the Start and Width fields in the list to suit your needs. That will let you run your fixed width character fields together (I’m assuming that if you have a variable width character field you want to export it as some fixed maximum number of characters with trailing spaces to fit). You’ll need to do that separately for each table.

Now, if you are outputting numeric fields (fields defined as numbers, not character fields that just happen to contain digits) and you want leading zeros, it becomes more complicated.

Not by itself. However, see Total Access Analyzer. It’s a nice product.