I have an Access database application with a lot of custom row
functions written in VBA. In other words, a lot of queries contain
calculated fields which use functions defined in the modules.
I am now thinking about upgrading the database from Access to SQL

At what point is a Form added to the Forms collection or a Report added
to the Report collection?  I.e., listed as currently open.  The reason
I ask is that I have a subreport for an exclusive separate condition
that may or may not have data.  When it does have data its total needs

Hey, I have a fairly new site I would like you to visit:
http://www.wizardsolutionsusa.com
You may find it valuable, or you may not.  Either way it's worth 90
seconds of your time to take a look, sign up at the forum, or just

How can I change the printer page layout to landscape via code? Basically I
would like to avoid having the user set the layout every time manually.
Thanks
Regards

Is it possible to get a list of fields a user has changed on a form before
the form is saved, for history purposes? If I can also get the new values
for these fields then that would be even better.
Thanks

Is it possible to retrieve field properties from a table in access2000
using code?
I have tried:
"

I have been using the code below successfully for almost a year.
yesterday, I began getting a run time error 6 (overflow).  I am using
the code in an Access 2000 database.  Can anyone help me understand
what I can do to correct this?

Does anyone know sql of the PV function in Access?  (same function in
Excel)
In access the inputs are PV («rate», «nper», «pmt», «fv»,
«due») where rate = discount rate, nper = number of payments, pmt =

I want to duplicate 20 records with the same date.  except the date field
which  should not be duplicated but rather be incremented by one day.  The
process could be called by a button on the main form
It is a record of the occupancies in a homeless center.  It is the simplest

I have a subform and fiel called Payment when i enter 35.00 and click
the new payment command button still displays previous payment.
How would i create code so that when i hit the new payment command
button instead of displaying previous payment entered it would show as

What is the easiest way to accomplish internationalization in Access
application?

Can someone highlight the major differences between A97 & A2003. I
still use my old 97 and still love it. But some are wanting me to
migrate to 2003. If anyone could highlight the differences I would
appreciate it ....Thanks!!  Brian

Used the "find duplicates" wizard to identify approx 500 duplicates in a
single table. How do you delete the duplicates without doing it one at a
time?

I have a client who wishes to upsize an A97 system from Jet backend to
SQL Server 2000.
They have up to 4 users.
Will they need to buy the minimal 5-seat SQL Server product, or would

What will be the best database design for an inventory control that
uses expiry date for its products.
Over a period of time, a particular product will have many expiry date
and that one particular expiry date could have multiple products