Running Access 2003 on XP, doing a select from a table and passing the
results to this subroutine to update another table.  When running in
debug
mode, it works.  When I stop it an anaylze the update statement, copy and

I've got empty space in my records (e.g. "1 300", "9 833" etc) and I thought
a simple "find and replace" in tablesheet view would do the trick, but for
some reason the FIND does not work (doesn't find a "space").
Maybe I'm doing something wrong, but I can't figure why the FIND ...

Here is the serenio:
I own an Auto Service store. In my service records database, I have Customer
Table (customer number, name, address, phone, age, etc). I have Vehicle Table
(vehilceID, Customer number, make, midel, color, etc).  I have a Service

I have a table that has a bunch of dates for about and I would like to write
a query that returns each DISTINCT month found in that table:  
Here is the query that I have now, which sorts them alphabetically:
SELECT DISTINCT (Format([tblCalendar].[Day],"mmmm")) AS [Month]

In response to my earlier question, Marsh's code worked like a charm.  I'd
like to tie in one more question to this if I can.  The code below works, but
I don't seem to be able to tie this query now to a report that lists the
actual company name.  Can I modify the code below ...

I have the following table -
Test Tester Result
Test1 Brian Pass
Test1 John Pass

I am used to using a form to allow users to “filter” info from a query for a
report, so they can for example pick a choice from a drop-down to limit
records to those that match the choice in a particular field.  
I would like to do something similar but in this case list field ...

Below is a sample of data of a query which I need assistance in -
Group    Fertiliser    ApplicationRate
1    TSP    3
2    EFB    230

Seen this out here before, but I have never seen an answer.  What is this.  I
have entered all of the criteria for a query, and it opens up, but when I
scroll across the columns I seem to reach one that casues all of the data in
all of the fields to be converted to #Name?.  ...

I want to change only the year in date field of one table. I have tried with
update query but i don't have right function or expression.

I need help with the following UPDATE query.  I'm having problems with the
placement of single and double quotes.  "Me.txtNewRoleName" is a textbox on
the form.  I want to use the value of this object in the query.  Query is:
"UPDATE tblPreRoleApplMapping Set NewRoleName = '" & Me ...

How do I add a column to a table and enter in it the text "FY 2007" in every
row? I basically forgot to add that field when I created the table and now I
woul like to add it.
Thank you.

I've got a manual machine at work that produce about 500 row's a day
6 day's a week
It produce a  table like this.
Count    Instr    Scale    Batch    Gross    Date                Time

Hi, I'm am running queries to return the postcode. The New Zealand Post have
supplied a data file that contains 1,829,432 distinct delivery points. Do you
have any suggestions/recommendations to help speed up the performance of a
search; particularly over a network. Both the data ...

I'm trying to insert a field on a form into a table.  All data types are
numeric, Long.
In my Main Module:
Public LinkID as Long