Is there any way, where u you select the record (part number, quantity)
where the order number = strOrderNum...
Then,
I will put a loop there to do until it end.

I have an Intranet page which pull data from an Access 2000 database.
I have created links and queries to display substances which begin with A to
Z.  But I am having problems with substances which start with a number ie 0
to 9.

    I have a table which contains all of the contact info of which along
with FirstName and Last Name, I have a ContactType.  I have line item tasks
that the employee types need to be assigned to the customer types.  I have
created a table consisting of an Empevent field as the ...

On table Reser, if field equip =AMB Eld, enter 1 if not 0
Thanks

I have a query with multiple criteria all coming from an unbound form.  All
my criteria uses Like expressions, for example:
Like "*" & [Forms]![frmSearchCriteria]![Grantee] & "*"
When no criteria is entered in the form I need the query to return all

I have a series of XML files that I'd like to append to an exisiting table
and I'd like to do it with the push of a command button.
What code structure should I start with to perform the opening of the
appropriate XML file and the appending of the data to an existing table?

I would like to run one query that can accommodate entering twelve possible
date ranges and output the data all in one query. I could accomplish that by
writing 12 queries and attaching each one to a start and end box on a form
and then doing a Union Query to obtain one result. I ...

I have a table with three columns: Type, Year, Rate. A new record is added
for a given type only when the rate is updated. How can I select, for each
type, the rate that is in effect for a specified year? I.E. For each type,
retrieve the most recent record that is less than or ...

I am pushing my Access Query abilities here.  I am wanting to know if I can
replace the 'truepart' of my iif statement here with a select statement:
SELECT x_logs.vehicle_nu, x_logs.time, x_logs.date, x_logs.status,
IIf([status]="Arrive Plant",1,2) AS [Job #]

If I have a field for a phone number entry, how can i create a rule so
that it will set it up with parantheses around the area code and
insert a hyphen...is that even possible?

Hello,  i hope someone could help me with this....
i have a table....with model numbers and i want to break each model number
in a query.
model number #       A331500M

I have 3 tables with the following fields:
Tbl531:
ACTIVITYDATE
RACF

i am trying to develop a query to find numeric values that are preceded by X,
ie, i'd like to return 633 from this:  123456x633.  the X and the desired
value should appear in the 7th to 10th positions, but due to inputting error,
some appear in the 6th to 9th positions or ...

I'm kind of rusty when it comes stored procedures and I was wondering
if someone could help me with the following SP.  What I need to do is
to query the database with a certain parameter (ex. Culture='fr-FR'
and MsgKey='NoUpdateFound')  and when that returns no rows I want it

I'm looking for a way to select a specific result of a Union Query as a row
source for a combo box.  Currently, I cannot specify the exact result I want
because, I'm guessing, they are derived from a single record in a table.  Is
there a way around this?  I've tried using the ...