New to Access

[haffy]

SOLVED - Autoupdate textbox from listbox

Hi,

I´m new to MS Access and I am trying to understand the system, and I have stucked myself in a problem that I hope you can help me with.
And on top of that I´m from Sweden, so please have patients with my spelling

The problem:
I have made a listbox with a query that shows "problems", and I want a TextBox or similar to show "Solution" at the problem I have selected in the "Problem"-listbox automaticly.
How do I make this possible?

Edit: I´m using Microsoft Access 2003.

/Haffy

 

[wazz]

hello haffy, welcome to awf.

the question is rather broad, i mean, it's difficult without some more information.
the answer depends on how the tables are set up.

the basic answer is that when the listbox is clicked, update the textbox, or listbox with solutions. so, the textbox or listbox with solutions would be based on a query where the criteria = questionListbox.

query for the questions, and a query for solutions (with criteria = listbox).

hth.

 

[David Eagar]

Re: Autoupdate textbox from listbox

Hi,

I´m new to MS Access and I am trying to understand the system, and I have stucked myself in a problem that I hope you can help me with.
And on top of that I´m from Sweden, so please have patients with my spelling

The problem:
I have made a listbox with a query that shows "problems", and I want a TextBox or similar to show "Solution" at the problem I have selected in the "Problem"-listbox automaticly.
How do I make this possible?

Edit: I´m using Microsoft Access 2003.

/Haffy

The complexity will depend on whether one problem can only have one solution or, where it gets a bit trickier, MANY solutions

 

[haffy]

Thx fellows, I will look in to this. I need to digg into this to understand the answers.. Will probobly reply today.

What I am trying to do is a db for problems and solutions that i can use in my iPhone webbrowser. To use at site, like a personal manual for more complex problems (You know "What you don´t have in the head, you have in the iPhone).

 

[David Eagar]

this might help

 

[haffy]

this might help

Thx! This will probably help me allot !

 

[David Eagar]

Re: Autoupdate textbox from listbox

And on top of that I´m from Sweden, so please have patients with my spelling

anybody from a country that produces cities like Stockholm (my favourite in the world) has no need to apologise

 

[haffy]

Re: Autoupdate textbox from listbox

anybody from a country that produces cities like Stockholm (my favourite in the world) has no need to apologise

Nice !


Filling-in: The message you have entered is too short. Please lengthen your message to at least 10 characters.

 

[haffy]

It works !! Thanks everyone!

But another question now, I want to export this so I can read it in iPhone Safari, and use it as a small database for my phone. How do I do that? Is it possible?
Maby export and some html code would do it?

 

[wazz]

start a new thread for this question and include as much info as possible, like what you wish to export, etc.

 

[haffy]

start a new thread for this question and include as much info as possible, like what you wish to export, etc.

Ok, I will do that.