User Profile

Collapse

Profile Sidebar

Collapse
damonrulz
damonrulz
Last Activity: Jan 15 '14, 06:49 PM
Joined: Sep 15 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • damonrulz
    started a topic Combobox row value in textbox

    Combobox row value in textbox

    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.
    See more | Go to post

  • damonrulz
    replied to Printing Report with VB
    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...
    See more | Go to post

    Leave a comment:


  • damonrulz
    replied to Printing Report with VB
    Yes, I am not very good at writing VB...
    See more | Go to post

    Leave a comment:


  • damonrulz
    replied to Printing Report with VB
    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?
    See more | Go to post

    Leave a comment:


  • damonrulz
    replied to Printing Report with VB
    Ok, but how do I make the system know that the values in the list are linked to the printers?
    See more | Go to post

    Leave a comment:


  • damonrulz
    started a topic Printing Report with VB

    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?
    See more | Go to post

  • damonrulz
    replied to Combobox Rowsource
    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:
    1. 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
    ...
    See more | Go to post

    Leave a comment:


  • damonrulz
    replied to Tabular Record Number
    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.

    Thanks
    See more | Go to post

    Leave a comment:


  • damonrulz
    replied to Tabular Record Number
    It doesn't seem to be working, but I might be doing it wrong. Can you give an insight on how to apply it?
    See more | Go to post

    Leave a comment:


  • damonrulz
    started a topic Tabular Record Number

    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?
    See more | Go to post

  • damonrulz
    started a topic Combo box affects values in another combo box

    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"...
    See more | Go to post

  • damonrulz
    replied to Opening a form from a combo box
    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...
    See more | Go to post

    Leave a comment:


  • damonrulz
    started a topic Opening a form from a combo box

    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
    See more | Go to post
No activity results to display
Show More
Working...