473,289 Members | 2,108 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,289 software developers and data experts.

Enter New Data In Comboboxes Only

In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models that
are not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not going to the menu items
at the top of the screen. How do I do this??

Thanks for all help!

Kathy
Nov 12 '05 #1
4 1952
On Sun, 21 Dec 2003 04:04:35 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

Set the form's Data Entry property to True.
Since you want to use the forms both ways, I would suggest rather than
making a copy of the form, using a bit of VBA to set this property
dynamically. Use the OpenArgs argument of Docmd.Openform to pass in a
hint as to which mode you want. Then in form_open, check the hint and
set the property accordingly.

-Tom.

In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models that
are not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not going to the menu items
at the top of the screen. How do I do this??

Thanks for all help!

Kathy


Nov 12 '05 #2
Tom,

Thank you for replying!

How does this keep the users from going to the custom menu when the form with
the comboboxes is open?

The problem with the users going to the custom menu and entering a new Make or
Model is that after they enter it, it still does not appear in the drop downs of
the comboboxes. The comboboxes would need to be requeried. That then presents a
problem when Makes or Models are entered via the custom menu when the form with
the comboboxes is not open.

Thanks!

Kathy

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:61********************************@4ax.com...
On Sun, 21 Dec 2003 04:04:35 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

Set the form's Data Entry property to True.
Since you want to use the forms both ways, I would suggest rather than
making a copy of the form, using a bit of VBA to set this property
dynamically. Use the OpenArgs argument of Docmd.Openform to pass in a
hint as to which mode you want. Then in form_open, check the hint and
set the property accordingly.

-Tom.

In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models thatare not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not going to the menu itemsat the top of the screen. How do I do this??

Thanks for all help!

Kathy

Nov 12 '05 #3
Check for the form being loaded, and if it is, requery the relevant comboboxes?
Nov 12 '05 #4
On Sun, 21 Dec 2003 19:24:49 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

You make the form lodal. That way they can't access the menu.
It's one of the arguments in DoCmd.OpenForm.

By the way, I would likely have only 1 form: the parent form to add
makes, and a subform to add models. That way models are automatically
associated with the correct make.

-Tom.

Tom,

Thank you for replying!

How does this keep the users from going to the custom menu when the form with
the comboboxes is open?

The problem with the users going to the custom menu and entering a new Make or
Model is that after they enter it, it still does not appear in the drop downs of
the comboboxes. The comboboxes would need to be requeried. That then presents a
problem when Makes or Models are entered via the custom menu when the form with
the comboboxes is not open.

Thanks!

Kathy

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:61********************************@4ax.com.. .
On Sun, 21 Dec 2003 04:04:35 GMT, "Kathy" <kb*****@earthlink.net>
wrote:

Set the form's Data Entry property to True.
Since you want to use the forms both ways, I would suggest rather than
making a copy of the form, using a bit of VBA to set this property
dynamically. Use the OpenArgs argument of Docmd.Openform to pass in a
hint as to which mode you want. Then in form_open, check the hint and
set the property accordingly.

-Tom.

>In my custom menu one menu item opens a form to add new Makes to TblMakes and
>another menu item opens a form to add new Models to TblModels. I have a form
>that has a combobox for Makes and a combobox for Models. In both comboboxes I
>use the NotInList event and code to allow users to enter Makes and Modelsthat >are not in the database. When the form is open, I want to limit the users to
>entering new Makes and Models in the comboboxes and not going to the menuitems >at the top of the screen. How do I do this??
>
>Thanks for all help!
>
>Kathy
>


Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: David Meier | last post by:
How can data be stored in comboboxes similar to html pulldowns? I know I can access the data of the combobox either by the items text or by its index. However, I would like to have a pulldown...
3
by: Peder Y | last post by:
Just a quickie: I have a ComboBox, and set it so I can write in its text field. Now, as I write and then press enter, nothing happens (except a beep). Do I need to handle a KeyPress event to...
2
by: Jeremy Dillinger | last post by:
I have a program setup to pull data from a database. My database table has things such as (category, Item, price, etc.) In my program I want to have multiple list boxes that will have a pull down...
6
by: chreo | last post by:
Sorry for weird title and sorry for my English (I'm from Poland). This is the problem: I have form with many controls. There are three comboboxes - each should have table STREETS as DataSource....
4
by: Vish | last post by:
Hi, I am having a problem with my form being too slow to load up. I have a 4-5 of comboboxes on the form that load a lot (~30,000 records) into them. So this is causing a lot delay (5-6 seconds)...
0
by: mjsterz | last post by:
I've been working with VB .NET for less than a year and this is the first time I've posted on one of these groups, so let me apologize beforehand if I'm being unclear, not posting my issue...
2
by: Matt | last post by:
Hi all, me again! :) I've now got an issue with combo boxes. Basically, I have a number of items that I want a user to pick from a single list. It's basically along the lines of: Fruit 1: ...
3
by: BASSPU03 | last post by:
I had to present my DB today, but was granted a chance to fix something about it. In order to fix something, I added something...something that is giving me more trouble than it should. I have to...
2
by: Wingot | last post by:
Hey, I have a view to a database that I have created for Client Maintenance. It has a number of fields, but the important ones are Medical Condition, Bill To, and Country. I have a couple of...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.