I am trying to find a way to get the row number that a combo box is on in a text box.
Such as, if a combo box is on row 2, the the text box reads "2".
Thanks.
User Profile
Collapse
-
Combobox row value in textbox
-
When I try to print it comes up with an error:
"This document was previously formatted for the printer on 'Printer Name', but that printer isn't available. Do you want to use the default printer 'Default Printer Name'?"
Then I can click 'OK', 'Cancel', 'Setup', or 'Help'. If i click OK, then the report prints to the deafult printer.
This happens even if the deafult printer is selected in the... -
-
Well you said make a combo box with the names of the printers in it. How does the system know what that combo box means?
In the code to print, is there a part that looks up the printer form that combo box?Leave a comment:
-
Ok, but how do I make the system know that the values in the list are linked to the printers?Leave a comment:
-
Printing Report with VB
Im trying to print a report through visual basic. I have used many different codes to accomplish what I want to do, but none of them are quite what I am looking for.
When the report prints, I want the Print dialogue to popup, all the code I have tried just prints to the default printer.
Can anyone help? -
This process is called cascading combo boxes. There is a tutorial here but I have made my own tutorial specific to your needs which is listed below:- Firstly create two tables:
Code:TableNumbers [ID] – AutoNumber, PK [Number] – Number, This is your 1, 2, or 3 TableWords [ID] – Autonumber, PK [Word] – Text, This is your Alfa, Bravo, Charlie, ect [NumID] – FK, Used to link
Leave a comment:
- Firstly create two tables:
-
Actually, I've just been playing about with it and it has started working well. The numbers are a bit slow to come up compared to the rest of the information but that's not really important.
ThanksLeave a comment:
-
It doesn't seem to be working, but I might be doing it wrong. Can you give an insight on how to apply it?Leave a comment:
-
Tabular Record Number
On one of my Tabular Forms, I want a number on each entry (So the 1st entry in the list will say 1, the 2nd will say 2, and so on).
I originally thought an autonumber would be the answer but if an entry is deleted then there will be a number missing in the list. I have tried CurrentRecord but it just comes back as 1 on each different entry.
Is there a way to automatically give each entry on a tabular form a number? -
Combo box affects values in another combo box
If I have two combo boxes (Combo1 & Combo2) and when a certain value in Combo1 is selected, the values in Combo2 that correspond with that value will show, and the rest will be hidden.
For example, if I wanted the values "1" and "2" in Combo1, and then "a", "b", "c", "x", "y", "z" in Combo2. When "1" is selected, "a", "b"... -
Thanks mate, that worked great!
It's for my A-Level project, so this will impress them a little more.
Thanks for the great advice and welcoming...Leave a comment:
-
Opening a form from a combo box
I have a combo box with a list in. I want to be able to click
on one of the values in this combo box, and a form will open. The difficult thing is that i want a different form to open for each value in the combo box. Preferably a macro. Any suggestions on how I might be able to achieve this?
Thanks
No activity results to display
Show More
Leave a comment: