Hi Everyone,
I have a design issue here (go figure) on a form and kind of need some opinions on how to do this. I have my ideas but need a 2nd, 3rd, 4th.......opini ons.
1st I will have a combo box with Formulas for Chemicals our company makes. I'd like to be able to have only the next formula in line of the schedule to be the only one to be selected but the others grayed out. Once the next selection is made in this combo box it will populate additional fields in this table
2nd once that is selected there will be another table that will be populated with combo boxes from the 1st combo box. I was planning on using cascading combo boxes for this. In this table the 2 combo boxes will be [Stage] and [Product Code]. Each stage has a multiple products for that stage. So this is looking like cascading boxes on top of each other (unless someone can recommend anything else).
Ok once all this process is complete we have to select the next product in line and have to save all the records from the previous formula which is the big question I have. We have to be able to use this as a history to compare with others that are made for trouble shooting issues. This part is really racking my brain.
I'm running Access 2007 on Windows Vista.
Your input is very much appreciated!
5 1413 MMcCarthy 14,534
Recognized Expert Moderator MVP
I'm sorry but I don't really understand the question you are asking. I know you have given a lot of information but I can't picture the form as you describe it.
Try forgetting about the layout of the form and just describe the logic of what you are trying to do.
Mary
Mary,
Sorry, this is a bit difficult to explain for me. I work in a chemical plant where everything in terms of technology are done backwards. I'm trying to keep a similar layout of our current form for ease of use for our employees.
OK let me try this again.
I have a combo box [PRODUCT CODE] that needs to have only one item selectable in it, based on a order of scheduled items.
Once the item in the 1st combo box is selected it needs to populate another combo box [STAGE]. The selection in the 2nd combo box will then populate a 3rd [code].
OK, now for the final issue. After the recording of all the information there will be a checkbox that will make the next item in line selectable in the 1st combo box [PRODUCT CODE]. Once the next item is selected it needs to save all the records from the previous item while creating a new set of records.
Hope that helps
MMcCarthy 14,534
Recognized Expert Moderator MVP
Mary,
Sorry, this is a bit difficult to explain for me. I work in a chemical plant where everything in terms of technology are done backwards. I'm trying to keep a similar layout of our current form for ease of use for our employees.
OK let me try this again.
I have a combo box [PRODUCT CODE] that needs to have only one item selectable in it, based on a order of scheduled items.
Once the item in the 1st combo box is selected it needs to populate another combo box [STAGE]. The selection in the 2nd combo box will then populate a 3rd [code].
This part is easy
Have a look at this tutorial
Cascading Combo boxes
OK, now for the final issue. After the recording of all the information there will be a checkbox that will make the next item in line selectable in the 1st combo box [PRODUCT CODE]. Once the next item is selected it needs to save all the records from the previous item while creating a new set of records.
You can't do this. You can't change the selected item and still retrieve the previously selected item unless you've recorded the value somewhere.
You say save all the records from the previous item but you don't explain what these records are or where they are being saved.
Mary,
Each selection in the combo box [PRODUCT CODE] will be for a set of records for each proccess that we do. Once the process is complete the records will be used for reference. I guess i'll have to just make a new table for each item in the [PRODUCT CODE] combo box.
I appreciate your efforts to help me with this. I was already looking at the tutorial Rabbit has and I thought I might have found a error in the tutorial unless I'm that new that I don't understand it. Where he references the OnChange Event is what is throwing me. The code indicates AfterUpdate unless I'm just not understanding it.
Curt
MMcCarthy 14,534
Recognized Expert Moderator MVP
Mary,
Each selection in the combo box [PRODUCT CODE] will be for a set of records for each proccess that we do. Once the process is complete the records will be used for reference. I guess i'll have to just make a new table for each item in the [PRODUCT CODE] combo box.
I appreciate your efforts to help me with this. I was already looking at the tutorial Rabbit has and I thought I might have found a error in the tutorial unless I'm that new that I don't understand it. Where he references the OnChange Event is what is throwing me. The code indicates AfterUpdate unless I'm just not understanding it.
Curt
I'll have a look at that. You are right it should be the After Update event.
Have a look at this tutorial for some advice on the way your tables should be structured. Database Normalisation Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Shaiguy |
last post by:
I have a table containing the following fields:
ProjectUpdateID (PrimaryKey)
ProjectID
UpdateDate
I would like to create a Query in Ms Access 2000 which will return me
the most recent 2 records (and also show the above 3 fields)
So suppose the table looks like this:
|
by: R. Yang |
last post by:
Hi,
I've a question regarding saving the data. I noticed some of my
recently-entered data mysteriously disappeared. There was nowhere to
re-locate them. Plus, those data were entered within the same week. My
colleagues and I have been cautiously avoided working on the same table
simutaneously. Any reason why the data got lost?
I appreciate your advice!
Yang
|
by: MLH |
last post by:
Is there an alternative line of code for saving a
record entered on an Access 97 line to this one...
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
???
|
by: TORQUE |
last post by:
Hi,
Im wondering if anyone can help me with a problem.
I have a form with more than 50 unbound fields.
Some of the fields will be blank from time to time.
This seems to be where im having trouble.
I have tried keeping some of the fields bound and when I use the save button
it has been saving as 2 different records. This is unacceptable.
This is what I have, can anyone help me out with this?
|
by: Bob Sanderson |
last post by:
I am trying to create a form for a MySQL database similar to a spreadsheet.
The idea is to display a list of records, with the last line of the list
being an input form. When the user enters data in the form and hits the
submit button, the data is entered and the form is reloaded with the new
data displayed and another input form becomes the last line.
Example ---
Before entering new data
| |
by: Sherry |
last post by:
Is there a way to automatically, or by using say a function key,
call/paste into a current table or query's field the same value entered
for the same field in the immediately preceeding record, when values
for a
given field are often repetitive? I have a record with 7 fields that
will be the same of all the records, only 2 fields (id number & amount)
will differ. I am trying to save the client unnecessary keystrokes.
Thanks,
Sherry
|
by: Gem |
last post by:
Hi
I'm struggling with a query returning too many records.
I have 3 related tables.
tblPatients
tblOperations
tblTargets
Each patient in tblPatients can have more than one operation (one-many)
Each Operation in tblOperations can have many targets (many-many)
|
by: natwong |
last post by:
Hi All,
I'm hoping that someone could help me out since I'm new with Access.
Background:
Database was set up as a simple data entry and reporting tool for Program Initiatives. The data entry page has main form with 9 sections (1 main section and 8 subsections). These subsections are all employed using subforms. These are all joined through the ProgramID. The Report is set up in a similar fashion with main and subreports too.
...
|
by: corey11 |
last post by:
I'm a very low-level developer with limited VB knowledge but nonetheless was able to put together a very user-friendly and extremely helpful Access 97 database for my company some 10 years back. We use the database for inventory, job costing, employee records, timecard recording, nearly everything except the hard core accounting. The database is shared by 20 users over a network. Every 3 or 4 years I archive and purge the data to keep the...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |