Show Message Box

Mar 8, 2008

Hi there,
i have a field called numbers - i need to throw a messgae box alert if the value within taht field reaches or is 5. I have records so if within any of these records if the number field contains say 5 then it should show john's number has reached 5. So it must read the first field name of that record and teh number field of the record.
I've been trying to use the macro tool - but no luck yet.
An start would be just to show that the number field has reched 5 without showing the first field record i.e. john not shown.
Anyone have any idea how i could do this.

View Replies


ADVERTISEMENT

Show Message Box

Apr 7, 2008

Is there a way to show a message box if the user leaves the parameter for a query empty or inputs the number in the parameter in an incorrect format?

View 3 Replies View Related

Message Box Show Only First Time

Oct 26, 2006

Hi guys.

I have a few problems with my message box.

1. How do I enable a message to pop up only the first time I click a save button on a new record in a form?

2. How do I run the following

Me.Home_Tel.Locked = True
Me.Student_Name.Locked = True
Me.Class_Enrolled.Locked = True

ONLY AFTER you click Yes on the message box?

After you click yes, it can be locked forever, but not before you click the save button or if you clicked No on the msg box.


3. For another command button, how do I disable it after you have clicked it, and not enable it again until after you enter some value into a text box?



My message box now:


Dim msg As String
'Ask user if they want to save the record.
msg = msg & "You cannot change Student Name and Course Enrolled after you save. Proceed? "
If MsgBox(msg, vbYesNo, "Warning") = vbYes Then
'Run the command
DoCmd.RunCommand acCmdSaveRecord
'Lock the following keys
Me.Home_Tel.Locked = True
Me.Student_Name.Locked = True
Me.Class_Enrolled.Locked = True

Else
Me.Home_Tel.Locked = False
Me.Student_Name.Locked = False
Me.Class_Enrolled.Locked = False
Exit Sub
End If

View 4 Replies View Related

Forms :: Show Date In Specific Format In Message Box

Jan 6, 2015

I have a messagebox and want to know if it is possible that the messagebox give me a date as 15/01/2015 and not 15/01/2015. Using dailog box as messagebox

Code:
Private Sub Save_Click()
Dialog.Box "Tape # : " & Me.Tape & vbCrLf & "Sticker # : " & Me.Container1 &
vbCrLf & "Book # : " & Me.Book & vbCrLf & "Date send Out : " & Me.DateSendOut &
vbCrLf & "Date to be back : " & Me.DateToBeBack & vbCrLf & "OS : " & Me.System, ,
"Saving............."
End Sub

View 5 Replies View Related

General :: Show Loading Message While Database Is Opening?

Oct 23, 2012

I have a split database with multiple users. Since I split the database, it runs slower than the unsplit version. I understand this happens. I would like to have a message pop up when the database is loading. It takes approx 2 mins to load. Users get impatient and start clicking. So, I wanted to have a message pop up to let them know it is opening.

I have the same problem with forms loading, I have 5 forms and each takes about 4 secs to load, so thought about a loading message there too.

View 14 Replies View Related

Modules & VBA :: Show Pop Up Message Depending On 2 Fields Value Differences

Oct 7, 2014

I have 2 fields on my form service interval combo box and vehicle mileage text box I m trying to create a pop up message on there values

if service interval is 12,000 and the mileage entered in the vehicle mileage is over 12,000 then show pop up message.

this works but I'm sure its wrong don't no why I need the -1 anyways here's what I have

Code:
If Me.Vehicle_Mileage.Value > Me.Cboserviceinterval.Column(1) - 1 Then
msgbox "test"
end if

Now my problem what I can't get it to work . I still want the pop up message, if say the service interval is 12,000 and mileage entered in the vehicle mileage is 1,000 miles below the service interval I still want the same pop message but if 2,000 or more below service interval then no pop up message .

I have tried a number of sequences with no avail....

View 3 Replies View Related

User Defined Show/No Show Query Results

Jul 5, 2005

I have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results.

i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..

View 10 Replies View Related

How Do I Show Convert Vertical Entries To Show Horizontally

Jun 7, 2007

Is it possible to convert fields listed down to show across.

IDNo Code Position
AAA B01 1
AAA C01 2
AAA D01 3
AAA E01 4

