I have the following code that has worked well in the past - though I've
obviously not used it where a record to be archived had null value (or more
correctly, the record did not exist).
Here's the scenario.

How do I create a macro that lets me key in a zip code and a specified radius
in order to see a subset of all records in my Access database that fall
within that radius? I am not an experienced programmer. Thank you.

I have noticed that DoCmd.Requery "queryname"
doesnot always work.
Why is it working sometimes and sometimes returns a runtime error?
Am I missing an important point in doing a requery?

Is there any way to create a custom range that rotates automatically?
I have one table which holds the names and contact information of service
providers and Yes/No field for each county that they serve.
I have another call for service table which may need to reference the

Does anyone know of a good utility for importing XML into Access, or for
converting XML to a TXT or CSV file?
Thanks

i have to import an excel file into an access data base. the excel file does
not have a header.  how can i add a header with column headings of 'col  mod
rate 1 rate 2 ' before importing to the access file.  
thanks for your help

Hey guys, right heres the problem...
I need to be able to calculate how many months ago last December was. For
example, if we are in October now, last December was 10 months ago. Next
month (November), December will be 11 months ago. And likewise when we get

I may be imagining it, but I recall that in Access 2000 declaring a variable
as a form type (Dim frm as New Form_Widgets) did not result in the form being
added to the Application.Forms collection, but now it does. Also, executing
the code "Set frm = New Form_Widgets" multiple ...

I have a database and i want my users to be able to send an email from a
given page, i have no access to their machines and therefore cannot do
anything in their Outlook, so it all has to be done from Access. I can write
this code:

I am developing a system whereby I need the system to generate a customer ID
to be displayed in the following format:
L - Surname Initial
999 - General Autonumber code

Hi Group,
Here's my question.....
Raw data --->> Actual Number
193C-->>1933

When I send an eMail automatically out of Access, Outlook intervenes and
requires human intervention to release them. Is ther any way I can authorized
either destination or source email accounts to avoid the human interfention?
Yes, I now its needed to prevent worm, but it is a ...

I have a form based on a query with a combobox to select the ClientName and
then display all relevant information on the form. I would like to create a
report with information passed from the form to the report ( On the form
there is the client name, dates etc) that i would like ...

I want to use SQL to create an expression where Current date - Expiration
Date = DateDiff
and  DateDiff < and = 90 days
   When Datediff is < and = 90 days, pull the records that validates this

I had a form (with Tab1 control) based on a table that incremented the
Home_Addr_PK field and everything worked well. Recently i changed the form to
be based on a query as i had to add Tab2. Tab2 contains the same control
tblAddress_Home_Addr_PK. When i fire the New_Home_Address ...