Alarm form

[Kay]

Hi

At last managed to create a basic reminder alarm for my database. I
have used a table to create alarm fields and a form to sotre the
reminders. I have come across 2 problems

1) it may be easy but ive never come across it before. I have used a
msgbox to alert the user using the following
MsgBox ("A Job is Due.... Alarm ID = " & AlarmID & _
(" Alarm Message = ") & AlarmMessage & _
" Please tick the reset box on the alarm form to reset the alarm")

The problem is this is displayed all on one line. How can I get it to
drop some of it to go on the next line.

2) I was thinking of using a form to display the message as this can be
customised and look better. In my message form, how can I refer to my
fields in the main form

e.g msg on form = "A job is due.... Alarm id =" alarmid
"Alarm Message" = alarmmessage

How can I get the alarmid and alarmmessage to refer to my fields on the
main alarm form

Your help will be much appreciated
Thanks

 

[Guest]

(1) & vbcrlf &
(2) Forms!Formname.Controlname

 

[Guest]

See answers below questions

Hi

At last managed to create a basic reminder alarm for my database. I
have used a table to create alarm fields and a form to sotre the
reminders. I have come across 2 problems

1) it may be easy but ive never come across it before. I have used a
msgbox to alert the user using the following
MsgBox ("A Job is Due.... Alarm ID = " & AlarmID & _
(" Alarm Message = ") & AlarmMessage & _
" Please tick the reset box on the alarm form to reset the alarm")

The problem is this is displayed all on one line. How can I get it to
drop some of it to go on the next line.

You can use vbCrLf or vbNewLine to start a new line on your message box
MsgBox "This is the first line" & vbCrLf & "This is the second line"

2) I was thinking of using a form to display the message as this can be
customised and look better. In my message form, how can I refer to my
fields in the main form

If you use the message box (much easier and faster) you just use
Me.SomeField
If you use a form it would be Forms!AlarmFormName!SomeField

e.g msg on form = "A job is due.... Alarm id =" alarmid
"Alarm Message" = alarmmessage

How can I get the alarmid and alarmmessage to refer to my fields on the
main alarm form

Sorry, I don't understand this question.

 

[John Vinson]

1) it may be easy but ive never come across it before. I have used a
msgbox to alert the user using the following
MsgBox ("A Job is Due.... Alarm ID = " & AlarmID & _
(" Alarm Message = ") & AlarmMessage & _
" Please tick the reset box on the alarm form to reset the alarm")

The problem is this is displayed all on one line. How can I get it to
drop some of it to go on the next line.

Use

& vbCrLf &

where you want a new line.

2) I was thinking of using a form to display the message as this can be
customised and look better. In my message form, how can I refer to my
fields in the main form

e.g msg on form = "A job is due.... Alarm id =" alarmid
"Alarm Message" = alarmmessage

How can I get the alarmid and alarmmessage to refer to my fields on the
main alarm form

for alarmid, use

[Forms]![MainAlarmForm]![AlarmID]

and so on.

John W. Vinson[MVP]

 

[Kay]

thanks for all your help guys, got another problem with this code

If Me.AlarmDate = Date And Me.AlarmTime <= Time() And Me.Reset = False
Then
MsgBox ("A Job is Due"), vbCrLf & _
("ALARM ID = ") & AlarmID & _
vbCrLf & ("ALARM MESSAGE = ") & AlarmMessage & vbCrLf & ("Please tick
the reset box on the alarm form to reset the alarm")

error = type mismatch

can anyone help please

 

[Kay]

Actually just got it working, Is there a way of changing the text and
colors of a messagebox

 

[John Vinson]

Actually just got it working, Is there a way of changing the text and
colors of a messagebox

Not really. You might want to use a little popup Form instead, that
gives you full control.

John W. Vinson[MVP]