I'm trying to set an (within options table, tblOptions) a setting that can
be read, whehter all reports should be printed or previewed.  I'm happy to
email a sample db if required. When I use the setting I get a Run-time error
'13' Type mismatch!!

We have despatch process which kicks out picking information into text
files at hourly intervals.
The text files are named sequentially by process; 'ABC.txt',
'ABC01.txt', 'ABC02.txt' for one process, or 'XYZ.txt', 'XYZ01.txt' for

When you view a form in datasheet view, and you add a record...do the
before and after update events get affected?
thanks

The US default value for DateGrouping property in A97 is Sunday.
Knowing that, what's the simplest way to feed any date (MyDate)
to a FN and have it return the date of the first day of the week in
which it falls?

My system is near finished, it is something quite basic where the
users interfer with the data via forms.
I want to limit my groups in what they can SEE from the database.
Like, I want my average users (groupe name: USERS) to only be able to

I've been tasked to create a database for the company I'm interning
with. However, they realized the office suite they have does not
include access. I'm not sure what type of licensing they would need for
this. It's a small company, about 30 or so computers and 20 some

Hi.  
I have a routine for the AfterUpdate event of a checkbox on my Main
Menu.  The checkbox causes a "User Variable" (in a table for
UserSettings) to be modified ('Y' or 'N') by issuing an UPDATE against

I have a query to get selected fields from two tables in an SQl server.
I made a make query table to get these data to a table. Whenever there
is a change in the databse (the database get new records every minute!)
I always have to get all these downloaded to my table since it ...

I am upgrading an MS Access 97 application which uses the format
function to round  decimal numbers to two places
e.g. format(dblValue, "standard")
Having done an initial study of this function I can see no obvious

I have a database with several tables in it - some with autonumber columns.
Is it possible to clear out these tables so that all data is deleted and the
autonumber fields are set back to initial values
thanks for any help

Greetings all,
I have a split database with a number of maketable queries.
Up to now, these have been creating the associated table in the local
database

I'm wondering if the BackColor property values for
the colors built-in to A97 come from some internationally
recognized standard. I have a list of a hundred or so
colors with hex values and I'm wondering if they are

After a couple of brain-wracking weeks, I have begun designing my first
DB. I am struggling, but determined to make this work.
Would any of you be willing to take a glance at my beginning design and
make suggestions?

I posted this, but for some reason it didn't go through...
I'm using access 2k, and need to date the last time my form has been
edited. So I added a date field and in the after update property I set
that field to Now(). This gives me all kinds of errors though...and

I have a form set to maximize on load (docmd.maximize) but when i open
another form by clicking a button on my main form, it restores itself
to its default window size, is there anyway I can prevent this? thanks
in advanced techies :)