I want to show it as
IDNo Code Code Code Code
AAA B01 C01 D01 E01

Is this possible using Access 2003?

View 7 Replies View Related

Query To Show Show Different Results From Same Group

Jun 11, 2006

I wondered if someone could help.

I have 3 columns of data within a table and from a select query am trying to seperate certain groups.

Table 1

yr period valuehome

2006 0 100
2006 0 10
2006 1 1000
2006 1 800
2006 2 60
2006 2 50
2006 3 40
2006 3 10
2006 3 5
2006 3 70
2006 4 50
2006 4 5

I wish to show both results for period 0 and an accumulative total for periods 1-4

so results would be

year period Total sum

2006 0 110
2006 1-4 2090

Can anyone help?

thanks

Paul

View 5 Replies View Related

Reports :: Show Detail - Using Section Header As Hyperlink To Show / Hide Detail

Aug 13, 2013

I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:

Code:
ABC Co.
ZYX Co.
123 Co.

If I click on ZYX Co., I want it to show the contracts for ONLY that customer:

Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.

Right now, my code looks like this for On_Click:

Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If

But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?

View 1 Replies View Related

Show/not Show Control

Mar 14, 2006

how can i control a field to show/not show at the query level?
let's say i have a query (from a table) like this

[regularPrice] [isOnSale] [onSalePrice]

where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing.

i've tried to put "[isOnSale]=Yes" in the Criteria, the query will filter out only those records that's on sale, which i don't want...

please help :confused:

View 2 Replies View Related

'03 Message

Jul 15, 2005

Any idea how to prevent the 'Unsafe Expressions' error message from displaying everytime Access '03 opens? (see attachment)

Thanks,

View 3 Replies View Related

Cant See Message Box?

Sep 26, 2005

Hi All,
I have a form with a comboBox to select "employees".
I am using the combo.dropdown command to display 8-rows of employees.
I also use the Not_In_List procedure to check for NEW employees, and if not in the list , then the msgBox appears asking "Do you want to add this employee?"

The problems is the MsgBox is behind the dropdown menu of listed employees. Is there a way I can bring the MsgBox to display on top of everything, something like "acDialog", close the drop.down?

Thanks for your help....Enivia

View 2 Replies View Related

Yes No Message Box Help

Oct 27, 2005

Hello,

I use a command button to post an invoice amount. I would like to prevent accidental overwriting of a current invoice amount. This code overwrites the amount even after clicking “No”. I would like the cancel the action when “No’ is clicked. Please help!


Private Sub PostInvoice_Click()
On Error GoTo Err_PostInvoice_Click

If IsNull(InvoiceBalance) Then
[InvoiceTotal] = Me.InvoiceTotal1
[InvoiceBalance] = Me.InvoiceTotal1
[DueDate] = Me.InvoiceDate + 30

Else
MsgBox "You are about to overwrite the current invoice balance"

MsgBox "Are you sure you want to overwrite the current invoice amount", vbYesNo
If vbYes Then
[InvoiceTotal] = Me.InvoiceTotal1
[InvoiceBalance] = Me.InvoiceTotal1
[DueDate] = Me.InvoiceDate + 30
Else
Exit Sub

End If

End If


Exit_PostInvoice_Click:
Exit Sub

Err_PostInvoice_Click:
MsgBox Err.Description
Resume Exit_PostInvoice_Click

End Sub

View 2 Replies View Related

Message Box Yes Or No

Nov 30, 2005

I have a Macro that I made to archive 4 different tables...using append queries and delete queries and attached the macro to a button on a form. I had to disable the warnings because there were just too many of them...i was wondering if there is a way to customize one warning (like: Are you sure you want to do this? YES NO) is there a way to do this and add it to my existing macro. I want to give the data enterer a chance to make sure they understand what is going on. I know i could create another form as a secondary confirmation screen and have done this for the time being but a pop up warning would look much more professional

thank you in advance

View 1 Replies View Related

Pop Up Message

Jul 17, 2006

I would like to display a pop-up message on a form when a specific field has been changed. I know how to add teh pop up message for that section; however, I would like the pop-up message to display data from a sql statement. Here is the sql:

