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 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. Margah

    Reports Need Some Help

    Ok. Is there a place on the beb or somewhere to find some information on how to do a form layout in access. i know how to collect the information but the report itself needs to be in a certain layout. Thanks
  2. Margah

    Reports Need Some Help

    Hello All, Is there a way to use a form that was created in Excel in access. What I am trying to do is Create a Report that will fill in the fields of the form that was created in excel. ( Need to try and keep the layout of the form created in excel. thanks for any info i can get on this...
  3. Margah

    Printing records based on a true false result of a field in the record

    I am trying to print a report of all records in a table but only print the records that have the required result from a certain field.. want to do this thru code.
  4. Margah

    Using Like for Strings what is used for

    I am using the Like expression for strings what would i use for Numbers.
  5. Margah

    Using Code to do a Search works good except when I

    OK. I will try. Here is the Form itself TransferID JobNumber Customer Date PoNum Description Qty CostCode The Customer field is auto filled by the job Number and the description is auto filled by the partnumber the date is a default date I have two more unbound text boxes the first is the...
  6. Margah

    Using Code to do a Search works good except when I

    Great it sees all records that have the paramters that I set in the search but when i try to pass the value of the field that I want I get a Data Type Mismatch in Criteria Expression
  7. Margah

    Want to use last input of a filed as the default for new record

    Thanks that did it..
  8. Margah

    Using Code to do a Search works good except when I

    ok what if it is a mix of Numbers and letters what would I use.
  9. Margah

    Using Code to do a Search works good except when I

    Like "*" & [Forms]![Transfer]![SearchFilter] & "*" The above expression in the Critera in the query works good for finding text. but when i enter numbers it crashes any ideas.
  10. Margah

    Want to use last input of a filed as the default for new record

    I would like to use the last input of a field as default to ease the repetive typing. example. typing in Purchase orders. you may have 12 lines on the PO and each line will be a record but the PO will be the same. I would like the po to auto fill the field until I start the next PO then I...
  11. Margah

    Need little help please with some code

    Thank You very much it workedlike a champ.. Very much appreciated..
  12. Margah

    Need little help please with some code

    Private Sub Part__Exit(Cancel As Integer) Dim varPartDescription As Variant varPartDescription = DLookup("PartDescription", "Inventory", "PartNumber = [Part]") If (Not IsNull(varPartDescription)) Then Me![Description] = varPartDescription End Sub In the above...
  13. Margah

    Retrieving Value from a Field in a Previous Record

    Ok I am going to need a little more help. Trying to pull a value from a field in the last record saved.
  14. Margah

    Retrieving Value from a Field in a Previous Record

    Sorry bout that it will be the last Added Record.
  15. Margah

    Retrieving Value from a Field in a Previous Record

    Hello All, I am trying to Get a value from a Field in a Previous record. Could someone please give me a boost in the right direction. Not looking for a complete solution but a Nudge in the right direction.. Thanks Margah

Part and Inventory Search

Back
Top