Solved

Best way to create a list of items

Posted on 2013-06-12
8
280 Views
Last Modified: 2013-06-13
I hope I can explain this one well.  I am trying to figure out how to best create a list of items for a user to use on a form.  Please see the example screen shot to se what I need.

The list needs to be displayed on a form and the user needs to be able to enter the Prices per the example.

There are two quirks...

1) The list needs to be sorted in an order as defined by the user.
2) The user needs to be able to add an item to the list when needed.
3) The list will need to display all items even if the Price is "$0.00"
4) The user needs to be able to enter the price data for each item.

Has anyone ever created anything like this?  What is the best way to handle this?

I'm looking for advice and any help will be much appreciated.

--Steve
ListExample.jpg
0
Comment
Question by:SteveL13
  • 4
  • 4
8 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 39241124
In a form you won't be able to do the offsetting of text as you have shown unless you get into a more complex design involving subforms.  Edit... sorry - no -even then it would not look like your example.

For the user to control the item sequence they must set the value of a field that would be used to sort the items.

See the attached example...
Database1.mdb
0
 

Author Comment

by:SteveL13
ID: 39241476
I like what you've suggested.  but please see my database attached.  I can't figure out why all the records aren't showing up on frmBudget.
Database2.mdb
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39241501
They are for me.  There are 12 records in your table and they all appear on the form.
0
 

Author Comment

by:SteveL13
ID: 39241566
Strange. I only see 7.  ????
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 77

Expert Comment

by:peter57r
ID: 39241617
this is what I get
Capture11.PNG
0
 

Author Comment

by:SteveL13
ID: 39241819
Here's what I get.  What in the world is going on with this?
What-I-Get.jpg
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39243649
I don't know why that is.
Try making the design view of your form bigger and saving it again.
0
 

Author Comment

by:SteveL13
ID: 39244248
This is strange.  I had a horizontal rule at the bottom of the header and another one at the top of the footer.  When I removed them both it worked.  Thanks for your help.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Search Form with Run Time Error 3075 1 22
MS Access Order Smallest to Biggest Query Help 13 41
Export Query data to excel file 14 33
access 7 21
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now