I have a database that tracks school districts and all of the construction
projects that they are planning.
The main form of my database is basically a "shell" form with an unbound
subform.  When a user clicks on a menu option it opens the desired form in

I would like a user to enter a caption for a label in the form header.  So I
coded a button as follows:
Private Sub Command41_Click()
Dim x As String

I have data that is full of CRLF and space characters (\x0D and x\0A) that
have to be removed in a temporary holding table called TempNarr (the
original data can't be altered). I've got the Replace function working
perfectly in a button's onClick event, but can't figure what to ...

Hi Ken,
Still trying to get my dates to work.  With the code you supplied before
when I test it I do dates less then 2002 and more than 2005 (i.e 2000 or
2006) this works fine.  But when I try to erase the date to go to the next

I have some popup-forms with a button that opens a report in preview.
How do I hide or close the form to preview the report.
I have tried to set form.formname.popup= false on the button, but it doesn't
work.

I had a working app that I went in and renamed all the tables and forms etc.
Now a button on my app won't work and comes up with the error:
"An expression you entered is the wrong data type for one of the arguments"
Does anyone know what could be causing this ? I'm stumped. I've ...

I have a command button which runs many file operations.  Is there a way to
prevent user input ftom the keyboard or mouse while the file updates, etc are
taking place?

I have a read only form with a edit button to open a NEW form to edit the
current record.  This new form is already created, but when i click on the
edit button i get an error that the table is already open and can't be
modified.

The database I have gotten has an event table with EVENT_ID as the PK.
The formate of the information is EVTID# where #=the next highest number
in the list.
The object of this code is to strip "EVTID" from the info in that field,

I have created a simple login screen for security and I am trying to figure
out how to create a way that  only the records show from the login point
forward that this user created. I don't want other people seeing those
records unless it is a adminisitrator.

I have been trying to have one list box set the row source of another list
box, without success in Access 2003.
Example: control "A" has a list of products-rowsource from a table.
Selecting a

what code do I use to send a meeting request by e-mail using VBA in Access
2000.
Thank you in advance
Carole

I want to be able to open another instance of a form by pressing a button so
that i can have multiple/different records of the same form. im using this
code (on the onclick event of the button):
-------------------------------------------------

How can I get variables passed to a report from a form to print on my printer?
I have a unbound text box in my report 's Page Header section that displays
custom text depending on values selected from my form. Everything works as
expected while viewing in the report window. If I ...

I have a form that has contract information.  The scanned contracts are
located on a shared network drive and I have the addressed stored in a table.
I want the hyperlink to open the .pdf of the contract.  With the following
code, it opens Adobe and then closes it immediately.  ...