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!

  • Congratulations strongm 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. DrillMonkey

    data entry = yes

    Thank you both for your suggestions, it was the main form I was concerned with, I noticed that it would scroll back with the mouse wheel like you suggested. But the subform acted as it should..All is well thanks again.
  2. DrillMonkey

    data entry = yes

    I have a form sub form, I have set the properties for both form and sub form to data entry = yes the sub form acts as expected with no records showing to the user but, the main form does not. The main form can scroll back one record, it will eventually not show any records like the sub form if I...
  3. DrillMonkey

    Set focus

    That did it many thanks
  4. DrillMonkey

    Set focus

    I have a form with a print command button. When the button is pushed it prints a report and sets the form with a new record. The focus remains on the print button, Id prefer it to be set to the "drivers" field or the top of the tab order.
  5. DrillMonkey

    Printing Dymo Labels

    Hi Kzutter, I wasn't getting any blank labels..but I decided to add a dymo print button besides the button I use to print the report..I also realized that in my form/subform, I only needed the parent portion of the data for my SQL statement in the reports control source...sheesh Dymo is running...
  6. DrillMonkey

    Printing Dymo Labels

    This might be better if broken down into 2 command buttons instead of a single print button. Maybe a Dymo print button.
  7. DrillMonkey

    Printing Dymo Labels

    Hi, I'm using a form/sub form to print Shipping label(s) and a single report. The user fills in fields on the main/sub form including TotalParcels, the value in the "TotalParcels" is passed through code, and a corresponding number of shipping labels are printed including a single report...
  8. DrillMonkey

    Me.Parent.Recalc

    Thanks AceMan, Got it, I put the Me.Parent.Recalc in the "On Change" of the parcels properties...Wow very fast now. This goes in the tool box.
  9. DrillMonkey

    Me.Parent.Recalc

    AceMan.. If you mean in my subform, all I have is the "recalc" the form and subform are imported into a switchboard. If you need to see that code I can provide it..
  10. DrillMonkey

    Me.Parent.Recalc

    Hi AceMan, The focus remained on the parcels field, wouldn't even tab off there.
  11. DrillMonkey

    Me.Parent.Recalc

    Hi forum, I have a form/subform one to many realtionship. On my subform I have a field named parcels. On the main form I have a text box named total parcels using this control source. =DSum("parcels","tblpurchdata","warehouseid=" & nz([warehouseid],0)) I have this in the after update of the...
  12. DrillMonkey

    Error in "Order by Clause"

    Yes Duane, I think we can close this thread many thanks!
  13. DrillMonkey

    Error in "Order by Clause"

    Thats why it was truncated cause I used the wrong record source for my report...Duh
  14. DrillMonkey

    Error in "Order by Clause"

    I think I got it...used the query builder and set the record source from there...right?
  15. DrillMonkey

    Error in "Order by Clause"

    my record source for my report is wrong I suspect. SELECT * FROM tblWarehouse, tblPurchData; how do I set it for the sql query?
  16. DrillMonkey

    Error in "Order by Clause"

    also I have no "criteria" in the query just raw data but displaying correctly
  17. DrillMonkey

    Error in "Order by Clause"

    Yes the query returns the infromation correctly, not truncated. And no there are no subreports.
  18. DrillMonkey

    Error in "Order by Clause"

    I created that from the builder in the record source properties
  19. DrillMonkey

    Error in "Order by Clause"

    SELECT tblWarehouse.*, tblPurchData.* FROM tblWarehouse INNER JOIN tblPurchData ON tblWarehouse.WarehouseID = tblPurchData.WarehouseID;
  20. DrillMonkey

    Error in "Order by Clause"

    Hey guys, I may have spoke to soon on this one, I have been running some search reports and found that I am getting mixed results from the search. While all error messages have gone, I'm getting a kind of truncated report. I get the information the user requests (together on one page) plus a...

Part and Inventory Search

Back
Top