I have a really strange problem.
A couple of my queries have stopped showing new data. If I look in the table
itself the data is there. If I open the form, the data is there. If I open
the query that the form is based on, the data is there.

Does Anyone have a reference for how to use this particular feature?  I did
not see any reference to it in the Microsoft KB, since I am not sure of the
features name.
I am trying to group data from a query in a second query, then do a count

I have a table with 1600 records.  Almost every record in the table is
duplicated two to four times within the table.  I want to just find one each
of the unique records.  The field that will identify the unique record is
Rec_Ident.  I can get a table with all of the dups or I ...

I want to produce a set of results on where there is no data between two dates.
I use a database to record visits to locations, but I want to know what
locations have not been visited between two dates. The query I use now has
two peramiters, [Start Date] and [End Date]. This ...

I am trying to create a bit of code that will select values from a
particular table, Update them such that only the first 4 characters
remain, then remove the duplicate values that are then created.
I can work this by creating 3 seperate queries, then run the macro when

If I have a table with one column containing the following records:
FieldA
A
A

I am attempting to run a query to return the size of a file.
When I use this code in a colum of a query : vba.FileSystem.FileLen([fileLoc])
I receive an error "Undefined function......bla.....bla....bla."
I have checked for missing function in the Tools_References and, all is O.K.

I have problem to my query. My query is to retrieve data which it's percent
is >80%.
But I got the error "Division by zero" when I put the condition >=80% in the
query. There is no problem to run the query if the condition is not inserted.

(ACCESS 2000)- In a query I want to dynamically calculate how many times a
character occurs in a string.  Like Ones=OCCUR(AnyString,"1") - Any Ideas
please!
Here is a code Equivalent:-

what function in VBA should I use to convert string field to a currency
or any numeric format?
I have a database that gets data from SQL server and all the values
there are stored in a character format, but i need to do some

How to setup Parameter Query based on Date range?
Field in the Query is [School_Date]. I would like to have parameter query
that would give me data according to Between #?date# AND #?date# . How do I
setup the Parameter Box and Criteria box under the [School-Date] field.

I would like to create a form to open a report based on what is selected in a
combobox and textbox.  The combobox would contain the field names and the
textbox would contain the criteria.  Does anyone have any information on how
exactly to do this? Or am I stuck with creating a ...

I can't even create a new database to go to file and get extyernal data.  I'm
trying to create a table from a comma-delimited text file.
Is there a guide out there?

I have an Access database to which information is imported via Word userforms
I programmed. Once a week I create a report based on a query that pulls all
of the records with creation dates (of the userforms) for that week.
Unfortunately, some users do not submit these forms to ...

Greetings!  Have an append query to a master compilation file that will be
run against a series of linked tables.
Individual queries would differ only by the input table, and by two
calculated text identification fields added along with the linked table