Access Help

[Jessie]

I'm setting up a database in Access. MY IT guy got me started but now he's gone to Alabama.  I want to set my form to have a dropdown list of job sites to choose from.  Anyone know how to do this?

[Alice]

Yup.  Wait until the IT guy comes back.

[Jessie]

Dirty bitch

[Alice]

Dirty bitch

Nope.  I took a shower this morning.

[Bennyhana]

I'm setting up a database in Access. MY IT guy got me started but now he's gone to Alabama.  I want to set my form to have a dropdown list of job sites to choose from.  Anyone know how to do this?

I've only worked a tiny bit with access, but if memory serves, you have to have a list of these things, then you have to make a dropdown list on your form (in form design view or whatever it's called), and have it reference that list.  Unfortunately, i totally can't remember the exact steps.

[Jessie]

I'm setting up a database in Access. MY IT guy got me started but now he's gone to Alabama.  I want to set my form to have a dropdown list of job sites to choose from.  Anyone know how to do this?

I've only worked a tiny bit with access, but if memory serves, you have to have a list of these things, then you have to make a dropdown list on your form (in form design view or whatever it's called), and have it reference that list.  Unfortunately, i totally can't remember the exact steps.

I found how to make it a dropdown list, I just don't know how to make it grab said list.

[Bennyhana]

I'm setting up a database in Access. MY IT guy got me started but now he's gone to Alabama.  I want to set my form to have a dropdown list of job sites to choose from.  Anyone know how to do this?

I've only worked a tiny bit with access, but if memory serves, you have to have a list of these things, then you have to make a dropdown list on your form (in form design view or whatever it's called), and have it reference that list.  Unfortunately, i totally can't remember the exact steps.

I found how to make it a dropdown list, I just don't know how to make it grab said list.

Damn.  Sorry.

[Jessie]

I'm setting up a database in Access. MY IT guy got me started but now he's gone to Alabama.  I want to set my form to have a dropdown list of job sites to choose from.  Anyone know how to do this?

I've only worked a tiny bit with access, but if memory serves, you have to have a list of these things, then you have to make a dropdown list on your form (in form design view or whatever it's called), and have it reference that list.  Unfortunately, i totally can't remember the exact steps.

I found how to make it a dropdown list, I just don't know how to make it grab said list.

I lied.  Or I should say I was wrong.  I don't know wtf I'm doing.


Damn.  Sorry.

[meredith]

http://www.trigonblue.com/AccessLookup.htm


kinda roundabout if you're not used to such things.  what you need is a table assigning ID numbers to items

1 - Hickville
2 - Funkytown
et cetera

then instead of the job site field in the table you're working with containing text saying the name of the job site, it will have the number that corresponds to that job site

[Jessie]

http://www.trigonblue.com/AccessLookup.htm


kinda roundabout if you're not used to such things.  what you need is a table assigning ID numbers to items

1 - Hickville
2 - Funkytown
et cetera

then instead of the job site field in the table you're working with containing text saying the name of the job site, it will have the number that corresponds to that job site

So how will anyone know what the number means?  *note:  I am at home and have not yet read the link you posted so my question may be stupid*

[meredith]

once you inform access of the relationship between JobSiteID in table A and JobSiteID in table B, it should automagically display the text name of the job site when you view table A

[Jessie]

Thanks, Matt.

My IT guy is going to remote in later and fix it.  Even easier!