I am trying query a table in access 2002xp.135,000 rows 65 fields per
row. I need to compare two fields and return all rows where the values
in the two fields do not match.
field 1 is siteaddress

Hello! Here, in brief, is my problem.
Access 2002. I need to export to a csv text file with text delimiters
on every field. I find that if I save the original data in Excel and
make sure the data format selected is text it, when I open it in Access

Hi. I want to execute a routine, at database startup time, to relink the
backend tables. I have the code for the function, but I don't know where
to invoke it. I tried putting a call to the function in the Open Event
of the MainMenu (which gets displayed at Startup).  That seems to

i'm trying to build a parameter in VBA as a list of stings to pass it
to
MSAccess procedure such as
"select ...from ...WHERE Strategy in ([@Strategy_List]);"

i want to export a table for later import, using vba.
That´s my code:
export:
filename = "C:\HVOtabelle.txt"

Can you tell me how many fields Access will allow in a table.  As I stated
in a previous post, I need to track multiple measurements from machines 10
per day.  In some cases this will give me 120 measurements or more.  I could
put one check on one record but I was hoping to find a ...

Re: Access 2002/VBA:
Once you set the color choices for your Editor window (when composing
VBA code), what is the name of the file that saves this information?
(Tools/Options/EditorFormat)

I am simply trying to create a file in access 2003.  Receive an error
message that:
"Workgroup administrator couldn't create the workgroup information
file.  Make sure that you have specified a valid path and file name,

Is his just a flat-out "No-No" or is there some workaround when it comes time
for SQL searches and DAO.FindFirsts against fields containing same?
I can see maybe wrapping the value searched for in single quotes to deal with
embedded double quotes, but if there are both embedded ...

See:
 Updated version of the Microsoft Jet 4.0 Service Pack 8
 replication
   files is available in the Download Center

I have a database that I need to track certain measurements numerous times
per day.  I need to record several aspects like, length, width, thickness,
plus a few other things.  I've been recording them in a form and would like
to continue to do it that way.  Right now I have one ...

Heello, I'm using Access 2000.  I have a form with a combo box that has
a query as its row source and it's bound to column 1.   This combo box
is unbound to a record like the rest of the form fields. I get a number
ID (12345) as the value when I choose it.  I use code to save my ...

Thanks in advance for help on my question.  I'm new to Access.
I have some data I would like to enter daily ("units") corresponding to a
salesperson.   I also have data (Hours worked) that I can only enter weekly,
also corresponding to a salesperson.  How can I add up the daily ...

I have a form displaying a table in continuous view.
There is a combo-box in the footer containing the list of fields in the
table.
When the user selects a field from the combo-box, I would like to

I am new to Access and have been looking for answers to my problem on
the internet and have not found it yet. I hope someone can give me a
hint. Thanks so much.
I have a form (called: myform) in which there is a combo (combo1) and a