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 Chriss Miller 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

    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...
  2. 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.
  3. 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...
  4. 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...
  5. DrillMonkey

    Error in "Order by Clause"

    Hi, I am using a form with a combo box and a text box to accept a string to search 2 tables. I recive the following error ******************************** run-time error 3138 Syntax error in ORDER BY clause. ******************************** Row source type: Field List Row source: see code...
  6. DrillMonkey

    Design help

    Hi, I need help in form design. The form will be multi-user (2) people and needs to have a lot of room for data input. I was thinking of using a main form with just a few controls i.e. “Date” “User” “Recordid” “Ship to” and “TotalParcels” Then have a sub form handle the data entry “Description”...
  7. DrillMonkey

    Summing in a query

    Hello, I need to sum 20 fields on a data form. The fields names are "Parcels1 through Parcels20. I'd like for it to show the caculations in the "TotalParcels" control on the form. SELECT tblWarehouse.RecordID, Sum(tblWarehouse.Parcels1) AS SumOfParcels1, Sum(tblWarehouse.Parcels2) AS...
  8. DrillMonkey

    Passing a controls numeric vaule to a printer

    Hello, I have a control on my from named TotalParcels, I want to pass the value of the control to a Dymo Labelwriter.. If the user types the number 5 in the control I want the Dymo to print 5 labels. I want to put this code behind my print button..so when I run my report (on my laser printer) I...
  9. DrillMonkey

    Calculation help

    Hi forum, I have a form called Brookhurst on this form I have (2) controls; the first control is named Packages, and the other is named Total. I want the Packages control to be summed and displayed into the Total control based on this criteria >=date(). After midnight this returns to null. I...
  10. DrillMonkey

    Combo box

    Hi forum, Is there a way to have my combo box display a field name by default "without" user inter action? When the form opens I want to display the field name in the combo box. The field name is school and the table name is Items..
  11. DrillMonkey

    Update Query

    Hi forum, I have a multi-user database (2) users. My fields are | InvoiceId | Date | Driver | School | PurchaseOrder | Requisition | Ticket | Packages | Description | Signature | Memo. The drivers create multiple records then print an invoice. At the end of the day, or the next day he edits...
  12. DrillMonkey

    Edit multiple records

    Hi forum, I was trying to figure out a way to edit multiple records at one time. I know I can query the info I need, but how do I edit say 5 records at once? I was thinking of setting up a form with one "edit" field then query by date..

Part and Inventory Search

Back
Top