473,320 Members | 1,854 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,320 software developers and data experts.

access forms

Hi there,
I'm trying to create a form from a database, don't have a lot of experience and am somewhat muddling my way through...
It is for a hospital, so we have specific 'Services' with 'Wards' assigned to each. We are trying to capture their orders for items, under a 'Type' and then the 'Item'.

If possible, I would like to be able to choose a Service (ie Orthopaedics) and then have a list of Wards (ie R3, S3 and Q3). Alternatively if they chose Critical Care - Burns, Emerg and ICU would be available as a Ward.

Next I would like to be able to have the Type options - Instrument, Tray, Linen & Other, and then each of the available items be populated.

I currently have tables with these all connected, I'm just trying to figure out if it is possible to create a form in this way? Happy for it to be subforms with a table?

Thank you!
Nov 11 '11 #1
2 1184
sierra7
446 Expert 256MB
Hi Jo,
It's cricial that you get your data analysis right before you start designing forms. You seem to have the entities 'Services' and 'Wards', so as a first shot I would expect your database to contain tblServices and a tblWards.

My problem is that when I read your post, from the first example I can understand that a Ward can be referred to by a Ward Number (ie R3, S3 and Q3) but the second example they are referred to by description "Burns, Emerg and ICU" , which I could easliy mis-understand as being 'Services' ?.

Are Burns treated in more than one Ward?

Until I get that straight in my head I find it difficult to move on to the next stage. It would seem to me that each ward may be associated with multiple types of 'Instrument, Tray, Linen', or are you just interested in a count of each?

What is the purpose of your database? Is it is for Inventory purposes? If you are new to database design you should perhaps download and study one of the Template database that are availble for Access;- perhaps the Asset Tracking database.
S7
Nov 11 '11 #2
sierra7
446 Expert 256MB
Jo
I have just re-read your post and I wrongly interpreted your requirements. You are trying to classify orders rather than listing inventory. It seems to me that you are going to have a table tblOrderDetails that may have fields like (OrderID, ItemID (or ItemDescrpition), ItemQuantity, ItemCost, ItemType, ItemService, ItemWard)

I can see that you are trying to make your ward-list be prefilterd depending upon the Service selected. Using your values then tblServices would be
ServiceID Service
1.... . . Orthopaedics
2.... . . Critical Care

Your tblWard would then be like;
WardID SID WardName
1 . . . . . 1 ... R3
2 . . . . . 1 ... S3
3 . . . . . 1 ... Q3
4 . . . . . 2 ... Burns
5 . . . . . 2 ... Emergency
6 . . . . . 2 ... ICU

The information would be available for each Order from a combo box. The query for cmbWard would have to be filtered by the After_Update event of cmbService.

Search for 'cascade filtering' in this site to learn more about this.

If you are new to this I still recommend looking at the template databases that can be downloaded for access.Try
http://office.microsoft.com/en-gb/te...001018459.aspx
There are other templates here that might better fit you requirement
S7
Nov 11 '11 #3

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

Similar topics

1
by: mamatha | last post by:
Hi I have Access forms and i want to add our company's logo to that form.How can i add,if any one knows let me know.
2
by: Kim Skytte | last post by:
HI! I have a few questions about access . 1) Does anyone know if it is possible to apply skins to Access forms ?? 2) Is is possible to hide the main access windows, and just show the forms.
7
by: James Fortune | last post by:
In response to different users or situations (data context) I transform the appearance and characteristics of Access Forms through code. This seems to fit in with the idea of polymorphism. Do...
0
by: vlpkumar | last post by:
I saw a lot of resources for creating and linking to a PDF document from within Access all over the internet. I would like to know if it is possible to accomplish the inverse task of hyperlinking...
7
by: dtecmeister | last post by:
Looking to see how many people could use this kind of tool. I've got several large databases I've developed in Access with MySQL as the back-end. I've started using Linux instead of windows and...
3
by: mumbaimacro | last post by:
hi i am a newbie to access programming,, i need help to 1. view PDF inside Ms-access forms whether the PDF Location from the Folder or the Path in table. 2. view ms- photoeditor...
19
by: jalmar | last post by:
My question is related to Access forms. I have set up an Access form using 4 different tables~I am pulling 2 different numbers and the name of Trusts out of one table, I am pulling custodian name...
2
by: =?Utf-8?B?UGV0ZQ==?= | last post by:
Happy New Year everyone. Quick question: does anyone know a good tool for converting Access forms into VB.Net form? Pete
2
by: Luting | last post by:
Hi, Is it possible to update oracle via Access forms? I am thinking maybe I could make a link table connnected with oracle database. And the form could be based on the link table. Does this...
2
by: sarah2855 | last post by:
How can I disable auto save function in access forms?Currently, If accidentally something is changed in forms, it gets saved automatically without being prompted. Thanks in advance
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...
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...
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)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
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: 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.