Even though I have hugely improved my knowledge about Microsoft Access, I am still confused when it comes to making new forms, that is why I decided to ask here, maybe my fellow FISOers can help out (the problem, I think, isn't that hard):
So the basic idea for what I want:
I have one table with 3 columns - PERIOD; CODE; PRICE.
What I want is to make a form where I could:
1) Select a period from a dropdown list based on what periods are in the table
2) After 1), select a code from a dropdown list based on what periods are in the table
3) Now that I have chosen both a period and code (lets say, 2016_01 and 01) it would show a price next to it in another textbox or whatever
4) Just like in 1-3 I would like another period and code underneath which would show value for what I chosen.
5) And the last and main thing - there should be another textbox or whatever, which would show price in second period that I have chosen divided by price in first period (or other way round).
I think it sounds easy, but I have no clue how to make it and it is hard to find it in google as many things I don't need show up.
So the basic idea would be to get an index, which would show how have prices changed in those two periods for particular code.
Of course, if it turns out that this is quite hard to do, then don't bother
Microsoft Access - Forms
- Ralfbergs
- FISO Knight
- Posts: 10075
- Joined: 25 Jul 2011, 09:09
- Location: LVA
- FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
- FPL:
- Ralfbergs
- FISO Knight
- Posts: 10075
- Joined: 25 Jul 2011, 09:09
- Location: LVA
- FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
- FPL:
Re: Microsoft Access - Forms
Soo, nobody knows this then?
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Microsoft Access - Forms
Best to give it a few days. I think there is a small number of Access users here but depends when they visit.
- Rob
- Grumpy Old Man
- Posts: 3638
- Joined: 24 Jul 2009, 10:54
- Location: Poster formerly known as SOBD
- FS Record: WC2010 FISODAS Champion!!
- FPL:
Re: Microsoft Access - Forms
I've been able to do similar in excel but not really used access that much.
Is the following helpful at all? http://www.blueclaw-db.com/comboboxlist ... n_list.htm
Is the following helpful at all? http://www.blueclaw-db.com/comboboxlist ... n_list.htm
- Ralfbergs
- FISO Knight
- Posts: 10075
- Joined: 25 Jul 2011, 09:09
- Location: LVA
- FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
- FPL:
Re: Microsoft Access - Forms
I think this only helps for the dropdown list part but not the calculation part (and it isn't really exactly how I wanted it, at least in the example). Thanks anyway, I guess this is quite complicated, just wanted to make some of my regular work routines a bit more effectiveRob wrote:I've been able to do similar in excel but not really used access that much.
Is the following helpful at all? http://www.blueclaw-db.com/comboboxlist ... n_list.htm
- Rob
- Grumpy Old Man
- Posts: 3638
- Joined: 24 Jul 2009, 10:54
- Location: Poster formerly known as SOBD
- FS Record: WC2010 FISODAS Champion!!
- FPL:
Re: Microsoft Access - Forms
Is it in access due to the amount of data or some other reason?
- Ralfbergs
- FISO Knight
- Posts: 10075
- Joined: 25 Jul 2011, 09:09
- Location: LVA
- FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
- FPL:
Re: Microsoft Access - Forms
Amount of data mainly I think and partly because it just is historically like that. It is planned that we won't use Access in the future, but as our IT department is quite slow with building our own, proper database, it looks like it won't be in near future.Rob wrote:Is it in access due to the amount of data or some other reason?
View Latest: 1 Day View Your posts