hoping to find some solutions over here.
The problem I encounter is that during running the loop trough the recordset
rs_Ord, an error message pops up at record 2366 when I'm at possition:  
rs_Spok.Find (SrchStr); indicated with comment.

Having some issues deleting records from a table based on a text field in
that table.
I want to delete all fields in the table 'tblTags' inserted by an auto
process, creatively designated by the text "auto" in a field 'DataEntry'. The

I have an application that should be exporting long strings from an Access
query to an excel spreadsheet. Each week the spreadsheet should be
overwritten. The problem that I'm finding is that the long strings are cut
off (I'm assuming at the 255 char). I have tried the following ...

can someone please help me how to filter my database? i need to filter it by
placing a combo box "company names" (contains name of clients, under the
names are status report for each) and placing date range of status you want
to view. is this possible? hope someone can help me.. ...

How does one write update and/or delete and/or append queries using data in
time format when the field in the access table is date/time with medium time?

I’m trying to run the code here:
http://www.databasedev.co.uk/login.html
Sometime seems to be not quite right.  I have a table called ‘tblLogin’ with
the following fields ID, Login, Password, Email, Name, and Level.

The code is meant to open a form, get input, hide the form, take the input
and apply it to the first form.  Basically, if the user selects 'Other', I
want to know what the Name and Category of the 'Other' is.  When the form
opens, if the user only uses the keyboard, everything ...

I am trying to call a custom form in outlook from access.  I need to call
the form and paste the data from an access form field into the outlook form.  
Currently, I can just call an outlook mail item and post the data in there
but I cant figure out how to call a custom form.   I ...

I'm dealing with a poorly designed MS Access database.  Fieldname include the
month/year of the data.  I need to know current months values and that needs
to change from month to month.  Is there a way to dynamically reference the
field name within a queue?  I've got the code to ...

Is there a way to programatically delete data in an Access table and then
import fresh data from an Excel spreadsheet?  I know VBA for Excel but not
for Access.  What is the best way to import fresh data into an Access table?  
I guess I could link the source data to the ...

I have a very tricky import problem.
My directory contains files named according to the following convention:
7 digits, 1 alpha
where the first 4 digits represent an ID

I have a table which lists all sales made by a provider. How can I count the
number of States in which providers make sales? Caveat: A provider may make
multiple sales in a State, and in that case I want the counter to count 1
(one State).

I have a table (tblQueue) that consists of a composite PK of the fields
[Q_ID] and [TODAY]. In this table, When a new year begins I would like [Q_ID]
to start over again at 1 (This field is an AutoNumber field). Since I am
using a compisite PK will access allow me to do this? I ...

I am using Access 2007.  I tried to utilize the code at this site:
http://www.databasedev.co.uk/disable_shift_bypass.html
I created a control button and associated some code with the button.  When I
click the button I get the following message:

My second visit in one day to the fount of all knowledge ...
Access 2003/Windows XP, have a form/subform where the user can flag selected
items in the subform, then pop open a batch actions form, set parameters, and
run any of several batch actions on the flagged records.  All ...