select PurchSpecialHandling FROM InventoryMaster1 WHERE Part=(input from form)

I need to know what to place for the input from form, how to assign a variable to the result, and display the data. Thanks!

View 4 Replies View Related

Pop-Up Message To Appear

May 9, 2005

Dear all:

I have created a form with a command button called "Dual Degrees".

This is based on a query. When this button is pressed, it returns a report with the corresponding image on it. It works well, but when there are no students in the database with dual degrees, it returns an error message. The message is: "Run-time error '13': Type Mismatch.

When I press the debug button, It defaults to this: Me! [ImageFrame].Picture = Me! [DEANS_SIGNATURE]
End Sub

Is there a way to for a pop-up message to appear when the Dual Degrees button is pressed saying "No Dual degrees to print" if there are no students in the dastabase with dual degrees?

Thanking in advance,

Dion

View 5 Replies View Related

My Message Box

Jul 18, 2005

I want to create my own message box that will tell the user after they click the trasnfer button that they are about to transfer records to another table. They should be able to click ok or cancel. Access already has some warning boxes but I disabled those and just want to create one.

THANKS

View 2 Replies View Related

Code For Message Box

Apr 24, 2006

I am trying to write the code which will show a Message Box if another field in a table is "Not Null" . Here is what I am attempting:

Upon exit of [JobFieldname]
Look at record in [Table].[Jobinfo]. where [JobFieldname] match
If [Yes/Nofieldname] = "Yes" then
Open Message Box "My message Here"


Can someone help me? I havn't found the answer looking through the threads.

View 4 Replies View Related

Own Wornings Message

May 3, 2005

I use a list box with textfield to fill a form in but when I fill in data which is not in the listbox, I get a warning from MS Access: "The data you privide is not an item from the listbox , Please choose an item from the list." No probleme at this point!

But me I want set off this wornings and to use my own worning message. I have tried D0cmd.setwornings False.

I get my own worning message but after I still get the message from MS Access.

Any Idea how to solve this probleme. I will be gratiful.

Thanks in advance for your answers.

View 3 Replies View Related

Message For Jrjr

Jul 13, 2005

Can you please also help me with this, it is the database that I am trying to set up for a Shopmobility Sceme and need to tie up some loose ends before I go live.

I have condensed the original database and left the relevant part in.

On the Usage form when I enter a vehicle number I would like it to automatically show Type, Make & Model

And when I type Membership Number in I would like it to automatically on the usage form show Authorised, first name & Last Name.

Also on the usage form. when I enter Time Out and Time Back it gives me a total in the field but does not show up in the usage table.

Many thanks for your last input that is now working fine.

Fred fox

View 5 Replies View Related

Warning Message...

Sep 14, 2005

Anyone know how to suppress the folowing warning:

(I don't have admin rights so my solution will have to be done within Access :rolleyes: )

View 3 Replies View Related

Error Message

Sep 28, 2005

While going to the design mode of a form, I regularely get the following message :

Microsoft Access can't run the macro or callback function 'fDesign'.

In my Dbase there is no macro with that name.
Can anyone tell me what this messages means and how to get rid of this thing.

Running Win XP, Access 2003 Sp1

View 2 Replies View Related

Error Message

Jan 23, 2006

I have attached a screen print of an error message I recieved on my access database. I finally got it to come up, but only after a few pop up boxes with this error message.

I do know the shared drive it is housed on went on the fritz. So I copied it and pasted it to my desk top. Grrr...I thought this message was due to the flipping shared drive. But now, I recieved it on my desk top too.

Anywho...can someone look at it and tell me what it means.

Thanks alot.

PS, i know my desktop has to much stuff, so don't go there. ;)

View 2 Replies View Related

Error Message

Apr 3, 2006

Hi can anyone help i keep clicking on a qry and it comes up with this message "Syntax error (missing operator) in query expression 'tblSTSLimits.Max Short'. but Max Short is correct can anyone help

View 1 Replies View Related

Error Message

Aug 9, 2006

Hi all,
I face a problem while openning a form.
It gave me this error message:

The expression On Load you entered as the event property setting produced the foolowing error:
User-defined type not defined.

What to do?

Sorry for bothering you.

Thanks & Regards

Mark K.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved