How To Disable Action Query Popup Messages

Aug 18, 2006

I'm told (via the non-helpful help system packaged with MsAccess) that the way to 'turn off' the helpful confirmation message related to an action query is under tools>Options>Edit/Find tab, and then uncheck the appropriate boxes.

I've done this. In fact, right now I have all three boxes unchecked which relate to confirmation messages (record changes, document changes, and action queries) - and I'm still having that same popup message every time I run the query, or have a report pull the query for me.

this wouldn't be more than just a hassle, except that one of the end users for this system isn't the most computer-savvy person in the whole world. In fact, I desperately need to "steve-proof" this system! I have this nightmare of being woken up at midnight because of this little glitch. any ideas how to disable that popup confirmation message for good??

View Replies


Annoying Popup Messages

Jun 6, 2007

I have no idea wheather this is supposed to go in Queries or Forms, so feel free to move this to either.

Here's my problem:

I made a query that looks at three text boxes on a form. I'm not sure how to set up the buttons correctly so I just bluffed it (like always :) ). Every time I run the query it keeps wanting me to re-enter the data that it was supposed to look at anyway! If you need more info, just ask. Thanks.


P.S.: I'm really new at this. I just learned about Access a week ago.

P.P.S.: I use Access 2000

View 14 Replies View Related

Command Button To Perform Popup Action

Aug 29, 2005


I am having trouble making a command button do what I want. I have a subform within my form, but I only want it to appear when I click the button. I tried using the wizard but there is no option to open subform, only open form. Any thoughts would be greatly appreciated!

View 1 Replies View Related

Disable System Error Messages

Mar 1, 2006

