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 Rhinorhino 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: *

  • Users: freefour
  • Content: Threads
  • Order by date
  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

    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...
  3. 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
  4. 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
  5. 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...
  6. 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?
  7. 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
  8. 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 =...
  9. 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...
  10. 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]=" &...
  11. freefour

    Running Total

    Hey all, Inside my invoice form, I have a subform where people enter in parts description, the quanity, and the parts price. I also have another field that totals quanity * price. As they are entered I am looking for a way to have a text field on the parent Invoice form that shows a running...
  12. freefour

    Running Total in Form from ubform

    Hey all, Inside my invoice form, I have a subform where people enter in parts description, the quanity, and the parts price. I also have another field that totals quanity * price. As they are entered I am looking for a way to have a text field on the Invoice form that shows a running total of...
  13. freefour

    Combo Box Easy Question

    Hey all, I have a combo box that selects several differnt fields. When one is selected, it only shows the data from the first field in the box. Is there a way to show all the data after selecting, as it does when the box drops down? Thanks!
  14. freefour

    Help showing data in form and saving to table.

    Hey all... To clarify my previous post a little better: I am writing a little database for a local garage to print invoices. I got a form called frminvoiceacquire that first has a combo box with all customers in it. From that they select the customer that needs an invoice created for. Then...
  15. freefour

    Question about Forms and Text boxes

    Hey gurus, I am rather new to Access. I have a form with 2 combo boxes where a person picks a customer and then one vehicle that customer owns. I then pass both the customer and vehicle key to an Invoice form. I now want to take those keys in the new form and look up the customer and...

Part and Inventory Search

Back
Top