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

Creating a "shopping list"

Hi, ive got this problem with one of my databeses.

My question is, how do i create a sort of a shopping list on access?

Im doing a ficitional pizza shop, and what i want to do is to have an order form. In this form i would like to be able to select an item from the combo box and then after an item is selected another combo box appears, and the items selected in those combo boxes appear on a report.

Thats what I mean by shopping list haha
if you could help me that would be awesome! :D

Belfallas
Jul 20 '07 #1
4 4873
Twanne
65
Could you be more specific??

What i think now is that you have a form with 2 fields to choose from. When you choose from the first field the second should apear.

(from your form)
Expand|Select|Wrap|Line Numbers
  1. Private Sub TypeChoise_change()
  2.     typechoise2.setvisible
  3. End Sub
I don't think the syntax is correct but this is a way to use them.

To fill your report with the values of the choises, can be done in verry much ways.
I did this like this:
(from your report)
yourfield.Caption = yourform.typechoise
Jul 20 '07 #2
missinglinq
3,532 Expert 2GB
The technique you're speaking of is referred to as Cascading Comboboxes. Here's the link to a tutorial on the subject. Give it a tyr and let us know if yu need any help.

http://www.thescripts.com/forum/thread605958.html

Welcome to TheScripts!

Linq ;0)>
Jul 20 '07 #3
missinglinq
3,532 Expert 2GB
And Twanne, you're correct! The syntax for making a control visible isn't

typechoise2.setvisible

in VBA but rather

typechoise2.Visible = True

A Welcome to TheScripts to you, also!

Linq ;0)>
Jul 20 '07 #4
Twanne
65
thx, setvisible is from java I think

I'm even not a real programmer I'm a networkdeveloper who needs to build a stupid database in access. Why couldn't they give me something else, I said with sarcasm dripping.

Greetz
Jul 20 '07 #5

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

Similar topics

3
by: Robert | last post by:
Hello all.. Im a beginner in php and looking to do something similar to a shopping cart system. I want users to be able to view profiles on people and be able to add them to the "shopping cart"...
11
by: Nicolas Girard | last post by:
Hi, Forgive me if the answer is trivial, but could you tell me how to achieve the following: {k1:,k2:v3,...} --> ,,,...] The subtle point (at least to me) is to "flatten" values that are...
17
by: Istvan Albert | last post by:
Paul McGuire wrote: > Please reconsider the "def f() :" construct. Instead of > invoking a special punctuation character, it uses context and placement, > with familiar old 's, to infuse the...
0
by: Jan | last post by:
I store sql-commands in a database table. In the first step I get the sql command out of the database table with embedded sql. In the second step I try to execute the command, which i got from the...
3
by: Alessandro Brollo | last post by:
Far from a professional programmer, I'm simply a newbie Python user. Two basic questions: 1. I don't want to post banal questions about Python to main Python list. Does a "banal Python questions...
2
by: thomasfj | last post by:
Hi, Accroding to MS documentation the use of union and list elements in XSD simpleType (valid according to W3C standards) is valid used as an dataset schema...but it's not!! When loading the...
3
by: janzon | last post by:
Hi! Sorry for the bad subject line... Here's what I mean. Suppose we deal with C++ standard integers lists (the type is indifferent). We have a function f, declared as list<intf(int); Now...
4
by: zacks | last post by:
Most applications whose purpose is to work with various types of files implement a "Most Recent Files" list, where the last, say, four files accessed by the application can quickly be re-opened by...
0
by: howkoss | last post by:
Hi, I've been very frustrated for 2 days trying to make this work. I started with a built-in template "Projects" that came with Access 2007. On the "Employee List" I can click on any cell and bring...
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
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.