I AM COMPLETELY NEW TO THE VISUAL STUDIO DEVELOPMENT ENVIRONMENT SO I AM
POSSIBLY DOING SOMETHING WRONG BUT I  WANTED TO MAKE USE OF AND OLD
MICROSOFT ACCESS DATA BASE IN THE MOBILE 5.00 PHONE EDITION SDK I TRIED TO
CONNECT TO IT AND TESTED THE CONNECTION AND IT TESTED OUT OK. ...

I have some very complex queries written and some end users that don't have
access to the queries and tables.  So I am making a Form that will run this
query.  The first step is to press a button that runs a MakeTable Query.  But
this is a replicated database and when the table ...

I'm drawing a blank here and need some assitance. I have a database of daily
activity. I have 75 seperate organizations reporting in the database. I now
want to write a query that averages each organizations monthly total from the
daily input, then outputs a report showing each ...

can anybody help me with the following problem:
I need an update query which shortens a string (the item) to maximum 18
characters.
Some items are 19 others are 20 .... characters long.

When I coding "DoCMD.RunSQL 'Select <Some Field> FROM <A Table> IN <Another
Database>' " but that database is password protected, I always get "Not a
valid password" message.
Could anyone help me on this?

Hello there well I have a big probem I am trying to create a query that I can
select a month using a combo box in a form and returns with all the record
and not ignoring the rest of the months for example If I have records for
July it will come only july's except the other month I ...

Can anyone help me with what must be reasonably straighforward but I can't
figure it out.
I have 2 fields 'Range' & 'Manufacturer' - and I want a query to give me the
number of unique 'Manufacturer' records for each 'Range'.

In a payroll system there are 4 tables
One to many relationship
Check Summary (cs) - Master
Hours & Earnings (h&e)

I have a query that involves 10 instances of the same query which are
daisy-chain-linked to each other via left joins.  (I am trying to extract all
of the paths to the top of an assembly tree.)  Apparently, the query is at
the edge of some restrictions that are unknown to me.  If ...

I need to export a query to a text file that contains both alpha and numeric
fields
How can I force the numeric fields to text as to get "123","ABC"
thanks, Garry

can anybody help me with the following problem:
I need an update query which shortens a string (the item) to maximum 18
characters.
Some items are 19 others are 20 .... characters long.

Is there any way to get a query to return string data rather than code even
when the code data is stored in the table? i.e For a given field if "no" = 1
and "yes" = 2, the query currently returns the '1' or '2' (given that this is
the value stored in the table). However, I'd like ...

I am using Access 2007.
I have 2 tables tblStock and tblStockPriceHistory. Each night I append the
latest stock price data to the tblStockPriceHistory. I then want to run an
update query to update tblStock to show the date of the most up to date data.

I specify field values in many queries to filter records.  Ex: Not like
"Company X" and Not Like "Company Y"  The field values that I have used to
filter the data have stayed the same for years but recently changed so I must
change the values in all those query criterion.   I can ...

Group,
I am having a problem.  I have the following queries(#1-#3) that result in
the final answer of 0.  That is not the problem, If I add
pip_count_2_weight_loss(#3) to my final query pip_REPORT_end(#4) I get the