I've enherited a database with two tables containing unrelated
keys (1 goes from 100-300, the other from 500-1000).  The folks
doing data entry like the seperate tables so I can't combine
them (they use them like excel files).

I have a subform with a textbox bound to a date field and it's default value
set to =Date().  This defaults the textbox to the current system date on my
computer here at home, but when I try
to use it on 2 other computers, I get an error indication of '#NAME?'.  When

Using Access2002
After spending a lot of time making my database I guess it's time to unleash
it on other people.  I have just split it; making an mde version of the front
end seemed like a good idea so that people can't change any of the code.  So

I have a report that records dates that we need to send anniversary
greetings.
I need the complete date to be displayed but I need to sort by day and
month.

Having much difficulty and after searching many sites I
think I found you can't do what I want but I can't believe
that's right... here's what I'm doing:
I have CustomerType and  ReferralType fields. Both of

I have read alot of the messages and answers on this
newsgroup but am a little confused about the DSum function.
Is it used in a query or in Properties of a form or
subform?

I followed this exactly and it works but.. the math
is not done as soon as I leave the QtyUsed field. It
updates when i go to the next record...how do I get it to
update when I leave the field?

I am trying to use a list box  to list a selection of Key fields (which it
does) so that when an item in the list is selected the related feild from the
same table as the Key field is displayed! Could anyone give me some pointers
on how to go about doing this ? Thanks

I have a table with a field I want to search for using a
wildcard. My query criteria is [Enter Name]. The field
property is Text and there are no masks on it. To get
Lockwood, Lock, Locke etc. I've typed Lock* as the

When looking at your query results, can you highlight rows
like you can in Excel or put color in selected rows?

Is there a way to display an ampersand (&) as text on a
Form and Report?  Whenever I try it disappears and
underlines the following character.

I have a form based on a table.  I can print a report on each record one at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

Can anyone tell me what syntax is required to have a label on a report read
"F&I" ?
I'm sure there is a pretty simple solution but I can't find the answer in
the help files.

Can someone help me with what seems like a simple question?
Is there no way of getting and/or setting the section width of a form?
This kind of code:
Me.Section(acDetail).height

I have an operations database that tracks our tug boat voyages and use the
standard 24 hour timeclock.  The times are shown with the short time format,
but I need all 4 digits to show.  In the maritime world, time is always
shown in 4 digits.  In Excel you can do it by setting the ...