Related Topics

Macro Message Box Pop Up When Append Query Is Zero

Can I create message boxes on a yes/no drop down menu with a macro?
Is it possible to create a macro pop-up message box on a yes/no combo drop down selection menu on ms access 2007? I've created a form titled Admin staff and a label text box entitled "Isthis a tentative booking?" - when the user selects yes a pop message will be displayed and when the user selects no, again a message box will be displayed with a different message.if so, howcan this be done?but when I implement the code in 2007 I receive error messages.


Yes or No pop up
Is there a way to get a macro to have a yes/no pop up message? or is that something I will need to figure out how to do with vba? The only message I can figure out with a macro is a simple message with ok in it.
I am trying to figure out how to get a yes/no message to pop up if certain conditions exist after the macro opens a new form.


Surpress Append Query Pop Ups
I know that you can go into the Access Options and uncheck the Confirm Action Queries under the Advanced section to prevent the Pop Up dialog boxes when you run an Append Query, but I am curious to know if there is a way to prevent them without unchecking this box


Append query runs on its own but not in a macro
A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and has run thousands of times without any problem.

The client has asked that I make the database work for multiple factories. Without going into too much detail the same macro and append query are needed in the spin-off databases (one for each factory).

The problem is that the append query will not run in any of the spin-off databases as part of the macro although the macro itself is unchanged, but will run in isolation when it performs correctly and gives no error messages. I have run the macro with SetWarnings ON, but only get the warnings that you would normally expect.

I have pasted over the macro, the append query and the underlying select queries from the original database, but to no effect.


Pop-up form to stay on top of other forms while executing VBA code
I'm back again. I wanna ask for some help.

Question: How do I create a pop-up form that stays on top of other forms, or even on top of Microsoft Access (similar to a message box) so that Access freely executes some VBA code, and the user is prevented from accidentally halting its execution?

For example:

Private Sub AppendDatatoTemporaryTable
DoCmd.OpenQuery. 'To clear temporary table of any existing rows of data
DoCmd.OpenQuery. 'To append sales data
DoCmd.OpenQuery. 'To append purchases data
DoCmd.OpenQuery. 'To append collection data
DoCmd.OpenQuery. 'To append disbursement data End Sub

While the above code executes, I want a form to appear. What properties can I set to achieve this form behavior. I can't use a message box for this task because a message box pauses a code execution.

Thanks guys! Glad I found this site months ago


Macro Msgbox
I need some urgent help.

I need to create a pop-up text box that requires me to display the data of a certain field.

for example, I have a form that allows me to update these particulars:

- name
- address

and after manually typing in the details, I would have to click on a command button that creates this pop-up msgbox that displays "hello, (name)! you live at (address)."

i've applied the macro msgbox function. however I was stuck for a long time at the message part! how can I put name and address field into the actual pop-up box


Automatic Pop Up Message Box
I don't really know where to start with this. I'm trying to make a pop up message appear on the Database at 10:00 am asking all users to exist the database so I can run my updates. How would I create the Macro/VBCode to do so


remove Macro Warning message
How to remove all the Warning when the Macro run an click Yes, some of the warning message are

You are about to run a delete query that will modify data in your table You are about to delete 200 row(s) from the specified table.

You are about to run an append query that will modify data in your table Microsoft Office Access can't append all the records in the append query (150 fields to Null fue to a type conversion failure.)


An append query in Access 2010 with a parameter that I want to loop.
I have an append query with a parameter. I want to be able to run the append query several times. I want the user to be able to enter in the parameter in a pop-up box. Is it possible touse a loop command?


pop out message!!
how to do the pop out message when user log in? IN my case, if there have pending leave require to approve the message box will pop out once user log in the system. but I dunno how write the code to link the pending leave data in the table with the pop put message?Anyone can


open a message box if a query is null during an autoexec macro
I have a query that runs using an AutoExec macro when the database opens. What I want is for a message box to open instead of the query results window, telling me if the query produced any records. I can do this easily enough through a command button on a form, but can't figure out how to do it through an autoexec macro at startup.


Message Box
I have a Access progarmm with has 7 large marcos in it that run different queries , output files.Before running macro, I pul Excel srpreadsheet into a specially desing directory and then I click on macro .I would like to set up on each macro message warning as a remainder to new user such as "Please don't forget to put the Excel spreadsheet into that directory" so that new user when he clicks on macro this messgae pop up and he would be able to cancel the macro if the Excel spreadsheet has not been uploaded in there .
Trying have to do this , but so far got no succes


Macro for append query
How do I go about creating a macro that will run an append query when the database is logged into or when a form is loaded? (If there is a better more efficient way to do this besides a macro please let me know i.e. SQL


unable to append... key violation... message box
Is there anyway that I can suppress / disable query warning messages about not being able to append all data asking if you want to continue even if ## records were lost to key violations.

I want the query to execute and add the records it can regardless and I don't want the user responding to message boxes


Pop Up forms
I am using access 2010:

I have two tables:

One table prices by country
Two table enter shipping information

I want the country box on dirty to show a pop up message box saying the country is available from Table One or the country is not available?

When I put an IIf x = x statement the objects are not related so it doesnt work?

If I make a query then every record shows up on a datasheet I only want the one I am working on to display (preferably in a pop up box


skip "run query anyway" message
I have some append-query that I want to run in one macro. But after running each macro Access comes up with this error message saying that it didn't add a certain amount of records due to key violations. Then you have to click yes to execute anyway. My question is if I can add something in VBA to the macrocode to skip this errormessage and just always choose yes


Append query key violations
I am getting the dreaded "key violations" message on an Append query - every single record on the input table is rejected.

I have checked the indexes on the target table and they are OK.

Its amazing how many hits you get surfing but I haven't found one that works for me.

This is so simple - no VBA, no macro --- just a simple append query of a few fields on the input data to a large master table


Cancel Button on message box
I have a very simple macro added to a control button which opens a parameter query.

The message box that opens asks the user to input some detail, all works well if the user inputs the detail and then clicks"OK". However if they dont enter any detail and press cancel I get the action failed message box with the error number 2950.

If I then click stop all macros I can exit the error message.

is there a way I can amend the macr so that if the user clicks cancel the message box closes without running the macro


Append query
I am using access 2007 and I am trying to update data in a table. I am using a form to get value from user and then use appen query to add it to a table. I have insterted a condtion that if some of mandatory filed are blank it should give a message to user. However I note that records are geeting added even if some fileds are not filled and I dont get the message. In fact when I click(update) it again, then only message comes out.
Here is the code I am using.

If (Name = "" Or TrainingName = "" Or TrainingType = "" ) = True Then
MsgBox "Please enter values in highlighted blank fileds", vbOKOnly, Alert
Else
MsgBox "Training Record has been added to database"

DoCmd.RunMacro "Mac_Add_To_Table" 'this macro run append query


Append Query
I am using access 2007 and I am trying to update data in a table. I am using a form to get value from user and then use appen query to add it to a table. I have insterted a condtion that if some of mandatory filed are blank it should give a message to user. However I note that records are geeting added even if some fileds are not filled and I dont get the message. In fact when I click(update) it again, then only message comes out.
Here is the code I am using.

If (Name = "" Or TrainingName = "" Or TrainingType = "" ) = True Then
MsgBox "Please enter values in highlighted blank fileds", vbOKOnly, Alert
Else
MsgBox "Training Record has been added to database"

DoCmd.RunMacro "Mac_Add_To_Table" 'this macro run append query