I created a table using SQL then inserted fields from an Excel spreadsheet
into the new table.  In the new table, however, I need to combine three of
the fields from the imported spreadsheet to create one field.    For many
records, however, Field 2 does not have any data so the ...

I am using Access Form and on a command button I want to run append query.  
How would I write it.  On Click Event - the following code is the SQL view
for the queries in Access.
Any help would greatly be appreciated!

The code with API functions below is working perfectly almost on all
computers  but on a few ones is not working.
What could be the cause of this?
Thanks

I have been given the assignment at my office to archive articles on varies
subjects and make them available to users.  I would be the only one to manage
the database.  Articles will likely be stored in .pdf format, but would like
to be able to search for articles by author, ...

In address fields I need to split the 2nd line of the address into a separate
field. The addresses (if there is a second line) are searated by carriage
return.
Any ideas for how I can get the 2nd line and put them into a separate column?

Here is my code line:
Dim objXL As Object
Set objXL = CreateObject("Excel.Application")
objXL.Workbooks.Open (objXL.LibraryPath & "\AtData.XLA") '.RunAutoMacros 1

I have a calculated control at the bottom of a continuous form to show totals
of a couple of fields. In order to ensure that they display the correct
information, I have this in Form_AfterUpdate:
Control1.Requery

When I compile my project, Access starts compiling and never stops.  Checking
the task manager shows that as this is happening Access is gradually using
more and more resources.  The database is a frontend only with the data
stored in a MySQL backend.  The frontend is about 4 mb. ...

Good Afternoon,
Does anybody know of any programming syntax to get a document to open in a
specific layout. (i.e. Print Layout, Normal Layout).
Thanx in advance

I have posted this on other forums and can't seem to find an answer,
I have a report that is based on a Oracle view.
The report contains a chart/Pivot table. I would like to have the chart
reflect the new data in the Oracle view. The refresh option in the object

I am using a parameter query to create a report, the query uses a start date
and an end date to produce the data, I need to extract the values that I
entered into the parameter and use them as part of a title in a report, (ie
data from start_date to End_date), the start date and ...

I have a query named [qryStudyAllInterested].  There are no criteria for this
query, it is used to combine two tables into one query. I have created a form
named [frmStudyAllInterestedSelect] that has one button named
[btnStudyAllInterested] and one lookup field named ...

I have a "master" copy of a database on a shared network drive.  Each profit
center needs to get a separate copy of the database and put it on a local
drive.  This will enable them to keep their information separate from the
other profit centers.

OK, guys, one of my A2K databases has finally gotten too big, fat and slow
and I need to split it into front and back ends.  Can anyone suggest good
online reading that covers the basics and offers some tips and code snippets?
Tks,

I need some assistance on how to write a code or SQL for the following table:
Date    Inv       Trnx                  Seq    Tag          Date
20051205    0000149110  8113624673    1    S    12/6/2005
20051205    0000149110  8113624673    2        12/6/2005