quick question, does anyone know how to delete a whole table, not just the
data, through vba?

I am trying to incorporate the code for calculating for number of working
days to a query but i am new to code or edits :
'*********** Code Start **************
Public Function WorkingDays(StartDate As Date, EndDate As Date) As Integer

Can anyone help me with this problem?  Users regularly import a file from
Excel.  In Excel each new copy of the file is saved with the date, eg MyFile
120507.  The next day it will be saved as MyFile 130507 (UK format).  I can
automate this using either a macro or a module for a ...

I am upgrading an MS A97 database to A2k. due to an upgrade from NT to XP. I
need to change/update the code for auto PDF'ing the reports that are sent via
Outlook. Currently it saves the files as PDF to a temp location and then
opens an email and attached them.

I have this code where every time i select a stock name, it will query from
the main stock table and append that particular stock's all the fields and
records into a new table created. After that, I will use this table to
perform some calculation.

Hi everybody.
I have the following code that should add a filter to my form, the filter
string is exactly as I want it to be, but it only shows 3 records from about
110 that matches this criteria, I don't see any difference between those

I would like to have the text within a date field turn red and a message box
appear if the date entered is greater 90 days from current date. Can this be
done?

Does anyone have any ideas on how to enact a password complexity rule system
in a custom logon form?  I want to 1) restrict users to only use alphanumeric
passwords and  2) require at lest one letter and one number.  I don't want to
use a ton of code or a 3rd party assembly to ...

We see, I want to create in VBA of ACCESS a given sheet in
automatic, on which the variable
                   A1$= 10
                   A2$= Thank you

I am trying to do a work around for a problem in Access 2003.
Access Unbound OLE frames can be linked to an Excel sheet.
The properties that direct the frame to a specific sheet is through the
following properties of the frame.

I know I can convert to .mdb is that all?

I had the following code in which 3 option buttons on a form that can be
selected and the output is done per select. I added another option for html
output along with code but the results are both excel and html sent to my
desktop instead of the single selection of html. Can ...