Hello Need Help Again
Trying to set up a combo box to add a new customer name, got this code from
the Access help. I get a SQL; error ?? Also I will need to add a new number
to my primary key field (this is set to auto number in the table)

I have a table that has 3 similiar fields.  Let's call them Issue fields-1,2,
& 3.  I need to take all the issues from all fields, sort them together to
find the Top 5 issues for a certain timeframe.  How do I concatenate these
three?

I have a master database containing vehicle information, including leins.  
However, not every vehicle has a lein on it.  How do I skip over entering
this info.  I have a field that is either YES/NO to the question "Is there a
lein on the vehicle?"

I want to be able to send an email to a selection within my contact
database, and to aviod having to enter all the email addressess all the time,
or have to keep a seperate address book in Microsoft Outlook, I am wanting to
be able to push a button on a form, and have a blank ...

I am developing an ASP web site using Access. I am using a routine in
VBA to pick photos and instert their path in the database. The routine
also copies the photo to the images folder. At that point I would like
the module to run a function that would open fireworks, run a script

I have a subform whose record source is a query. The subform lists all
persons associated with a case. (The main form has the case information) I
open another form to add a person to a case and when I close the new form
after adding the person to the bridge table I want my ...

I  am trying to get a connection string to work and I have tried a variety
of things but to no avail.  I have used the same connection string in an
A2003 and it works fine.  The code is below:
Dim OConn As ADODB.Connection

I am getting an error with my insert statement.  The code is very long but
here it is.....
strInsert = "Insert into Maintable (CourseTitle, Assignee, Location,
StartDate, EndDate, " & _

I am experience problems and solution from Microsoft is not favorable. Before
my department was upgrade with new workstations, we were using Access and
Word 2002. One of our Access databases would open Word mailmerge documents,
create the new letters, and then store them on the ...

My table and form have same field names and textbox control names, every
field in table has a textbox. I have the user select the key to the table
record they want. How do I use the table data to fill in the form textboxes?

In excel I use the follwing code:
fLog = Application.GetSaveAsFilename(InitialFileName:="Extract_log.txt", _
         fileFilter:="Text Files (*.txt), *.txt")
If fLog = False Then

hi, i'm having a big problem. Before i have a Project table that is
linked to the Milestones table. The relationship was one to many. As
there is a limitation on the number of columns in one table i can't add
columns in the Milestones table which i need to.

I am using the following code:
   Dim ObjetoMail As Object
   ' Create CDO object
   Set ObjetoMail = CreateObject("CDO.Message")

Network OS = w2003, desktop = XPPro, Access = 2003
Database #1, using all access tables and queries, uses the same code as DB
#2 to find a record.
DB #2 is linked to 4 SQL tables, and has 3 access queries, one of which is

I found a very nice way to hide the access application window on the web.
http://www.tek-tips.com/faqs.cfm?fid=2562
I created on my switchboard a command button, which should close the
application including Access, which is running in the background.