List boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

You know when you open the Form Wizard it brings up a form with a
combo box to pick a Table or Query, a list box called "Available Fields" and
another called "Selected Fields" with buttons in between to move the fields
between the list boxes? Does anyone know how to set these up? Help in this
area would be appreciated!
 
Tina,

Hi! I was scared to put too much detail into it because last time no
one replied. :( I actually posted a more detailed version of this question
on 7/15, so I'll just copy and paste that post onto here. Here it is:

"OK, you know how when you open the Form Wizard it brings up a form with a
combo box to pick a Table or Query, a list box called "Available Fields" and
another called "Selected Fields" with button in between to move the fields. I
would like to do something similar to that. I would like the "Available
Fields" box to display a field called "Doctor Initials" from my table
called "Doctors". I would then to be able to move certain doctors with the
buttons to the "Selected Fields" box and enter all of them in a table called
"Pay Group" under one Pay Group number and one Date Assigned. The Pay Group
Table has the fields Doctor's Initials, Pay Group and Date Assigned. The
table
looks something like this:
Doctor Initals Pay Group Date Assigned
SAR 1 1/1/2005
GHF 1 1/1/2005
JKL 1 1/1/2005
Any and all help will be greatly appreciated!"

I hope that makes sense. Basically I want a data entry form to fill in the
Pay Group Table. Sense there are several doctors it would be nice to select a
group of Doctor Initials from my Doctor Table and enter all of them under a
particular Pay Group and Date Assigned. I would really appreciate your help!!!
 
okay, Tandy, i believe i see what you're trying to do and why. i've little
experience with manipulating listbox RowSources in this way, but if you want
to stick with this thread for a day or so, i'll see if i can come up with a
workable solution.
(or maybe we'll both get lucky and one of the MVPs will teach us some
magic!)
 
well, i wasn't able to come up with a solution based entirely on VBA, but
mostly. i used a "temp" table to track the doctors selected in the form's
listbox setup, and appended those records into the PayGroups table, then
emptied the temp table. it's not necessarily that pretty on the "inside",
but the user interface works smoothly.

rather than go into a long-winded description/explanation and post all the
SQL/code here, i can email to you the little db that i worked out the
solution in, so you can examine it. btw, this is not the same db i worked
out the data entry solution for your "PayType/Rate" table (which you posted
asking about on 7/14).

if you want to see the db solution, take note of the cautions i posted in
the other thread on 7/15.

hth
 
Tina,

Hi! I would love to see your database solution, for this post and the
one on 7/15. I'm sorry, I only saw your first post on 7/15, so that's why I
never replied. Anyway, I am going to to give you a different e-mail than the
one I use for this discussion group (I don't really care if this one ends up
getting any junk). If it is not a hassle just RE me to tell me you e-mailed
it. Thank you so much for your help. You have no idea how much I appreciate
you taking the time to really understand my problem and solve it! The e-mail
address is tandy underscore e at hotmail dot com. I hope that's how you hide
the e-mail address!

Tandy
 
got the email ready to go, but seems to be a problem w/ Yahoo right now -
it's not letting me attach the files. i'll try again later today or
tomorrow.
re your "disguised" email address: i really have no idea how much disguise
is "enough", so hopefully what you did is sufficient. :)
 
Back
Top