Is there a way to disable the automatic error messages that occur when a user:
1. enters a letter in a number field
2. enters a date in the wrong format (should be MM/DD/YY and they enter MM//DD/YY, etc.)
3. clicks on a button that will open a hyperlink (Currently a message pops up to make sure the user wants to follow the link, by selecting "Yes" the hyperlink opens.)

I would like to add in my own error messages for the above errors but I don't know how to disable the system generated error messages.


View 1 Replies View Related

Reports :: Open Report Action Was Canceled Popup

Nov 10, 2014

I use the following code in the On No Data event of a report:

Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data exists for the date range entered.", vbInformation, "No Data Alert"
Cancel = True
End Sub

This works fine to cancel the opening of the report however Ms Access annoyingly then pop-ups another alert that reads as follows:

"The OpenReport action was cancelled". There is no error number.

I've tried putting in a DoCmd.Close after Cancel = True however this doesn't do the job.

Any way to prevent the Ms Access pop-up from appearing?

View 4 Replies View Related

DatePicker - Disable Any Past Dates On Calendar Popup

Apr 4, 2012

Is there a way to ONLY allow users to select a date starting today or in the future using the DatePicker? I want to disable any past dates on the calendar popup.

View 2 Replies View Related

Forms :: Change Access Default Error Messages With Custom Messages?

Apr 29, 2015

how to change Access default error messages with custom messages? Like, if I enter some data in a sub form where the parent form is empty new record, default error message says that 'You must enter a value in the 'column name' field'.

I want to disable this default message and display my own error message. Now I know MessageBox and MsgBox fuctions to display custom messages, but how to disable the default message.

View 6 Replies View Related

Default Access Messages On Query Run

Nov 18, 2007

Hi there,

I have an access database in which I am updating a table from a form using visual basic for access. I have got the update to work, however before the application appends the table, it asks a question "You are about to append a row" then an option for "yes or no"

I have a custom message that appears after the appending, but I do not want the message in bold above to appear at all. Does anyone know how I can suppress that message?


View 4 Replies View Related

Remove Append Query Messages

Dec 22, 2006

Hello friends,

I have slitted my database and given each user a copy of the front end so tha I can work on the master. I have notice that each time I sent them an updated copy of the new file once they replace the old one in their C drive, when they run a push button which makes run certain append queries, I have noticed that the message comes up although I have removed it from the Options settings. I was wandering if there was a way I can exclude this via code. THank you.

View 1 Replies View Related

How To Stop Append Query Event Messages ?

Apr 25, 2005

Hi everyone, I'm nearly done finishing a database for a legal firm and one of the small issues I'm having with this project is that, I have a button that creates records in other tables once a record is created in a primary table.

I have a table called tbl_login, it has a field called job_number (which is an autonumber), and when all the info is entered in the form associated with tbl_login I want a button to give the user the ability to create a record in tbl_billing with the value of job_number, now this is a easy append query, works great, but the problem is, when the button is pressed there is an event message, "You are about to update an table....." this is the natural warning even message that access gives before a change is made, my questions is.

To please me end users, how do I get that event message to stop popping up. So they just hit the button, it appends, no warning.

I'm open to suggestions,

View 4 Replies View Related

Action Query Question??

Sep 21, 2004

Can this be done??

I want to open a report, run an action query to create a table I want to use for the current report?? If It can how would I do it??


View 1 Replies View Related

Queries :: Pop Up Messages When Running Update Query / Macro

Jan 1, 2015

I have 3 different "buttons" on my form that run individual update queries. I know these update queries are running correctly. Decided to make a macro that will allow me to run all these queries by clicking one macro button.

My question is: Is there some way to stop the pop up msg that advises I am about to run an update query and the next pop up msg that informs me of how many rows I am going to update?

These pop up boxes are starting to drive me crazy when I run the macro.

View 5 Replies View Related

Action Query - Deleting Records

Nov 3, 2006

Hi friends,

I am trying to append records from sales table to sales archive table if salesdate# is <#01/05/2006
It works fine if the sales archive table is blank else it give me an error null conversion failure.

how do i fix this?


View 5 Replies View Related

Action Query Warning Trapping

Nov 7, 2006

Hi there,

I like having the action query warning appear with what I am doing - "You are about to update xxx rows". The problem that I am having is that when my RunSQL statement in the code executes and selects no to the warning, I get the error -

Run-time Error '2501'
The RunSQL action was canceled.

How can I trap the no selection so that this vba error does not appear?

View 1 Replies View Related

Delete Action Query Is Not Working.

Oct 29, 2004

This is a copy of the SQL statement used to update records from the tblContentImport Table to the tblContent Table.

UPDATE tblContent INNER JOIN tblConentImport ON (tblContent.Code = tblConentImport.Code) AND (tblContent.Type = tblConentImport.Type) AND (tblContent.Title = tblConentImport.Title) AND (tblContent.LoginName = tblConentImport.LoginName) SET tblContent.[Date Assigned] = [tblconentimport].[Date Assigned], tblContent.[Date Started] = [tblconentimport].[Date Started], tblContent.[Last Accessed] = [tblconentimport].[Last Accessed], tblContent.[Date Completed] = [tblconentimport].[Date Completed], tblContent.[Time Spent (min)] = [tblconentimport].[Time Spent (min)], tblContent.Score = [tblconentimport].[Score], tblContent.Result = [tblconentimport].[Result]
WHERE (((tblContent.LoginName)=[tblconentimport].[Loginname]) AND ((tblContent.Title)=[tblconentimport].[Title]) AND ((tblContent.Type)=[tblconentimport].[Type]) AND ((tblContent.Code)=[tblconentimport].[Code]));

Now I want to Delete these same records from the ContentImport Table. I change this statement to start with the word DELETE and Access want me to identify which table to delete the records from. What is wrong with my statement. Please help?

View 2 Replies View Related

Make-Table Action Query Column Data

Jan 30, 2006

I use a Make-Table Action query to import data from a linked table into my database. The linked table is on a network server that is automatically updated.

One column of the linked table is named "QTY/PARTIAL" and approximately 10% of the 500 records have a "P" after a number i.e. 1000 P. I would like to separate the number and the P into separate columns in the new table to faciliate being able to compute the total number "QTY".


View 12 Replies View Related

Use Query Results OnLoad Of Form To Conduct An Action

Jan 2, 2008

Alright. I've tried searching, but to be honest, I'm not even sure what to search for.

I want to create some VBA that onLoad of the opening form of the database, it will take info from a query that looks for data entered for a student. It will be looking to see if there is data in two date fields. If it finds data in both fields, then I want to make a change to the EnrollmentID row of another table to changed the graduated column from No to Yes.

To expand on that, I'll want to check each ClassID row and if all of the associated students of that class have the column Graduated checked as yes, it will place the date in the date column for that particular class.

This is essentially my way of auto-archiving data as the combo box selections on my forms don't allow for class data to be shown if there is a Closed Date entered for the class and you won't be able to enter more test results for a student if the Graduated Column is checked in the Enrollment table (associates memberID, ClassID, CourseID into a single table)

Any insight on how to do this would be greatly apprecaited.

View 6 Replies View Related

General :: Creating Invoice Button - Action Query Cannot Be Used As Row Source

Nov 29, 2013

I've created a simple database, with tables, forms etc but I've got stuck when I've tried to insert a 'Button' onto the HOME page which when pressed will display an invoice and give you the option of emailing to client or printing.

I think I've gotten messed up in my relationships or the macros which I've copied from another access template.

on the home screen, I click 'new quote' then 'view quote' when the window pops up and then when it tries to generate the invoice I get the error

'an action query cannot be used as a row source'.

I've put a copy of the database in my dropbox...

View 8 Replies View Related

Modal Popup Query

Jun 8, 2006

Is it possible to make a query Pop-up? All of my forms are set so the Database background is hidden and they popup. I haven't been able to figure a way to do this with a query. Any help or suggestions would be great :)

View 6 Replies View Related

Need To Expand Popup Query List

Jul 27, 2006

On my main screen I have a button that I press and it pulls up a
pop up the box you type in one item and hit ok then
the query goes and gets the results.

My quesion:
how do it make it so when I click the button the pop up box
has lets say four areas where I can enter different items and
then it goes and gets all four...or three or whatever I need ?


View 1 Replies View Related

MS Access Query Popup Entry Box Help

Dec 29, 2005


I'm trying to implement a new pop up on one of my queries.

When the user runs the query a pop up will appear and he will enter a currency number (19.95) and it will display all currency (<) less than 19.95.

I use this wild card pop up currently and have tried to modify it, but can't seem to get to do what I need.

Code:Like [Enter Min-Amount] & "*"

Thanks for your help,


View 3 Replies View Related

Query Will Not Show Values In The Popup Form

Nov 12, 2005

I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running close to the 255 field max limitation.
So I have created a new table called Labor_Primary with all the fields that I need and took them out of the PrimaryBid_Master table freeing up about 50 fields.

The query I made combines 2 tables: table1=PrimaryBid_Master table2=Labor_Primary, they are linked by a common field called invoice#.
But now when I’m in the PrimaryBid_Master form and click the command button to go to the popup form Labor non of the values that were populating the popup form from the primaryBid_Master form work, they were working fine the only thing I changed was the popup forms record source to the new query I built.
Here is a print screen of the new query I built using 2 tables, and I also show the old query that works fine using 1 table.

Maybe you can see some thing I did wrong; do I need some type of filter to fetch the fields? When I open the new query there is no data/values in it.

Thanks--I appreciate any help.

View 1 Replies View Related

Disable Query Prompt

Jan 6, 2007

I have a database called Tables.mdb with a Make Table Query called Qmak_Tables that I want to run nightly.

I have set up a Scheduled Task to run Tables.mdb every night. I have created a Form that loads on start-up. I have created a Macro that runs the Make Table query when the form loads. I have also de-selected the confirm record changes/document deletions/action selections in Tools > Options > Edit/Find menu so the query won’t be stopped by a prompt that needs manual input. Here’s the catch:

After the query runs, it displays the prompt, “The existing table will be deleted. Do you want to continue?” How do I disable this prompt so my task can continue to run?

View 3 Replies View Related

Disable Datasheet From Poping Up After Query Execution

Sep 24, 2007

I am trying to take input for my reports based on a query result dynamically for which i dont want to display the Datasheet after the execution of Query ,inturn i am displaying results in Report. Any help on this would be appreciated.

View 14 Replies View Related

Queries :: Enable Or Disable Criteria In A Query Based On Value Of Textbox?

Apr 20, 2015

Is there a way in access, through vba or any other means, which would allow me to either enable or disable criteria in a query based on the value of textbox??

Like i have a query that displays bookings customer has made between two dates, so i made a query and in the starting and ending date fields i get the value from form. In case if the use does not enter ending date, i would like to run the query with starting date only that displays booking made after the starting date.

Currently the starting date criteria is set to a textbox of form, and so is ending date. So if customer selects 1st April 2015 as starting date and 30th April 2015 as ending date the query should display the bookings between 1st and 30th of April. And if the user enters only 1st April in starting date it should display bookings starting from 1st April onward.

View 3 Replies View Related

Action Query To Make A Field = Another Field

Oct 19, 2006

I have two fields the have differing dates in them. I need an action query to make the date in one field the same as in the other. I have thousands of records to do this to. Is there a way via an action query (update?) to do this or does it have to be an SQL statement query?

View 2 Replies View Related

Copyrights 2005-15, All rights reserved