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: cafulford
  • Content: Threads
  • Order by date
  1. cafulford

    Access - sort/order by after a query has been grouped - subquery??

    Hi, I have an existing query (http://aearo2.com/tmp/qrySelectTrailersExplained2.jpg) that I would like to sort by the date/time the record was entered into the table bl_file that feeds this query. I have a date/time field called TIME_REC_CREATED. I added this new field TIME_REC_CREATED to the...
  2. cafulford

    Syntax in macro condition

    Hi, I am using the following condition that works fine: DCount("*","BL_FILE2","[deliv_num]=Forms![do a delivery]![deliv_num]")>0 in a macro that looks to see if there are multiple pages of this particular form called "do a delivery" based on "deliv_num" in the file "BL_FILE2". The form "do a...
  3. cafulford

    Access 2003 Multi WhereCondition Question

    Hi everyone, I am not a programmer at all and I am trying to figure out how to get a WhereCondition to print a second page of a report if a flag called "MULTI_PAGE" is set which is available in the 1st reports table. The 1st report, or 1st page, prints fine with the code below. My question is...
  4. cafulford

    DoCmd.RunMacro Problem/Question

    Hi, I am really new to VB and I have been tasked with modifying an existing Access application to basically print batches of bill of ladings. I have the print working when I call the report directly like: DoCmd.OpenReport "Bil OF Lading",, WhereCondition:=sWhere but there is a macro as part...
  5. cafulford

    How do I sum/count # of records?

    Hi, I have a query that contains data from a table as well as an calculated field that concatenates 2 text fields together called "carrier_trailer". I am creating a new form based off this query and I want to do the following: 1) Show a screen that sums up the table by this "carrier_trailer"...
  6. cafulford

    New field concatenated automatically from 2 other field in form

    Hi, I am new in Access and coming along fairly nicely but I am trying to figure out how to take 2 fields in an existing form, named "carrier_name" and "trailer_number" (both text fields), and: 1) concatenate them into a new field called carrier_trailer automatically maybe when you enter the...
  7. cafulford

    All field not showing from query

    Hi, I have a combobox that I have set the following query to in the RowSource property and when run, I only get the 1st field (prod_id_2) to display. I can not figure out why it is not displaying the other 2 fields. select prod_id_2,prod_desc,size from sw_prod order by sw_prod.prod_id_2 I ran...
  8. cafulford

    VFP 6 Drop Down Search as User Types

    Hi, I am completely new to VFP and have been asked to look at some code that was written years ago and try to add drop down search capability. I really have no idea on where to start. In this case it will be when a user starts typing in the product #, a box appears below the entry that lists...

Part and Inventory Search

Back
Top