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
>
Tidak ada komentar:
Posting Komentar