In the combo box wizard there are typically 3 options, the last one
being to find a record based on the selction in the combo box.
Nevertheless, sometimes when I try to add a combo box the third option
is not present.  What am I doing wrong?  Thanks.

I have two users, Andrew and Nancy, who each have their own computer
and can connect to a common database called "employees.mdb" which
resides on a network server.  On that same network server, there is a
folder containing jpegs of the employee pictures.  When either person

So I have a text box with a string in it, and I want to get the value
in that text box into a table using VBA but I have no idea how to do
that. Anyone offer any help? Thanks in advance!

Hello eveybody,
I'd like to know how to send line by line a report to the printer and
how to control(Select one, set up) the printer.  I don't want to use a
file temporaly.  I'm using Access 2002.

how to export and import sdcripts in clearquest
Thanks,
lakki

I'm using OleDb to connect with an Access Database. I have anywhere from
10 to over 100 records that I need to either INSERT if the PK doesn't
exist or UPDATE if the PK does exist, all in a single transaction. Does
anyone have an SQL statement I can throw at it that would accomplish

I have built a fairly simple database to manage contact information
for about 300 clients. Some of these have requested that I send them
our publications by email rather than post. I have created a query
which culls the names and addresses of these contacts. Then I export

I need to create a report that shows the first six codes that apply to each
company horizontally. The codes are stored in individual records in the real
data but I am writing them out to another table with six fields labeled
code1, code2,code3, etc.

What sort order does the DIR function use? I can't see any options
within the function to force it to sort in a particular order. Does
the sort order depend on the Windows Explorer setting for that folder?

I have a combo box on a form that I want the content to be read only. If any
changes it should be done in the table. How can I accomplish this task? I
tried to set the locked property to true, it didn't work.

I'm a bit perplexed about this. If I bring the form out of design mode
into view mode, then the code below (which is on the form's open
event) works fine and gives me a new record. If I close the form
completely and then re-open it, I get the error "GoToRecord isn't

I have a database that lists each time stock items are purchased, who
they are purchased from and the date of that purchase.
I have a query that list those purchases, it's linked to the order
also to grab the purchase date.

In Access 2007, why does a query field designed as Term: [Forms]!
[frmProfiles]![cboTerm] return 00:00:00 when cboTerm actually contains
08SP. This works as expected in Access 2003?

I quote:
"With an unbound combo in the form's header, you could provide a
                                    ------
simple interface to filter products from one category."

I m Pankaj, i ve a problem in accessing data from MS-Access Table. The
error is
System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed
with E_FAIL(0x80004005)