I have the following problem with a combo box where it cuts of spaces at the
end of the text example
(    1N1G-     6007-BB      ) This is how it should be the field length is
always the same so where there is no characters it must give me a blank space

It's been a long time since I have used access and I can't remember if I can
do this, but I figured someone out there would know.  I have multiple
conditions that need to be checked to come to a result.  For example ...
iif [Text 12] < 0 and [Text 14] > 0,3 and iif[Text 12] is < ...

I have a memo field that carries "Notes" about each member.
At times I need to add the same comment to many members selected by a
criteria in the query. Is it possible to use an update query that will
retain the existing contents and add a common comment to the qualified

I have a separate table that has the state code, the month, and day
ex.
state               timeframe(months)          addl days
Alabama               4                       0

I created a database and in it I added an OLE field to include pictures.  
This works great.  The problem I have is the database is growing - it is
currently 1.5 gig and getting larger.
I don't want to rebuild my application, but need another solution for my

I have a form with combo boxes for Location and SubLocation.  On exit from
location I requery Sublocation.  This works fine as long as I use it as a
form, but when I try to use it in a subform I get "You can't use the
ApplyFilter action on this window"

On my database i have totals which automatically add VAT for me but some of
my customers are tax excempt.  I need Vat to be added except when i put a
number in my CIF ( name of one of my fields) field.
Does that make sense???

I created a switchboard using the switchboard manager.
The switchboard opens on startup, but I'd like to do the following:
First, have the switchboard display only on startup. I don't want others to
see the tables, objects, etc..

I created a switchboard with the switcboard manager.
First:   I want only the switchboard to be displayed when opened. How do I
do this?
Second:  When closing the switchboard either through the X or a button I

I have a form where the user selects the month and year, the user clicks on a
button and it prints the report. VB code's attached:
DoCmd.OpenReport stDocName, acPreview, , [rptMonth] = Me.[txtMonth], ,
[rptYear] = Me.txtYear

GRUUUU,,
In the record of each when to go back to the previous record to compare with
the current record suppose we use the  code :
 prerecord = currentrec

I am trying to automate a function for our shipping department to enter
shipping tracking numbers for UPS shipments. The Tracking Number is the
same for all shipments except for the last 4 digits. I have created a
macro to enter the beginning of the Tracking number and then to ...

I have to create a form where my colleagues can search by using the "Filter
by Form" option. I want to create it as a button in a form to disply the
search form.
How do I do this?

I want to select records in datasheet view in the subform. How can I
determine which records are selected and save them in a table or print them
in a report?
Thanks

I had a friend write the following code to filter report output based on the
state of two check boxes in the form.  The code is stored in the On Click
event of the button that runs the report.
I would like to know how to apply these filters to records that appear in