Hi I am new to Access and I am interested in knowing how can I make a messagebox that will pop up when a user has not put in information in a certain field.
Before the record is save I would like the messagebox to say "You have to put something in such and such before saving record". I don't know if this is hard but any help would be appreciated!
I am trying to add an expression into a messagebox but I am not sure how to make access view it as an expression instead of as text (I am new at using the expression builder)
=MsgBox("The current severity rate is: @ «Expr» Reports![File name]![No of Lost Days].RunningSum «Expr» @ ",64,"Severity Rate")
I am sure that i am probably way off with the actual expression as well but I can look at that afterwards. Thanks in advance for any help.
I was wondering if any one could help me? i wish to create a button and that button will bring up a messagebox showing items of more than a 3 year peroid.
View 1 Replies View RelatedHello all:
Code:
Dim rs as object
Set rs = Me!RecordSet.Clone
rs.Find first "[Student_ID]='" & Me![Combo134] & "'"
Me.Bokmark=rs.Bookmark
If Me! Major_CD = "F16" or "616" or "611"
msgbox "MUST COMPLETE SURVEY"
End if
End sub
A student ID number is entered into a combobox and it returns name, Major_CD(Major Code) and Degree type.
If the major code is "F16" or "616", a message is displayed.
How do I suppress this messagebox the the student has a different major code? In other words, there are students in the database with other major codes that are 111, 121, 363. I would like for the other major codes to NOT display a message box. Right now, it displays a messagebox for everyone.
Any ideas?
Many, many thanks
Dion
I designed a combox and also set the property of 'limited to list' to yes. I also declared the function NotInList with my own message box. But, the MS-Access default warning message box still comes up after displaying my one.
If I turned the property of 'limited to list' to no, it can trigger the function at all.
Does anyone here have any idea on how to turn the system default warning message box off?
Many thanks
I need a special messagebox witch returns integer value to public variable.
now I have made it the problem is how to use it.
In Sub where the messagebox form is opened the Sub should wait until it get the response from messagebox_form. That is because this sub will save it in the table.
So how to get te sub to stop and wait until the public variable is changed
(if I use some kind of loop I can't use the form at the same time)
-thans, Jalmari
This may seem a very simple question, but I really don't know how to do it. Basically, I want to MessageBox contents of a table with a button. I have a table called Map, and has two fiels: Column Number and Description. When a button is pressed, then I want a messagebox to come up and show the column number and the description of a single field. Although I know it is very wrong, here is the code I used for this (r![column Number] = 4 is meant to be the forth column number in the table):
Dim d As Database
Set d = CurrentDb
Dim r As Recordset
Set r = d.OpenRecordset("Map")
r![column Number] = 4
MsgBox "Column No: " & r![column Number] & ". Description: " & (r![Description])
By the way, there are seperate buttons for seperate fields. It is DAO as well
Thanx in advance