It is currently 28 Feb 2017, 09:55
View Latest: 1 Day | FISO Injury Search

Microsoft Access - Forms

A forum for discussion on Science and Information Technology matters and queries (including PCs, the Internet, TVs, Mobile Phones, Ipods and other gadgets).
User avatar
Ralfbergs
Dumbledore
Posts: 5034
Joined: 25 Jul 2011, 09:09
Location: LVA
FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
FISO Goals: Score: 209 Position: 6

Microsoft Access - Forms

Postby Ralfbergs » 10 Jan 2017, 14:22

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 :)

User avatar
Ralfbergs
Dumbledore
Posts: 5034
Joined: 25 Jul 2011, 09:09
Location: LVA
FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
FISO Goals: Score: 209 Position: 6

Re: Microsoft Access - Forms

Postby Ralfbergs » 11 Jan 2017, 07:08

Soo, nobody knows this then? :lol:

User avatar
Surprised
FISO Jedi Knight
Posts: 24555
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
FISO Goals: Score: 123 Position: 48

Re: Microsoft Access - Forms

Postby Surprised » 11 Jan 2017, 09:17

Best to give it a few days. I think there is a small number of Access users here but depends when they visit.

User avatar
Rob
Grumpy Old Man
Posts: 3425
Joined: 24 Jul 2009, 10:54
Location: Poster formerly known as SOBD
FS Record: WC2010 FISODAS Champion!!
FISO Goals: Score: 7 Position: 64

Re: Microsoft Access - Forms

Postby Rob » 17 Jan 2017, 09:39

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

User avatar
Ralfbergs
Dumbledore
Posts: 5034
Joined: 25 Jul 2011, 09:09
Location: LVA
FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
FISO Goals: Score: 209 Position: 6

Re: Microsoft Access - Forms

Postby Ralfbergs » 17 Jan 2017, 10:02

Rob 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


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 effective :lol:

User avatar
Rob
Grumpy Old Man
Posts: 3425
Joined: 24 Jul 2009, 10:54
Location: Poster formerly known as SOBD
FS Record: WC2010 FISODAS Champion!!
FISO Goals: Score: 7 Position: 64

Re: Microsoft Access - Forms

Postby Rob » 17 Jan 2017, 11:10

Is it in access due to the amount of data or some other reason?

User avatar
Ralfbergs
Dumbledore
Posts: 5034
Joined: 25 Jul 2011, 09:09
Location: LVA
FS Record: Murfs Premiership Predictions Knockout Cup 13/14 Winner
FISO Goals: Score: 209 Position: 6

Re: Microsoft Access - Forms

Postby Ralfbergs » 17 Jan 2017, 12:48

Rob wrote:Is it in access due to the amount of data or some other reason?


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.


View Latest: 1 Day

Return to “Science, Computers & Technology (e.g. PCs, Web, TVs, Mobiles, Ipods, Gadgets)”

Who is online

Users browsing this forum: No registered users and 2 guests