I have a button to preview a report but when the user changes a record and
presses the button, the changes are not shown on the report. I know this is
because the record has not been saved yet but forcing a save in the code
before the preview command does not work. Is it because ...

Hello,
I am trying to modify an update query to use a function rather then a hard
coded string for the table to update from.
 The old query;

Beautify CODE is missing TOOL in ACCESS-2003 !!!!
**************************************
(like in Visual Fox Pro)
when access does not support FULL usage of COLONS (:)

I am a novice who is self taught from surfing and trial and error learning
Excel and Access.  I am the only one who is entering information. I have a
form that consists of purchaseplace, category, name, cost and date.  I have
figured out how to get the "not in list" would you ...

I have an very simple query that I want to use to create a scatter plot.  I
can't get it even remotely close using the chart wizard and I can't figure
out how to manually create a chart.    Every variation I've tried with the
wizard gives me the same East West North South ...

I have a table as follows:
tblCalls with fields
UserId                  Number
PhoneNumber      Text

My table has an ID datatype is autonumber
I make a form base on table.  I would like to type a value in textbox then
it will look up if the value match ID then display the record, if not then
goto the new record.

I have a file myfile.mdb. When I compact it, it leaves me with a file db1.mdb
which is compacted. Usually myfile is replaced by db1 and renamed to myfile.
My question is why isn't this happening.
Thanks,

Is there a way to have Access display the file name when the database is
open?  I see the table names, but I have the same tables in files that are
different only by year; for example, survey2007, survey2008, survey2009.  I
would like to know which file is open.  Thanks.

I have a qry that calculates the difference in time between VPInsertionDate
and VPRemovalDateB in an expression called 'Time'. This difference in dates
leads to '#Error' where I eliminated values that should be present. I want to
isolate all values for 'Time'>180. However, due to ...

I am using Access 2007 on WIndows Vista.  I have a subform with a single
combo box in it.  The combo box's row source has two columns, the ID field
and then a concatenated text field that shows a person's name followed by
their company.  What I woudl like to do is give the option ...

I am trying to figuer out a way to fire some vba every 10th new
record.  I am wondering what the best way to do this is?  I am
thinking of storing the new records in a temp table until I hit the
magic number and then fire the code, but that would leave my form bare

Dear friends,
I have created a database using Access 2003 - Invest.mdb (default format
Access 2000).  I can open it using Access 2003 and Access 2007.
I have installed it in an organisation and while trying to open it (they use

I have one report based on a table.  I need to create identical reports for
other tables.  Is there a way to simply copy the report format?

I have created a 2003-2003 database in Access 2007, and have used the built
in tool to convert to a mde file.  the problem is is that access 2003 will
not open the file, it says I need to upgrade to open the file.  is there
anything I can do to rectify this?