Search results

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

Charity...sweet charity. Thanks very much for your help!

Thanks for the reply. Your code is the same as what my code used to be like. The problem is however that it will filter out all the other records and just show 1 0f 1 record in the form view. I want it to open in form view at the specific record amongst all the records in the table.

I have a datasheet, and upon the user double clicking in one of the fields of a record, the code is meant to open a form (based on the same underlying table), and open at the record that the user clicked in. ** START CODE Dim db As Database Set db = CurrentDb Dim rst As Recordset Set...

I have never used RetailManager. Sounds alright though. I have just registered for the trial version to be sent to me so I can have a look... I still need that email address to send those attachments m8... Catch ya, Peter

Your Email Address Check your email