Hey Guys,
I have an SQL Alter Table statment which removes two columns from a table.
However, the name of the table changes daily (the date is added onto the
end). Is there anyway of incorporating a Variable for the name within the SQL

I am routinely surprised and disappointed at the amount of functionality one
has to give up when upsizing from an MDB to an ADP (Access 2003). Now I find
that setting the 'Decimal Places' field to 2 (on the Format tab of the
Properties window) has no effect on the number of ...

I have some custom vba module procedures and I wanted to make some of the
parameters optional (by setting a default value) so that I could use
different signatures.
I was wondering if anyone could help out with and example of how you do it,

I'm using Access2000.  I need to be able to work with a subset of records in
my main database of public records from the register of deeds.  One of the
indices is by Book/Page.  I need to be able to determine what records might
already exist in the database with an existing ...

My application uses MDW file for security.
Is there any function to know the login password, like CurrentUser to know
the login name ?
Thanks.

I thought you could use the CopyObject method on anything but modules,
but I continue to get this error when looping though my dbs.  I've
tried TransferDatabase and get the same result
Any ideas?

I'm getting the error message:
"Compile error: Function call on left-hand side of assignment must
return Variant or Object"
I am attaching my module below, it is selecting the MsgBox line when I

I have 2 tables. 1st has 2 fields that will be used to look up in another
table and retrieve a value in a range.
Table 1 fields - Name, Priority, Sales
Table 2 fields - Priority, Range, Contacts

I already know it is not a good idea to save calculated text fields, but I
think this case is different. I am making a time card application and what I
have is a [Period Ending] text field where the user fill in the last day of
the pay period and it fills in the rest of the dates ...

Hi, Thanks for your help.
I have a DB that stores user reminders. A report has been created to get
users who need to be reminded of something they must do on a spcific date.
I am trying to formulate code to be able to send an email with the report

I'm trying to put together a function that will look at a date and determine
whether or not it's a "working day" (ie not a weekend or public holiday).
I've got a table (tblHolidays) with a field (HolDate) that  contains a list
of public holidays. I want to compare the date ...

is there any way to control the precision of a field in an ADP view? My
SELECT statement is multiplying 2 fields to create a 3rd, and the number of
decimal places in the output field seems to be the maximum of the precisions
of the input fields.

I would like to search a directory structure for all .mdb files and write the
file path of each one to a table.  I want to start at the highest level of
the drive and search all subdirectories without specifying the subdirectory
names.  Does anyone have any suggestions?

The query below works in acess 2002 but not 2003???
In fact it is worse in the query below it is the Cstr$  that causes the
problem
INSERT INTO JapanImpByMonth ( YearMM, Country, HS, Quantity, Yen, USD,

I have a sales summary report based on a multi-table query (with date range
criteria) which includes tblOrders (one off order information such as
OrderID, CustomerCode, ShippedDate, DeliveryCharge etc) and tblOrderDetails
(order details such as ProductCode, UnitCost, UnitSell and ...