Using 2003 - I'm working with three forms.  "Main", "JournalSub" and
"JournalPopup".  JournalSub is a subform of Main.  I want to be able to click
a button on the JournalSub that brings up the data entry popup JournalPopup
for entering new journal records.  

I have successfully created code that will cancel an event based on the
value of a control.  However, after the Event is Cancelled, I would like a
MsgBox to display.  I do not know the right code.
The following code is on the BeforeUpdate Event of a control chkBoxControl,

I have "NUMBER" which are area codes and phone numbers combined to look like
8471234567.  New records are added to tblResume by:
1) frmInputting, which has txtbxINPUT_NUMBER and option group AREA_CODE.
2) txtbxINPUT_NUMBER is just the seven digit phone number.

I have a form coding that changes a varible to double spacing by use of space.
What I need to know is how do I change it to a module with the following
answered:-
a)  How to I call the module from the form coding passing text0 to module

I'm having a small problem getting a msgbox to pop up on a form when the user
enters a number larger than a number stored in a related table. Here's the
code for the after update of the text box on the form:
Private Sub LeafLbs1_AfterUpdate()

I am installing an Access application (front-end/backend) in a large office
where the backend-database is located in another server, and they want to
know what port they should open on their firewall.
When I look on our Windows firewall and exceptions, I find Microsoft Office

I am trying to navigate through records on a form w/a combo box.
I have this code running in the combo box.
   Dim rs As Object
   FilterOn = False

I have chinese characters showing up in reports in a comments section that I
believe has no data.  Just one symbol for every record.
Any Ideas?
TIA,

I am  creating a new database.  I considered copying my existing database to
use as a general framework for the new one because it has much of what I need
already created.  My question is - when you copy a database does it use the
same Wrkgadm.exe file as the original?

I am using Access 2002 and I wanted a calendar control similar to a date and
time picker without the hassle of null date.  So I decide to use a toggle
button next to my date text box  I also used a calendar control.  In my
toggle button (toggleAssignedDate) I use on Click event ...

i have database and i want to share with my collegues at work
i need a code to keep record on the user hwo entered or updated records
suppose users are ( user, date)

On my form is a text box (size 60) called Organization. Rather than use the
record selector to find the appropriate record, I decided to change this
field to a combo box to allow the user to select from the drop down or to
enter a letter & it jump there. It seems to work, but the ...

I am using a collection (in place of an array) to house some temporary
items...
Is there a way to easily remove ALL items from a collection? The way I read
it, you have to loop through all collection items and use the .remove method

I want to open my database directly to a form and filter that form to only
show info pertaining to the user that is currently logged in.
Now I have a User Database that assings a "rep number" to each person.
My forms already sort the data by the "rep number"

Hi my name is Mehdi,
my question is how to get the result of the calculation that already has
done in orders form, like Order Total, into the another form like order by
customers subform. Or generally refer to any calculation result in any form