I have a database that I just put into production (a split database)
named ProductionInventory.mdb. This was a copy of my development
database in a development folder with the original name
DevelopmentInventory.mdb. Before deployment I did the split and the

I dont seem to be able to get this Filter right on my RecordSet for
some reason.
I have this code:
   Dim rs As Recordset

I have a database file in MS Works that has a  .wdb extension.  I would like
to convert it to use in Access or Excel or Word. Is that possible, and, if
so, how do I do it?  Thanks in advance.
Sam K.

When running on A2003 runtime with an mde i receive 3 security
warnings.
Do you want to block unsafe expresssions.
Then another security warning

I know I've done this before but I can't find where I did it or remember
exactly how.  The situation is this:
There is a form of equipment with primary key EquipID. There a continuous
subform of log items related to each EquipID. If the user dbl clicks a log

We are trying to enter birthdays in a 00/00 date format, and it does
not accept 2/29 or 02/29 as a legal date.  Any work arounds for this?
Thank you,
Amy Peterson, MMI

I have a form frmSchedule and report rptSchedule
I need to print out records 4 to 7 of the rptSchedule
when I hit cmdbutton on form
I can get it to print report for current form

---Report the current filtered records from a Form---
Hello All,
I've seen this topic discussed before, but the solution described then
doesn't work in my particular case.

I have a form with a large memo field that is designed to hold lengthy
comments. There are times when my users need to paste in e-mails
directly into the comment box. This works fine unless their e-mail
contains attachments, pictures, etc. In the event that their copy

I have a generic process that logs errors from different sources.  When I
call this code, I'd like to also submit the name of the function or sub that
is raising the error without having to manually type this in for each
instance.  For instance, (air code to follow)

I'm sure this is insanely obvious... but i can't figure it out.
I have a db that organises applications for an event. Included in the
applicant information is their date of birth. On a form or report i can
calculate and display their current age (=(DateDiff("d",[DOB],Date()))/365)

I have a recordset that includes the following data
Location
Territory
Sales

Can any one please tell me how to i lock the table thru password so
that no body can go in or even not to do any thing thru VBA.
Thanks.

  I'm new to Access and DB's in general.  I've taken over some light
duty support for a lab information system we use in house.  Most of our
dates are reported as "10/31/2006 12:30:00 PM" (With seconds listed in
the report field).

Is there a function that stamps the FISCAL Date (Starting from
October)?
I am trying to generate a Fiscal Date and an AutoNumber for a key
field.