Tony
I have a lot to say about your current design. I'm afraid if you keep going with
it as is you will paint yourself into a corner. Starting with the tables. You
are using a "spreadsheet" mentality. You are storing calculations (i.e., total
cost, average cost, etc. Those calculations should be handled by the forms and
reports so they are always accurate. Right now if you change the quantity, the
calculations become meaningless.
Access does not work well that way. It needs tables that are related such as a
product table related to an inventory table. Order table related to an Order
Detail which is related to the product table.
Orders placed would affect the inventory table...
Forms should have bound fields so data entry and editing does not take a bunch
of tricks to get it in the table. You can easily set up a form to search for a
record the way you started out to do. The combo boxes would go in the form
header and would filter the form's RecordSet to find the selected record.
Maybe John Viescas's sample inventory database would help you understand better.
I don't have the link but I'm sure John will read this and post it for you. Or
download the template Northwind. While it is not perfect, it does have sample
tables, forms, etc. to get you started.
Even better, get Crystal's free eBook Access Basics at
http://www.thatlldoit.com/Pages/AccessBasics.aspx
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My Nothing-to-do-with Access blog
<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Tony
Sent: Saturday, December 01, 2012 10:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Changing the source data of a combobox while
maintaining current functionality
Was anyone able to take a look at this?
Thank you!
Tony
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Tony" <GKillah36@...>
wrote:
>
> Hi everyone,
>
> Please see formTicketMod in database PracticeNASDatabase_113012b in Files ->
AssistanceNeeded. To the very right of that form I have text boxes and
comboboxes in place so the user can have that data added to table
tableWarehouseData.
>
> I would like to make a slight change though I'm not sure how to go about it.
How do I make it so that clicking commandAdd still does the same thing it does
currently, but instead of the user selecting a UPC in comboAddUPC, they select a
style, color and size just like combobox cboStyleNo at the very left of the
form?
>
> Thank you very much!
>
> Tony
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar