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

help with user-friendly form

2
I'm trying to create a "user-friendly" data entry form for inventory/despatch purpose in MSAccess2003.
The items are classified by
Brand (1)-----(M)Models(1)------(M)Colors(1)------(M)Sizes(1)-----(M)Shops-----Pieces fields.
What is required: set up a (sub)form, where for a given Model's (first) color is being entered, what triggers a subform to enter the different size-sortiment for that color indicating the number of despatched pieces for the different shops like in the following matrix:
Expand|Select|Wrap|Line Numbers
  1. size  Shop1  Shop2
  2.  35     1
  3.  36     1      2
  4.  37     3      1
  5.  38            1
  6.  41     2      1
  7.  43     3      2
  8. etc.
and save those records with the given colorID.
And just to add some hot pepper into the open wound, the boss asks for the possibility to bring up those tables for the previous colors (if there exists) to help in deciding the near-equal distribution (at least by sizes).

Any help is greatly appriciated in advance!
Oct 17 '08 #1
2 1148
Stewart Ross
2,545 Expert Mod 2GB
Hi there mgrill. Aside from references to the 'boss' in your post, this looks like some form of assignment question to me - and if it is, we really cannot do your assignment for you.

We are happy to help you with specific questions where you have tried something and got a bit stuck - but to ask us how to design a user-friendly form from scratch is like asking us how to design the best database in the world ever, or any other broad and unanswerable question.

If you could be more specific we will do our best to help you, but not, I'm sorry to say, with your question as you have posted it. Please read the posting guidelines at the head of the forum, and (if this really is an assignment question) our FAQs on posting homework questions.

Thank you

MODERATOR
Oct 17 '08 #2
mgrill
2
Hi there mgrill. Aside from references to the 'boss' in your post, this looks like some form of assignment question to me - and if it is, we really cannot do your assignment for you.

We are happy to help you with specific questions where you have tried something and got a bit stuck - but to ask us how to design a user-friendly form from scratch is like asking us how to design the best database in the world ever, or any other broad and unanswerable question.

If you could be more specific we will do our best to help you, but not, I'm sorry to say, with your question as you have posted it. Please read the posting guidelines at the head of the forum, and (if this really is an assignment question) our FAQs on posting homework questions.

Thank you

MODERATOR
Thank you Stewart, I understood your point. Sorry,I (probably by mistake) tried to describe the global picture instead of asking for specific help. The thing is, that I tried to use an AfterInsert event with an SQL to insert a 14 rows bay 3 colums matrix for entering the size-sortiment data and requery the subform to exlude the not filled (zero) records in that matrix, where I reached the dead-end.
Thus, I came the conclusion, that my approach easily might be wrong and turned to your forum the get some light on the global problem of mine.
Anyway, many thanks to you guys, it's great opportunity to have such a powerfull resource by hand when you are in trouble at the early stages of the Access Academy, and I do promise to be more specific next time.

Best regards,
mgrill
Oct 17 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Patrick Lim | last post by:
Here is the problem: I have written a non-modal frame class in Java for displaying help text when a user is using an application. It works as desired in that if the user selects "help" again,...
0
by: John Salerno | last post by:
I know this is a C# group, but I'm getting a little desperate. It's been several weeks since I posted my question to the WD forums and no one has responded. All I want to know is how to get...
6
by: varkey.mathew | last post by:
Dear all, Bear with me, a poor newbie(atleast in AD).. I have to authenticate a user ID and password for a user as a valid Active Directory user or not. I have created the IsAuthenticated...
28
by: Siv | last post by:
Hi, If I run the following: strSQL = "Select * FROM Clients;" da = New OleDb.OleDbDataAdapter(strSQL, Conn) 'Create data adapter cb = New OleDb.OleDbCommandBuilder(da) ...
4
by: Bob Homes | last post by:
In VB6, I used a system, which I loved, whereby I assigned a "helpId" to each menu item; that way, you could rest the cursor on the item (without actually running it) and then press F1 to get...
2
by: Prophet | last post by:
Can someone help me troubleshoot this IISSTATE log ? I have tried to make sense out of it but with no luck I am currently running IIS5 on a Win 2k box. Hosting 3 web sites and runnning asp...
11
by: Matthew | last post by:
Ok let me try to explain this as good as I can. I am creating this application where it contains a userlogin class. The user logs in before entering the main apploication. I want to do audit trails...
15
by: Jay | last post by:
I have a multi threaded VB.NET application (4 threads) that I use to send text messages to many, many employees via system.timer at a 5 second interval. Basically, I look in a SQL table (queue) to...
2
by: Zerofury | last post by:
Okay this is what i'm attempting to do. I have to modify this program that i wrote so that it allows the user to list items by alpha as an option on the main menu. Here is my problem. If i sort the...
5
by: tabani | last post by:
I wrote the program and its not giving me correct answer can any one help me with that please and specify my mistake please it will be highly appreciable... The error arrives from option 'a' it asks...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.