473,395 Members | 1,688 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Cancel parameter input and load switchboard

Hello All,

I'm quite a novice but I'm trying to get a database together at work. I have an effective database but I'm trying to tie up all the loose ends to make it fool proof!

I have a select query attachted to a form. The query asks the user to enter some data in order to retrieve the results. The form is then attachted to my switchboard. A button on my switchboard closes the switchboard and opens the form via a macro.

The thing is if you press "cancel" to the option to enter criteria it closes the form. How do I get it to re open the switch the board when the user selects "Cancel". I suspect I need to go back to the query and put something in here but I'm not sure what.

Any Advice much appreciated!

Thanks

Laura
Jan 6 '12 #1
2 1398
ADezii
8,834 Expert 8TB
Laura, are you referring to a Form whose Record Source is a Parameterized Query? If this is the case, you basically cannot take any action based on the User cancelling the Parameter Prompt. You would then need an alternative Method of requesting the Parameter from the User, so you can control his/her Response.
Jan 7 '12 #2
NeoPa
32,556 Expert Mod 16PB
Never close the Switchboard form. Simply hide it, but only when the other form has opened successfully.
Jan 9 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: ryanmhuc | last post by:
I have a function which needs to cancel the input into a text field on a form. I cancel the event in IE fine and the text does not get entered. But for firefox (1.0) I cancel the event and the text...
2
by: gritter55 | last post by:
I have a parameter query in Access 97 that working for 99% of my users. But for 2 of them, when they run it, it skips over the input box (they never see it) and simply returns an empty set. I...
1
by: AP | last post by:
Hi, I'm trying to use c# to pop up a dialog box when a user attempts to close word to prompt them if they want to exit or cancel (obviously other stuff needs to happen based on their selection...
1
by: CycloLink | last post by:
I have just downloaded some code for a class that I am in. I know that the code works and I have no problems building the code. However I also know that the code requires some input parameters....
3
by: Mvk | last post by:
Hi; I have a simple aspx form. I have put a textbox and 2 buttons on it. The textbox is linked to a requiredfieldvalidator. Click on button 1 (= ok button) = Store value in textbox in...
1
by: ad | last post by:
I am use a RequiredFieldValidator to valid a Text box, and there are two Buttons on the forms, one for OK and one for Cancel, both are Asp.Net controls. When a user press Cancel to cancel the...
4
by: kjworm | last post by:
Hello everyone. I have a parameter query that I would like to retain the parameter value for future use. What I would like to do is have the user perform the query, select the distinct result that...
1
by: TonyJH | last post by:
Hello, I have a database in Access2003. I have set up several queries that use the parameter entry . Each query produces different outputs from various tables that go into a report. Sometimes, a...
7
by: John Gault | last post by:
I experimented with a snippet of JavaScript that will display a "Please Wait" message and graphic while the results of a cgi script is running (the script grabs a bunch of data and formats it in a...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.