i have a subform with three columns .... date, service, price.
i have set the subform "order by" field to date, however, the subform still
shows the data in the data-entry order.
is there something else i'm overlooking?

Every time I open an office document it automatically minimizes to the tool.
It is no major problem just very annoying.

I have a jpg photograph that I converted to bmp in PHotoShop. Access will not
recognize the bmp. What do I need to do to make this work - without writing
multiple pages of code...

I have created a pop-up data entry form to enter new employees. That's
working great, however, is there a way that I can then have that new employee
be the record that is showing when I close the data entry form.
Right now, when I close the data entry form after entering the new ...

Thanks to Keith for your comments on my last post - I went at it from a
different angle, as suggested, and the problem was that the fields
weren't bound.  It's working now!
I have a new dilemma, though.

I have an Access 2000 database that I want to use to keep track of the
part numbers being used for new parts. The main form has all the data
regarding the part (Setup Date, Part Nbr Assigned, Purchased or
Manufactured, Supplier, etc). I also have a subform (Call

What is the VB coding to put a warning on a button. E.g. Are you sure
you want to save? Yes or no

I would like to add items to a listbox but i would like to use 3
columns in doing so. I was wondering if it was possible to use the
column property to add the items or something. Any suggestions please
let me know. thankyou much.

I have several reports that ask for a set of dates and have a form for
this. Right now on the switchboard the button opens the report and the
date form opens due to the on open event property of the report. The
form has default values that allows this to work. How can I open the

I add a new customer, click on button to open subform (made with wizard).  
Add new contact data in subform, but when I exit, I get this message: [you
cannot add or change a record because a related record is required in table
'Customers'].  I understand the error, but an very new ...

Good afternoon Access fans,
I have a combo box for CompanyName on my form.  The combo gets it info from
a query that returns all CompanyName names, grouped, from tblMoldingSetup.  
If I entered a new CompanyName in record 5, for record 6, I would like the

Using Code in VBA how do you delete a form?
Thanks
DS

There are a number of reason why I need the recordnumber as a field.  Not
sure how to capture it.  Do not want to put the code in the ONCurrent event
of the form- its it causing other issues.  What code and where can I put it
to do this??

I put an unbound list control on an access form, and sometimes it will not
make a selection when I press the mouse key.  I am using multi-select with
extended set to on in the property sheet for the listbox.  Could you please
help with what I can do to fix this problem?

Can a user sort by multiple columns when in 'continuous' form view (not to
be confused with datasheet view)?
Thanks!