Network users with read-only access are getting this error message when
another user is in the database.  Any suggestions on how to fix this
problem??
Thanks!

I have a table  with 5 days and weekno on it
it supplys 10 years woth of dates for sub forms for schedule
iam looking for advice on best approach to open form frmSchedule  to
current date

I want to do simply this in MS Access.
PARAMETERS pTableName;
SELECT * FROM pTableName;
This doesn't work ( if it did I wouldn't ask you :) ) but is it clear

I have "Allow Design Changes" set to "Design View Only" in the property
sheet for my subform datasheet.  But when I have my cursor in a textbox and
press Alt+Return, the property sheet for the textbox comes up.
I've discovered I can prevent this behavior by not pressing Alt+Return ...

The website has an ASP page and I want to pass parameters within the
URL using Access 2003.
I have the format of the URL worked out. If this is pasted into the
address bar of IE, it works exactly as required.

I replaced AddNew statments with INSERT INTO, but am unable to
write to the same tables. Foreign keys violations are
the main errors. Why are these occuring ?
Before:

Hi,
I'm using the transferspreadsheet function to export my tables into
excel. Is it possible to export just certain columns? and is it possible
to export it without harding coding the file name and location?

I am considering general error handling routines and have written a sample
function to look up an ID in a table.  The function returns True if it can
find the ID and create a recordset based on that ID, otherwise it returns
false.

I have the following forms:
frmLeads  (main form)
frmHistory  (subform of frmLeads)
***************************

I am doing something wrong, but I don't know what!
I converted some of my macros to modules -- but they won't run.  I
debugged/compiled but the run command still is greyed out.  What do I
need to change.

i have a form, which shows rentals of a film. a rental; has a price code
attached to it,. e.g. a = £3.00. b = £3.50, etc...
i've got a form, with a subform at the bottom.
how can i create a field in the normal form, showing the total amount due.

I have a form that has a command button on it to open a report. The
report is based on the forms data, if it's filtered the report is
filtered, if the form is showing 100 records the report is showing the
same 100 records, etc.

How to prevent from autogenerating chart after opening a form with a
chart?
I would like to set chart parameters which are located in a form, and
then click on a button which let me create a chart. Now while opening a

I'm very new to Access, although I have programmed extensively with
VBScript. I'm looking for documentation for the scripting language used
to write Macros. I'd even appreciate if someone could tell me what that
scripting language is called.

I am fairly new to VB.I am trying to figure out as how to write a
script so that i can read the data from an excel sheet to Access.
can u guys please help me out?
cheers,