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!
Any idea how to prevent the 'Unsafe Expressions' error message from displaying everytime Access '03 opens? (see attachment)
Thanks,
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
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
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
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
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
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.
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.
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
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: )
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
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. ;)
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 RelatedHi 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.
I get an error message when I open access 2003 database "database contains a missing or broken reference to the cacview.ocx version 1.0
All help so far says to go to tools>references.
My tools in the help menu does not have references
anysuggestions
ok, i'm probably gonna confuse a few ppl here, lol :rolleyes:
i keep getting a warning message when i try to open winamp from within access, is there any way i can stop this warning message from appearing?
any help would be most appreciated
I want to run a pop up message "invisibly".
I have a flash file that jerks when run in access
but if i run it with a pop up it runs fine so I want
to run the pop up but, keep it hidden.
Without using minimize.
I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row,
Any ideas how to delete them?
I have an AC 2003 db that a customer is running using runtime. There is a report in the db and when the customer tries to run it, a "save as xps" box comes up. The customer is running the db using 6 machines, only 2 of the machines are getting the error. Is this an issue with Vista?
View 6 Replies View RelatedHi 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.
Hi all, wondering if anyone can help me.
I have an access database, with a form called "Stock Maintenance", the controls on the form are QTY & Min QTY.
What i would like if possible, is once the Min QTY is below (10) an alert message/flag appears, saying QTY LOW Re-order Stock!!
I hope I have expressed what im trying to do.
any help on this matter would be greatly appricated.
I was reading the posting (
http://www.access-programmers.co.uk/forums/showthread.php?t=136643&highlight=programmatic+message) and one of the replays adivsed: "(1) Advise the user via programmatic message they they must exit the program for maintenance. If they don't get off after a couple escallated and timed messages, kill their job.". It is this possible in Access?. If so, how is it done.
Thanks
I am getting the following message:
"you tried to execute a query that does not include the specified expression qryMaxDays.Days Between 0 and 50 as part of an aggregate function."
I have other queries just like this and they run with no problem. any ideas? :confused:
SELECT Count(qryMaxDays.Days) AS [Number Of], qryMaxDays.Days
FROM qryMaxDays
GROUP BY qryMaxDays.Days
HAVING (((qryMaxDays.Days) Between 0 And 50));
Hello out there
I have a query to be conditioned by an input to a messsage box. An example could go like this:
SELECT [Quote politician].rubbish, [Quote politician].garbage, [Quote politician].bullshit
FROM [Quote politician]
WHERE [Quote politician].rubbish Like [Type the words or quotes of rubbish which your favourite politician has babbled];
The message box is not big enough to accomodate this long instruction. Is it possible to enlarge it?
nsv
I am trying to Right Join two queries which are basically from the same exact table, but when I do that I get the following error.
ODBC--called failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'MS1' does not match with a table name or alias name used in the query. (#107).
The following is a copy of my SQL
SELECT PqryExpiredPolicy.Policy_Number, PqryExpiredPolicy.Orig_Exp_Date, PqryExpiredPolicy.Insured_Key, PqryNewPolicy.Policy_Number, PqryExpiredPolicy.Name
FROM PqryNewPolicy RIGHT JOIN PqryExpiredPolicy ON PqryNewPolicy.Insured_Key = PqryExpiredPolicy.Insured_Key;
I have looked for this MS1 and cannot find it. Any ideas where I should be looking or what this means?