Group.
Have a probelm.
I have a database which is holding at 1.5Gb right now, Access can
still handle it.

I have tried to solve my problem through existing questions that have been
posted and answered to no avail.  I have a field that is a standard number
with 3 decimal places.  The number is a unit of measurement and I want to
format the field to add a single quote at the end of the ...

I have been developing an order entry system for the last few months and
Access has worked extremely well. I am keeping things very simple.
I was working on my data base this morning and everything was fine. I came
back this afternoon and now Access takes several minutes to open ...

Hi.  My access tool stores interview responses. I am building reports to
print out responses to each question, showing name and some other
demographics.  No problem - all straightforward.   What I'd like to know is
how to skip those people who did not have a response, so that my ...

I know I've done this before, but for the life of me, I can't remember
how...
I have a fiscal calendar in a table with the fields Month, Year,
MonthBeginDate, and MonthEndDate.

It appears as if it is only possible to link a subform to a parent
form, and it is not possible to link to from one subform to another.
I could have one subform within another, but the problem is that the
subform that I need to be the "intermediate" parent needs to also be a

I want to remove the menu bar and toolbar for a small db and replace it with
a customer menu bar only.
I am having trouble removing the built-in menu bar. Is there a way to do that?
Thanks.

I'm creating a new .MDB file for the purpose of migrating all the objects of
another .MDB file into this new one.
I realized that the database (.MDB) file which I'm trying to migrate is
currently not corrupted but there's something wrong with the file.  You see

I am a highschool computer teacher. I have Access 2003 data files on cds that
came with our textbooks. I saved the datafiles in a folder on our computers.
We open the data files and backup data base and rename the original database.
We then work with the backup or new saved ...

I didn't realize when I imported some data into my database that there were
a bunch of spaces after all the data.
I know that I can do a RTRIM the data in a query, but I don't want to have
to remember every time I create a query to TRIM it.

I would like to study about msaccess report.  How to design.  How to edit if
there is problem in report. I would like to know everything in report.  What
is the way.
Please commend.

I have a textbox 1 to 4, and i want to clear details inside of each box using
a CLEAR COMMAND BUTTON..but i dont know the code for that..please
help...thank you for the suggestions last time...Thanks a lot..

When dates are captured in a table, which format is used. Is it the date
format from the regional settings in windows?

I am using If to set the value of a field:
If (Mid([ID Number], 7, 4)) > 5000 Then
Me![Field]= "X"
End if

hi..please help..i have a problem using command button in displaying answer
in basic math operation..i have the text1 and text2 and wishing to display
the answer in text3 by clicking a command button..i do coding in command
button like this(Me.Text3 = Me.Text1 + Me.Text2) and the ...