hello, how do i prevent users from viewing code on error? there used to be
setting in previous versions in Startup, but thats gone in 03.
help !

Two questions:
1) When you split an Access 2000 DB where are "Forms"?  Are then in the
back-end or front-end?
2) When you split an Access 2000 Db and package the DB using office 2000

how to animate an object in microsoft access forms

I'm using the following code in an Access 2k database to save some reports to
MS Snapshot files:
strSQL = "SELECT * FROM CustRptSelectReports WHERE
CustRptSelectReports.Select = yes " _

I have posted this question on the other thread last week, but I am still
have trouble with the issue.
Basically, after the subform got populated, I had one text field from the
main form and one from the sub highlighted, but it is the one on the main

The following code is working fine, however when one record doesn't meet the
condition, the database skips this record without updating it. I tried to put
"Else : .MovePrevious", so it retest the same record again, however the
database goes into endless loop. How can I make the ...

How do i call (reference) a public proceedure in a form from another form?
Thanks in advance!

I have a text file that's 20 lines long.
I specifically need to replace the word "no" to "yes" on line 10 of the
file.
Line 10 reads: "Locked=No" and needs to be "Locked=Yes"

I am REALLY new to programming and Visual Basic Code and am learning by
doing.  Is there a reference or website that I can use to help "decode" the
syntax and how to implement it?

I have a table where I want to change a date for all the records that have an
asterisk in a particular column.  Here's my stab at the code:
Dim rst As New ADODB.Recordset
rst.Open "tblStaff", CurrentProject.Connection, adOpenDynamic,

I have a common routine which is always called on the form open event. This
function is passed a parameter of (me.name).
The function itself interrogated the Forms collection and sets various
controls as desired.

Hi gang,
I have an interesting issue.  Here is some code i use to copy existing
records for one person to new records for a second person:
Private Sub cmdTaskCopy_Click()

I have the foolowing code that seems to be causing trouble
SQLstring = "SELECT MSysObjects.Name FROM MsysObjects WHERE
(Left$([Name],1)<>'~') AND " & _
'"(MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;"

I am trying to build a (SQL) string in a piece of vb code that will be used
to open a recordset.
However if the string length becomes longer than 250ish characters it gets
truncated, meaning that an error occurs when the record set is opened.  I am

according to my best guesstimations the VBA code (in a2k app'n) should serve
to filter those records meeting the criterion
Private Sub fltCRA_AfterUpdate()
   If Me.fltCRA = "<All>" Then