Recent content by Essendon

Many thanks for your replies. Hey Wayne (or anybody who can answer), I'm wondering how you can launch VBscript to run on its own? Would I have to add it into another mdb file or can it run by itself somehow? Or am I getting it confused with VBA? Thanks again.

Hi all, I am working on a system that has a back end (on the server) and 6 front ends (all identical, one on each of the client pc's). This means that whenever I make a change to the front end, the updated version of the Front End has to be copied + setup on all 6 client machines. This also...

I am stupid. I didn't realise it would save printer settings along with the report. Silly me. Thanks very much Pat.

it seems to only happen on a couple of the reports, the rest are fine. I have checked the report's properties and they are exactly the same as another report that is working fine.

Does anybody know how to fix this? Hi, I never sorted this problem out. Does anybody know how to fix it? My windows printer properties suggests my printer is set for color mode, but in the program it defaults to black and white printing so I have to manually set it to color every time I want...

With regards to the following simplified code: *- Start Code With rst .AddNew !strName = "Joe Bloggs" ? .Update .Bookmark = .LastModified End With *- End Code I am simply trying to add a record to a table. The line with the question mark throws the...

Hi, I have a form that is a datasheet view of all the fields in a table. What I would like to achieve is to have the user being able to select which fields they want displayed (eg from a list displaying all the fields) and then only those fields get displayed in my datasheet form. I thought...

Thanks very much Works perfectly - thanks very much. Whats the easiest way of finding out what char(34) is and what all the other char(x)'s are? I assume that char(34) is ". Thanks again.

I am using windows xp. I don't have a c:\program files\accessories\ directory. I have no problems opening paint. I just cannot open any file that has a space in its path.

I have a database with images stored externally (with only the paths stored in the database). I want to create a button that would open a picture with the user's default picture viewer (eg. Ms Photo Editor, Ms Paint, Photoshop etc.). Is there anyway that I can simulate the double click of a jpg...

Thankyou for that. After I got into the database I tried to compact and repair it, but the crash would keep occuring. Then I compiled all of my modules and did another compact and repair and all of a sudden it was back to normal. Very wierd. Thanks again.

Hi, I am developing a database in Access XP. I have been coding away all day. I did a compact and repair and then closed access. Later on when I tried to open up my database again it crashed access on startup. It does it every time now. About the same time the default form should be displayed...

Hi, I have been looking into MSACCESS security for the first time today. I have made a little test database that I open with a shortcut that looks like this: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /wrkgrp "C:\Database\test.mdw" "C:\Database\test.mdb" That is working fine...

Hi, Havn't been on the forums in a while, so I just thought I would answer my own question in case anyone has this problem in the future. The problem is caused by Norton Antivirus 2002 (and possibly other versions). To fix the problem, you have to disable the office plug-in within Norton...

Hi, I am attempting to create a word document from VBA code in Access. I am having a problem with Normal.doc when running my code. If I delete normal.dot my code works fine and the document is created ok the first time I run it. Every time after, I usually get a error stating "Normal.dot...