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.
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?
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
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
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!
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?
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.
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.
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
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,
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?
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.
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.
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?
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?
