i have an insert into SQL issue where a user may be using an apostrophe and
it's messing with the SQL.  here's the code:
strSQL = "insert into tblNewoptions (optiondesc, optionCode, AllocGroup)
values('" & Me.txtboxOption & "'" & ", '" & Me.txtboxOptionCode & "'" & ", '"

I have an apped queryI  have several fieds in my query and a total field
(which total s all the fields. When I run the append query all of the fields
append correctly except the total. Below is the total field
Tot_RB:

Hi everyone!  Hope you are all having a wonderful week!  I'm using A02 on XP.
I've been asked to extract a list of the most recent statements for each
contract in my PartStmtTable.  The fields I'm using are contract number
[PlanNum], statement date [StmtDate] and number of ...

I have an update query which needs to be run on a certain day of the month
each and every month. The problem I have is that access is not continually
open and there are times that I am off work and do not have remote access
from home to run the query. The computer that I work off ...

I feel stupid for resorting to this but here goes...  I can't figure out
what's wrong with my form based parameter query.  It won't accept the
criteria entered into the form.  I've got a form called frmPricingCriteria
and an unbound textbox called txtCompanyName.  Also on the ...

I have a database that contains dates, names, and other things that relate to
the attendance.
What I am trying to do is dynamically count the number of people who were in
the lab for the past 90 days, and show it on a calendar.  The problem is that

I'm having a problem I can't see the trees from the forest.
In the following  SQL I added on the Job Sheet [Customer Name] and Me.
[txtcompanyname]
The SQL was working fine before the modification. It's proberbly very obvious

I am working on Pass-through queries with SQL,
My query need date filter so I want to set date paramenter on that query but
from Access97 (in Pass-through query)
Regards,

I would like to set the default of the 'Find' Dialog to 'Match any part of
field'
Is that possible and how?
Thank you,

What criteria should be placed on the textbox "qty" on Form1 so that the
quantity that is going to be purchased should not exceed the quantity on hand,
which is shown on the textbox "unitsleft". Also if the quantity purchased
exceeds the quantity on hand, what should i do so that ...

Hopefully someone can help me with this. I'm trying to create an
Access database that will pull a list of people based on the first two
letters of their last name. Since this list will vary, depending on
the user of the database, I want to use dialogue boxes so that a

Good morning,
I am having a problem where I have designed a query and I have it looking up
certain criteria in 3 fields.
Date - Between [Type the beginning date:] And [Type the ending date:]

I am trying to import Excel sheet into Access but I encounter with a problem
in ZIP code field. Even through I set ZIP code column with ZIP format in
Excel, when I import it into Access I am missing leading zeros. I tried
another way and created table in Access and set ZIP field ...

OK I hope I can explain myself the best as possible:
My data presents it self like this in a table. Always! Several hundred lines.
   AAA         BBB
   .......           ......

Sorry for poor title.
I have an app with the main table called 'files'.  I also have an entities
table (read: contacts), and a roles table.  The roles table is a list of jobs
(roles) an entity might fill in a given file.  I also have a junction table