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 bkrike 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: Margah
  • Content: Threads
  • Order by date
  1. 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...
  2. 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.
  3. Margah

    Using Like for Strings what is used for

    I am using the Like expression for strings what would i use for Numbers.
  4. 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.
  5. 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...
  6. 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...
  7. 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