I am trying to fix the date fields on an Access report (txtQAStart and
txtQAStop).
Is it advantageous to use a different designation for date fields such
as (FromDate and toDate)?

Just a quick question about lines:
Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to
txtbx3) with lines where txtbx1,2,&3 move up or down according to their
values? Like have access find the location of each txtbx and draw a line from

I have an db that was developed in Access 2003, but it was formated as
Access 2000.  The person who will be using the db is planning on getting
a copy of ms/access 2007.  Should we anticipate compatibility issues?
Regards,

Correct me if I'm wrong, but is it impossible to change the font in a report
field when in print preview (MDE database) or can it only be done in design
view in the MDB database.
Part of my database is used to print name tags for functions, and it would

Hello all & I hope I'm posting in the right place..
I need to load a temporary table with a range of sequential dates,
passing it a beginning and an end date from a criteria form.
I have created the form FrmMakeDayFile with 2 unbound fields

I have a query where I need to have the SSN appears as 123456789 instead of
123-45-6789 can someone help me with this?  The table has it as 123-45-6789.
I would like to do it without running an update query with the replace
function and would also like to avoid using left,mid ...

Having spent ages sorting out the layout of my relationship window with
about 60 tables and getting it all tidy and with enough of the tables
visible to show the PK an FK relaionshipsOn a subseqent occassion, on
opening the relationship window, I found all the tables had shrunk so ...

I have form with a Close button.  When the button is closed, I want it to
first delete all records in tblCustomerID then close the form.
I would like the delete query to just run and not prompt me over and over
and over to confirm because I WANT to DELETE them.

Can anyone tell my why this isn't working?
Me![dt].top=(1440/2.54)*16.78-[DT Total]*0.4)
I want it so that for every 1 change in [DT Total], a rectangular box [dt]
moves 0.4 units closer to the top.

does anyone knows how to import/link a file that sits on a server
for now everytime im trying to import,im getting a message connect to
server but then it is cenceled
any ideas

Having spent ages sorting out the layout of my relationship window with
about 60 tables and getting it all tidy and with enough of the tables
visible to show the PK an FK relaionshipsOn a subseqent occassion, on
opening the relationship window, I found all the tables had shrunk ...

A friend of mine, a bright woman, cannot attend a classroom school
because of poor health.  But, she has a good job and can work from
home.  She is not a beginner to databases, but wants to improve her
Access skills.

Allo all,
We just upgraded from A97 to A2007 SP1 and we've got a problem that I
cannot solve. When someone wants to print a repport, a form F is shown
for him to choose the printer. Then he prints it. Everything works

Just been having a tidy up on my PC and dusted off this old link I
had:
http://www.mvps.org/access/lookupfields.htm
I use lookups a lot! They are godsend to me. A typical orders table of

This is an Access2003 and SQLServer2005 question. I have a form for a
billing application that uses a temporary table to view and process
items. We have three buttons on this form that change the billing
action to one of three states: