Paul-
Why not add a "Related Work Order" field? User can select the value from a
combo box when necessary and then use your text field to add comments like
"Deficiency ID 79".
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of paulc8481
Sent: Saturday, July 28, 2012 5:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Problem with cascading combo boxes
John,
Thank you for your response. I now have the program working the way I
need it to. I have a couple of quick questions for you though if you
have the time.
Is there a major difforance in SQL vs MYSQL and should I learn one to
get an understanding of both? I really want to learn query language
well so I can advance in these access programs and also of course I want
them to be done correctly and in a professional manner.
Also
I have a text field that the user will type in and state that they have
placed a work order into the system for a certain task to be done.
Example: Work order HAZ072712-001 or Work order EMZ072112-012 placed
in system for deficiency ID 79. How can I set the search criteria for
either one of these work orders in a query. The user needs to locate
the Deficiency by locating the workorder number so they can close the
Deficiency out. The first 6 numbers represents the date, the next 3
after the hyphen represents the number of the workorder on that date,
The first 3 letters represent the assigned shop and there are 20 shops
with differant letters representing it.
Thanks for your help
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...>
wrote:
>
> Paul-
>
> Rather than set the Row Source in After Update of cboClass, set the
Row Source
> of cboSubClass to:
>
> SELECT tblAll.txtSubClass FROM tblAll WHERE
> (((tblAll.txtClass)=[Forms]![frmCaseAssignmentRegister]![cboClass]));
>
> In the After Update event of cboClass AND the Current event of the
Form, do:
>
> Me.cboSubClass.Requery
>
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
paulc8481
> Sent: Wednesday, July 25, 2012 2:04 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Problem with cascading combo boxes
>
> I am creating a small database for the police at the facility which I
work.
> They wanted a cascading style using combo boxes that displays a
> subclass(cboSubClass)of offences populated after selecting a value
from the main
> combo box called (cboClass). I have succeeded in this task by making
multiple
> tables populated with subclasses and writing a SELECT CASE structure
in VBA to
> populate the combo box(cboSubClass). NOW, There are so many Classes
and
> SubClasses that I think it would be much easier to create ONE table
with Classes
> and SubClasses and use an SQL statement to filter through the
selections. My
> problem is that I have tried to write the code for this but it is not
working.
> I will include the database in the files folder with what code I have
in the
> Record sourse section of the main combo box and the After update
statements that
> I have written. Any help to accomplish this task would be greatly
appreciated.
> The name of the file is: Case Assignment Register TEST
>
> Thankyou
>
> Paul
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar