Sometimes, when I close an Access file, I will get a message about unable to
save.  The system will then save the file but will name it db1.mdb.  One of
my users is experiencing this and claims that some data was lost.  What is
happening and what can I do about it?.  Access 2000 ...

Is there any setup to use mouse scroll button in VBA editor or its a bug? It
is so frustrating  I can not use scroll button?
I am using Access 2002 and Visual Basic 6.3.
Thanks.

I upgraded to MS Office 2003 and now when I load my mdb files I get an annoying message about unsafe expressions.
I am current on all my updates.
How do I turn this off?

I am trying to create an access database and I want to create a field that i
can put an IP address in this format XXX.XXX.XXX.XXX but I dont know how to
do that.

I tried to download an access template, I recieved the message that it
requires access 2000 on my system but I have 2002 so can it roll back for
viewing or do I have to install 2000

I am trying to write a new query (with QBE) for a Flying Log database. The
idea of the query is that it will tell me the last date I flew in a
particular aircraft. I have got the query working for the two most important
fields: the FlightDate field Total setting is set to 'Last' ...

I'm currently using Lotus Smart Suite softwear because that's what IBM has
been offering with purchases of their PC's.  I have three databases that I've
developed using the Lotus Approach database and when I purchased my last
laptop in July (non-IBM) I purchased the softwear ...

I have created a table "tblParts" with the followin fields...
ID, Model Number, Reference, Description, Type, Part Number, Quantity,
Document.
I have created a form "frmInputPartsDetails"....to enter the information

Please help. I have a numeric field that contains mostly whole
numbers(eg.100) but has a few numbers with decimals (eg 7.1 or 8.7, etc). I
need help changing this field so all numbers are rounded to the next whole
integer. If I use the round function it will change the 7.1 to 7 and ...

On a laptop with no mouse, I have a form with a text box and a command
button. What I want is for students to scan their ID card into the text box,
then press the command button to create a new record & reset the focus to
the text box.

I am trying to us the IIF command in my criteria to allow sorting.
This is a simplified version of the statment that still fails.
IIf(1=1,([Table1].[data]) Like "*","a")
1=1 is just to force TRUE for testing.

WinXP Home, Office 2003.  Word is the editor in Outlook.  When I type a
message, a carriage return automatically gives me a space between lines
equivalent to two lines.  I would like to kill this feature so that one
carriage return gives me one line.  I can modify the format in ...

I am trying to do a custom footer for a 3 page worksheet.  I would like to
start numbering with Page 3.  I read where I need to use &[Page)+  followed
by the number I want to add to the actual page number.  For some reason this
is not working.  On page one, if I use &[Page]+2, my ...

Hello, I am fairly novice at access but i am trying to make a simple database
for my law firm.
This data base will be a way for me to calculate and total up client's usage
of postage and copies. So far i have made 2 tables, one with the client's

At work I maintain an enquiry/project listing on excel - it has 12 headings,
and about 900 or so records.
I manage the data using filtering, which is fine, but feel it is time to
convert it to Access.