Search results

  1. H

    Form open on specific monitor?

    Is it possible to dictate which monitor a form opens to on a 2 monitor system?
  2. H

    How do I show a picture on mouse over control button

    I guess I am just not sure what you mean by a sample data base. Here I just created a simple form and when I hover my mouse over the command button I want to display a picture next to it of that object. When I move my mouse off the command button I want the picture to disappear.
  3. H

    How do I show a picture on mouse over control button

    I am willing to do anything. The code that I posted was just something I found on the internet. I am looking for the most efficient way and easiest way to do this.
  4. H

    How do I show a picture on mouse over control button

    The main form is the Yellow form from which I select the model. Each Name on the form is a Command Button that opens the Blue form with the model associated with that name.
  5. H

    How do I show a picture on mouse over control button

    It is still a work in progress but what I am looking for is when I hover over the Name (Command Button) it displays a picture of the model associated with that name. When I move off that name it closes that picture and opens another one when I hover over that name, etc. I use this form to open...
  6. H

    How do I show a picture on mouse over control button

    Good Morning, I have a control button showing text and I would like to display a picture when I hover over that control button and disappear when I move on to the next control button. As an example I have 3 control buttons with the text "Apple", "Pear" and "Orange". When I hover over the text...
  7. H

    Current Record Report?

    Thank you, can you explain the acHidden and what its function is as well. I tried reading online about it but to no avail.
  8. H

    Current Record Report?

    Is that with the acNormal, or the way I have code written now. I want the button to print the report when I push it and not have it open the report so I can hit the print button on the report page when it opens.
  9. H

    Current Record Report?

    I tried all three suggestions but now it prints the record on the form and then prints the form with all records. So instead of only getting the one record I am getting a page with the record in question and then the form prints with all 10 records.
  10. H

    Current Record Report?

    OK, I think I figured out a way to make this work, it may be clunky but it does the job. I would prefer if the report never opened and just closed if someone knows a better solution let me know. Private Sub Command14_Click() DoCmd.OpenReport "Labels Table1", acViewPreview, acHidden, "[ID]=" &...
  11. H

    Current Record Report?

    I have a form that I use to enter diecast cars into my database. At the end of the form I have a text box "Label Printed" That shows if a label has been printed for that current record on the form. I am adding a print button to the form and want it to print the report "Box Label Report" for the...
  12. H

    Print Button Question

    OK, I can get the text box to change but am having trouble figuring out how to print my report based on the current record in the form. I thought about using DoCmd.RunCommand acCmdSelectRecord DoCmd.printout acselection But that does not pull in the report that I want to run which is "Box Label...
  13. H

    Print Button Question

    Do I add that to the print button code or the test box code?
  14. H

    Print Button Question

    I have a text box "Label Printed" on a form for whether or not a label has been printed (yes/no, default is no). I also have a print button "Print Box Label" on that same form. I would like the text box to be updated to "Yes" when I use the print button. Is there some simple code for this action?
  15. H

    PDF / Form Question

    The PDF is an actual PDF on my computer showing the model associated with it's number. I thought about a PDF within a form and also an overlaying form where you could still see the PDF. Right now I am using the following which gets me to the correct PDF for the Model number but I want to be...
  16. H

    PDF / Form Question

    Good afternoon, I have a box on a form that when it gets focus that it opens a corresponding PDF to a specific model with a list of sub models. I would like to be able to have a row of numbers on the bottom of this PDF that when I click one of them it returns that value to the original form and...
  17. H

    How to pull a PDF from a file?

    I have 10 different PDF's located in a file on my computer. How can I pull 1 of these PDF into a form that will open once a text box has focus. As an example I have a box named "display PDF", when this text box has focus I want it to open a form showing that PDF based on a number in an...
  18. H

    Query expression Due Date -2 not counting weekends

    Guus2005, A quick question here. I have tried your solution and it work fine, just curious what the vb in front of Monday does in the statement.
  19. H

    Query expression Due Date -2 not counting weekends

    Hello and Thanks for taking a look. I am using the following expression to calculate a completion date for a project which is based on the due date. My problem that I am running into is when I get to a project that is due on a Tuesday, it returns a date for Sunday when it should be Friday. Any...
Top Bottom