Albert D. Kallal

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

Guest

Thank you for your responce. I did try to use the wizard but it didn't do
what I needed, instead it limited me to the text that was listed in the first
column????
For example; In on of the drop down boxes all I need is the option to choose
the salutation of a contact (Mr. or Ms.)

When I use the wizard it specifies things by column, so I ent up with Mr. in
the first column and Ms. in the second. On my table in the feild the drop
down is in, drops but instead of dropping to two rows with the two options
Mr./Ms. it drops to two columns which are both highlighted, not allowing me
to select either on.

So if you could tell me what I have done wrong or help me to list them
myself without using the wizard, I will truelly worship the ground you walk
on.

Truely frustrated...Veronica
 
As a side note, you should respond to the original thread, or topic you
started. With hundreds of posts here, it is quite hard to figure out what
original message you are referring to.

Veronica said:
Thank you for your responce. I did try to use the wizard but it didn't do
what I needed, instead it limited me to the text that was listed in the
first
column????
For example; In on of the drop down boxes all I need is the option to
choose
the salutation of a contact (Mr. or Ms.)
Click to expand...

Ok, the above is a great idea, and a great use of a comb box.

So, we open a form in design view.. We make sure the wizard is set on
(obviously, you got this far).

Ok, now lets place a combo box on the form.

We will choose the 2nd option: "I will type in the values I want"

Sure, since we only got two possible values for this combo box, then it is
EASY to "type in the values I want"

We of course only need one column here. Now, type in your list of values

Mr.
Mrs.
Miss.
Doctor

You can type a few more if you like. (so, we actually in above typed in more
then two values...but you get the idea).

Now, in the next page, you have to choose what field in the forms data
source to save it to. Likely this is called Title, or salutation, or
whatever you used

Click on finish. You have a combo box that lets you select from the above
list and saves your users form having to type these values.

I would get the above working. I would also suggest that you consider
getting a book, or some learning materials here. ms-access is quite a bit
more difficult then is word, or excel, or the other program in office.

It is difficult to "guess" you way through this stuff, and some learning
needs to take place here.

Good luck!!....and please feel free to ask more questions....
 
Ok...I thought I had tryed exactly what you explained, it didn't work when I
tryed the first time but did after your responce. Well I should say it sort
of worked. I was able to get it to work on my "Table" but it does not work
on the form I have linked to it which is where I need it to for data entry.
Now what am I doing wrong. I actually do have some learning materials
(Office XP for Dummies) which is the only way I got as far as I did. Perhaps
I should go back and look for the book for Morons. If you could further
assist it would be greatly appreciated.

I have another step I am working on that is bringing me to a stand still.
After I get the form working the way I need it to. I need to export it onto
a word document (in the FORM view) I have been able to export to word but it
exports in a spreadsheet or table view. Any ideas with this???? thanks for
all your help.
 
I was able to get it to work on my "Table" but it does not work
on the form
Click to expand...

I always assumed you were working with a form. Using combo boxes etc. in the
table view tends to make things confusing, and messy. I would stick to
making combo box stuff in the forms only. I am not sure why the wizard in
the form does not work for you.
I have another step I am working on that is bringing me to a stand still.
After I get the form working the way I need it to. I need to export it
onto
a word document (in the FORM view)
Click to expand...

Do you mean just merge the data to a word template, or in fact do you want
the "form" to appear in the word document? The first idea is certainly
doable, but the 2nd part is not how ms-access, or word works. You can
certainly "paste" a image of the form into word (just hit the print screen
button while looking at ms-access, and then go to word, and go edit->paste).

If you are looking for a template merge from ms-access to word (for making
personal letters etc.) then I have a working sample here:
(super easy word merge)
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

However, I don't know of a automated way to put the whole form from
ms-access into word..
 
Hi Albert,

Well I have concluded my combo box wizard is not working. I am going to
upgrade my software and hope that will fix the problem(something I needed to
do anyway).

However, in regards to my other problem with needing to export, merge, copy
or what ever to word, what I need is just a copy (not a working form) of the
way the access form looks when data entry is completed. My form is basically
a survey form with contact information on top (Co. Name, address, ph. no.etc)
and a series of questions below. The form is finished with the exceptions of
my working combo boxes. I can enter data and it copies it to the
table...just fine. My clients need this information to be transmitted on a
word document. They want to see it in the same format as the questionair we
developed which is the way I designed the form in access. I'm sorry...I did
try to look at your example, however still didn't understand how exactly to
do it. It seems that a merge to a word template sounds logical so perhaps
you can help me try that route. Much appreciated...Veronica
 
Back
Top