I know mde's scramble code, but are there any products or projects that
obfusticate VBA code out there? I see that FMS has one, does anyone have
experience with it?

I am currently using Access 97 to provide a reporting module in a
client's service system. There is a job service module from another
provider in Access 97 (shared use on a networked FE MDE using runtime on
each operators PC) and my reporting Module also in Access 97. Whilst the

On the On_Click event, I have the following code:
Private Sub Report3Button_Click()
   Dim stDocName As String
   If acCtrlMask = 2 Then

I have a form (which contains subforms) which, when opened, checks to see if
there are any records in the recordset and if there aren't, it adds a new
record.  The db was originally created in Access 97.  When the code runs now,
in Access 2000, I get an error:

I'm new on Access XP.   I'm able to import the text file in the table.  I'm
trying to convert the text file (date) to Access Table (date).   In the
table, I set "Date/Time" but it won't allow me and the message said "Data
Type Conversion Type".   I change to "Text" and it works.  ...

I'm fairly new to the coding world of Access & SQL and was wondering if
someone could point me in the right direction to learn how to send and
received data while in Access to my SQL Server.  I have several stored
procedures that contain the data I need to see in Access (ie: ...

I have a command button that transfers the contents of a table to a
delimitred text file:
DoCmd.TransferText acExportDelim, "specJan", "tblExtrUnits", strPath &
strPeriod & "-ESPCos" & ".csv", False

I have a simple timeslips application that allows employees to log in/out
during the day.  However, the employees very quickly learned that they need
only modify the machine's clock in order to clock in/out at the time they
were supposed to be in/out rather than the actual time.

Access 2002 offers a lot of ActiveX components to be used on a form.
Unfortunately, I can't find any demo demonstrating these components.
So the question is: does anybody know a website demonstrating (these)
ActiveX components?

I have a form that uses several combo boxes (Designer, Salesperson, and
Style) to select data. My users have requested the ability to leave one or
more of these fields blank. (For example, leaving Style blank would pull all
records for the particular Designer and Salesperson, no ...

I would like to append to the tbl_Hotel table all the records from the
tbl_Flight table.  The catch is that I would like to append tbl_Hotel for
each night between two dates in tbl_Flight.  So someone arriving 1 Oct and
departing 7 Oct woiuld have appended to tbl_Hotel one record ...

i am trying to enable my user to filter records when using a form called
"Screening Log (Edit Only)" by creating a combo box on the said form called
"fltCRA". the AfterUpdate event VBA code is jsut below:
Private Sub fltCRA_AfterUpdate()

hi - i've been asked to require a strong password in my DB
i.e. 8 chqaraqcters, upper and lower case letters, numerals and a special
character .
is there a way to require something like this in a table field?

    I have a form for an access applications that has toggle buttons
used for approval of a design.  I wish to put the approver's name and
the current date on the design form (different from toggle button form)
without opening it.

I have a button in my form that opens up an application.  I would like to
change that just slightly though.  Is there any way to detect whether or not
the program is already running, and if it is, task switch to that program?  
Or if it isn't open already, then it would just go ...