J
JNariss
Hello,
I have gotten myself into some trouble trying to create this database.
However, slowly but surely it is coming along.
Here is the scoop:
I have 2 forms: Request Info and Acknowledge
They are defined by the Request Info's field (Primary Key) "RequestID"
(The Acknowledge Form contains the RequestID field as it's Foreign Key.
I have a Splashscreen which opens when the database is first opened and
gives users choices I have created. One of those choices is titled:
"Acknowledge A Request".
I would like that button to do the following:
1. Open the Acknowledge Form
2. Find the RequestID from the Request Info form so when the user fills
out the Acknowledge form upon opening it, it will be linked to the
Request Info form by ways of the RequestID. So I want the user to have
to enter a RequestID Number. My Acknowledge form will open up with a
locked RequestID field indicating to the user that it is the correct
Acknowledge form to fill out. I also have on the Acknowledge form a
button to View the original request incase the user needs to take a
look at it.
3. Finally I need to display a MsgBox to user only if the RequestID is
not between 1 and 99999.
How do I do all this?
I understand I need to create a Macro. So I have and I called it what
else but "Acknowledge". My macro is set to do this so far:
OpenForm
Form Name: Acknowledgment
View: Form
Window Mode: Normal
GoToRecord
Object Type: Form
Object Name: Request Info
Record: GoTo
MsgBox
Message: You have entered an Invalid Request ID - Please check and
try again
Beep: Yes
Type: Warning!
Title: Invalid RequestID
Condition: [Forms]![Request Info]![RequestID] Not Between 0 And
99999
That is it..................................
So what do I have to do in order to fix the Acknowledge Macro?
Any ideas would be great and once we get through this we can move onto
my next upcoming problem that I'm sure I will run into later on
today!!! hahaha
Thanks,
Justine
I have gotten myself into some trouble trying to create this database.
However, slowly but surely it is coming along.
Here is the scoop:
I have 2 forms: Request Info and Acknowledge
They are defined by the Request Info's field (Primary Key) "RequestID"
(The Acknowledge Form contains the RequestID field as it's Foreign Key.
I have a Splashscreen which opens when the database is first opened and
gives users choices I have created. One of those choices is titled:
"Acknowledge A Request".
I would like that button to do the following:
1. Open the Acknowledge Form
2. Find the RequestID from the Request Info form so when the user fills
out the Acknowledge form upon opening it, it will be linked to the
Request Info form by ways of the RequestID. So I want the user to have
to enter a RequestID Number. My Acknowledge form will open up with a
locked RequestID field indicating to the user that it is the correct
Acknowledge form to fill out. I also have on the Acknowledge form a
button to View the original request incase the user needs to take a
look at it.
3. Finally I need to display a MsgBox to user only if the RequestID is
not between 1 and 99999.
How do I do all this?
I understand I need to create a Macro. So I have and I called it what
else but "Acknowledge". My macro is set to do this so far:
OpenForm
Form Name: Acknowledgment
View: Form
Window Mode: Normal
GoToRecord
Object Type: Form
Object Name: Request Info
Record: GoTo
MsgBox
Message: You have entered an Invalid Request ID - Please check and
try again
Beep: Yes
Type: Warning!
Title: Invalid RequestID
Condition: [Forms]![Request Info]![RequestID] Not Between 0 And
99999
That is it..................................
So what do I have to do in order to fix the Acknowledge Macro?
Any ideas would be great and once we get through this we can move onto
my next upcoming problem that I'm sure I will run into later on
today!!! hahaha
Thanks,
Justine