tranzit
Last Activity: Jul 11 '07, 02:57 AM
Joined: May 23 '07
Location:
-
Form Name: Form1
Form bound to record source: Yes, Table1
Name of controls: Combobox - Combo1, Textbox - Text1, Button - Button1
Control source of combo and text boxs: no control source for combo box, text
box control source is a column
called "123"
...Leave a comment:
-
wat more do u want to know?Leave a comment:
-
Update Table
I currently have a form with a combo box, text box and a button. When a selecetion is made from the combo box the corresponding data from the table is displayed in the text box.
I want the button set up to update the table with any changes made to the data displayed in the text box.
What code is required behind the button???
Can anyone help??? -
menu's missing
i unchecked a box in the startup menu and now the view and tools menus won't appear on the toolbar how do i fix this?????
please help -
I added the button but it didint update the table with the changes made on the form....Leave a comment:
-
Update Command Button
i currently have a form which consitis of a combo box and a text box. When a selection is made in the combo box corresponding data from the table is displayed in the text box. i am wanting to set it up so that if the data in the text box is changed the data in the table is also changed.
How do i go about doing this?????
Any help would be great cheers -
thanks for the help it was the column count that needed changing...
THANKS EVERYONE :)Leave a comment:
-
the statement i have in the combo box row source is as follows:
SELECT * FROM [New Plymouth] ORDER BY [New Plymouth].Destination;
is there something worng with this????
it works fine with the first text box but nothing appears in the second text boxLeave a comment:
-
thanks for the help but i already tryed that and it didn't work i can't work out why???Leave a comment:
-
need help with code for combo box
hi i have a form with a combo box and two text boxes on it.
i want it set up so when a selection is made from the combo box the two text boxes will display the corresponding data from the table.
the table name is: New Plymouth
the fields included in the table: Destination
Kilometres One Way
Kilometres Return
... -
sure,
in the row source of the combo box i have the following statement:
SELECT [Table].field, [Table].field FROM [table] ORDER BY field;
and in the after update of the combo box i have the following:
Private Sub [combo box]_AfterUpdate()
Me! textbox = Me! combo box.column (1)
End Sub
This allowed me to make a selection from the combo box and it displayed the corresponding...Leave a comment:
-
Thanks for all the help i have now sorted it and it works fine...Leave a comment:
-
This is what comes up when i try the form:
Microsoft Access can't find the macro 'me'
the macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. note that when you enter the macrogroupname. macroname syntax in an argument, you must specify the name the macro's macro group was last saved under.
What does that mean??????...Leave a comment:
-
here is the code i tryed:
me.Kms = dlookup ("kilometres"," New Plymouth","[kilometres] = " & me.Dest)
The name of the combo box is Dest
The name of the text box is Kms
The name of the table is New Plymouth
The name of the fields in the table are destination and kilometres...Leave a comment:
-
Thanks for the help. i am using a destination field as the search criteria, when the destination is selected the kilometres from the corresponding fiedld are displayed in the textbox.
i tryed the argument you gave me but it now it tells me that there is no macro named "me".
i am so clueless about what i need to do...Leave a comment:
-
Combo box searching
I have a database where i am wanting a form to lookup data from one table.
i currently have a combo box used for searching and i am wanting to have a text box display the information relating to the search
how am i able to do this? can someone please help me?
No activity results to display
Leave a comment: