Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. freefour

    Report Open Preview, Two Pages, and Zoom to Fit

    Hello, How would I accomplish opening a report in preview, two pages shown and zoomed to fit from a button click? Thanks! --freefour
  2. freefour

    ForeGround color in subform

    TheAceMan1, I am writing this for a friend as a favor, and you're right, upgrading seems logical to me, but my friend is going through some hard times and that isn't an option because of cost. Doing this color coding would be a great enhancement, but it's not an absolute necessity. If you run...
  3. freefour

    ForeGround color in subform

    Stephen, Yes they are controls, sorry I'm a newbie to all of this. Here is my if then block (in the subform's On Current event): Dim lngRed As Long, lngGreen As Long lngRed = RGB(255, 0, 0) lngGreen = RGB(0, 128, 0) If Me.AmountPaid.Value = Me.Total.Value Then Me.InvoiceID.ForeColor...
  4. freefour

    ForeGround color in subform

    Stephen, Well, this is a continous subform that displays: InvoiceID, Date, Amount Paid, and Total So this subforms shows all the different invoices for a particular customer. If Amount Paid = Total, then I want them to be Green (for the entire row, all field's ForeColor that are shown) if...
  5. freefour

    ForeGround color in subform

    Hi, In my subform that displays all invoices for a particular customer, I want it so that if an invoice is paid, all the field in a row are green, and the same row to be red when it is not paid. I thought I had this acomplished with a couple simple IF...Then statements and using the...
  6. freefour

    Pull Down Menus

    TheAceMan1, Ctrl + F11 does nothing. I am using Access 97. Even when I start a new database now I am without all my pull down menus. Please help! Thanks. -freefour
  7. freefour

    Pull Down Menus

    Hi, Somehow I turned off my pull down menus in Access. How do I get those back? All I have is a couple of toolbars...help!! Thanks --Freefour
  8. freefour

    Disable Access's close box

    PaulF, Where do I put that code? Sorry I am kinda a newbie. Thanks! --freefour
  9. freefour

    Disable Access's close box

    Hey Rick, Thanks again. Got one more quick question. Instead of the line: DoCmd.OpenForm "Background", , , , , acHidden I want the background form to be the one that Access uses when it starts. How can I hide the form using code? I tried the form_background.Visible = False but that did...
  10. freefour

    Disable Access's close box

    Thanks Rick, Your code works great, but when I want them to exit, it still pops that msgbox up, even when I try to close the background form first. How can I stop that from happening? --freefour
  11. freefour

    Disable Access's close box

    Hey all, I want my users to exit out Access using my exit button (so I can run some vb script I wrote). I know how to disble the form's close button, but how can I disable Access's close X button at the very top? Thanks so much! --freefour
  12. freefour

    Passing Inputbox to text field on a Report

    Thanks Roy, but after trying all three I still get the same result: nothing. txtbegindate is an unbounded textbox. I am curious is there a better way of maybe having 2 boxes on the report that people put the two boxes where they could change the dates and then the report would change to...
  13. freefour

    Passing Inputbox to text field on a Report

    On one of my forms, you click a button that launches my ReportSales report. Using inputbox, it asks for a begin date then a end date. I want to pass those dates entered into my report as well (so it can remind them what the criteria was set at): Here is my code: Dim Message, Title, Default...
  14. freefour

    Totaling Report

    I have no idea why, but I am getting #Error as a return on a text box that has a fomula of: =Sum(Total) This text box is in my report footer and in the report details is a field called Total that shows all the totals in my database. All is in currency format. What a I doing wrong?
  15. freefour

    Formating a value

    Hello, While debugging a line: If Me.paymentamount.Value = Me.Total.Value Then I found that paymentamount was 169.08 and total was 169.078 both fields are set to currency with a decimal place of 2. How can I format total to round before my if statment? Thanks, --freefour
  16. freefour

    Report question

    Thanks Tom, but there is on OnFormat event in my Report. I have: On Open On Close On Activate On Deactivate On No Data On Page On Error I am using Access 97. Any other ideas? Thanks, --freefour
  17. freefour

    Report question

    Hi, I have a simple report that contains a picture (I have the visible properity set to No). I want to use an If statement in the On Open event to cause the picture to become visible if two fields on the report are equal for my printout. This is what I am looking for If Me.Total.Value =...
  18. freefour

    Problem with Report and SQL

    Duh! I figured it out, LEFT join not INNER join. I really need a newer sequel book. Thanks anyway.
  19. freefour

    Problem with Report and SQL

    Hi, I have 3 different tables in my database: Invoice, Parts, and Labor. My Invoice form contains 2 subforms Parts and Labor that link to the Parts and Labor subform. Invoice has a unique ID, the Parts and Labor tables contain the lookedup value of InvoiceID along with their own unique IDs...
  20. freefour

    Using Listbox as control

    I have a listbox that outputs some invoice data. I want to use the first column of the selected row to open another form. I know how to do it with a combo box: Dim stlinkcriteria As String Dim stDocName As String stDocName = "frmEditVehicle" stlinkcriteria = "[VehicleID]=" &...

Part and Inventory Search

Back
Top