Everything works now. Thanks for the help everyone.
Bruce
sent from my HTC EVO
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Arc
Not yet. I slept all day then did school work. I'll work on it today.
Bruce
sent from my HTC EVO
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag
Did you get the form to work?
J
-
Experience hath shewn, that even under the best forms those entrusted with
power have, in time, and by slow operations, perverted it into tyranny -
Thomas Jefferson on government
~|
Order th
Ha ha. I just saw that. It happens when you have been up all night and
you are emailing on a phone and not paying attention.
On 8/18/2010 9:40 AM, Medic wrote:
> Who's Ned? Actually wait, don't answer that. I think there's still a don't
> ask don't tell policy in the military.
>
>
~~
Who's Ned? Actually wait, don't answer that. I think there's still a don't
ask don't tell policy in the military.
On Wed, Aug 18, 2010 at 11:02 AM, Bruce Sorge wrote:
>
> Well I just got off a 27,hour shift so I'm going to Ned. I'll play around
> with this later with a fresh mind. Thanks for a
"developer version of CF - It part of my nefarious plant to keep
Bruce involved with CF. I was just thinking that to set up the dev
version of CF takes what 15 minutes? You already have the web server in CF
or you can use IIS. 5 minutes to set up the Access data source. Then
I'd give it only a few
developer version of CF - It part of my nefarious plant to keep Bruce
involved with CF. I was just thinking that to set up the dev version
of CF takes what 15 minutes? You already have the web server in CF or
you can use IIS. 5 minutes to set up the Access data source. Then I'd
give it only a few
"You know in reading this exchange, all I can think is that it would be far
easier to make the access db a data source and do the whole thing in CF. For
all the effort put into this so far, you could probably have this completed
in CF in far less time."
Each has their own uses.
Access is great f
Well I just got off a 27,hour shift so I'm going to Ned. I'll play around
with this later with a fresh mind. Thanks for all the help. Oh, and as much
as would love to code this in cf, this is a standalone db app and not a web
enabled one.
Bruce
sent from my HTC EVO
You know in reading this exchange, all I can think is that it would be
far easier to make the access db a data source and do the whole thing
in CF. For all the effort put into this so far, you could probably
have this completed in CF in far less time.
On Wed, Aug 18, 2010 at 10:39 AM, Jerry Barne
"Also, when I add a new record, again the name in the combo box does
not change. It should be blank and allow me to add a new name. Do I need
to make these separate?"
To make the search combo synch you will have to put some code in the
form_current event like so
Private Sub Form_Current()
M
I'm getting closer. Navigation works well except that the name in the
combo box does not change.
All of my data is on one table and there is not a record control source
either. It is blank. And the search combo box is fed by a query that
selects the ID and name from the table, so I guess it
Cool, I was able to get the control to change the form fields to
the information pertaining to that person. Now I have to figure out how
to add a new record-set. When I hit the add new record button on the
bottom it wont let me add a new name. Ill Google that and see what I
am missing. Thanks for
Cool, I was able to get the control to change the form fields to the
information pertaining to that person. Now I have to figure out how to
add a new record-set. When I hit the add new record button on the bottom
it wont let me add a new name. Ill Google that and see what I am
missing. Thank
"OK, so I did this and the combo box shows all of the names now. My query
has an ORDER BY clause but it is not ordering by the name, it is showing the
names as they are put into the table. Also, when I select a name, the rest
of the fields in the form do not change to reflect the information for t
OK, so I did this and the combo box shows all of the names now. My
query has an ORDER BY clause but it is not ordering by the name, it is
showing the names as they are put into the table. Also, when I select a
name, the rest of the fields in the form do not change to reflect the
information
"I created a query that selects the user ID adn user name from the table but
it only shows me one name in the combo box. I am sure that I am missing a
setting somewhere."
Do you want the combo to show names but in actuality return the user id?
If so, do the following:
Create your source for the
You shouldn't need a query. If the form is bound to the table you can just
put the table name in the row source.
On Tue, Aug 17, 2010 at 10:41 AM, Bruce Sorge wrote:
>
> I created a query that selects the user ID adn user name from the table but
> it only shows me one name in the combo box. I a
I created a query that selects the user ID adn user name from the table but
it only shows me one name in the combo box. I am sure that I am missing a
setting somewhere.
On Tue, Aug 17, 2010 at 11:25 AM, Maureen wrote:
>
> You should be able to go into design mode, right click on the text box th
You should be able to go into design mode, right click on the text box that
contains the name, change it to a combo box. Open the properties window and
on the data tab set row source type to table/query and in the row source
property select the name of the table.
On Tue, Aug 17, 2010 at 10:06 AM,
Hey all,
I have an MS Access database that has all of my platoons information and a
form associated with the table so I can make updates to the table via the
form. Simple enough. What I am trying to do now is rather than have the
persons name in a text field, I want a combo box instead. The combo
21 matches
Mail list logo
