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

    Thanks for the input. I ended up getting it to work as follows in case someone else is looking for something similar: nz(DLookUp("page_no","BL_File2","deliv_num=[Forms]![do a delivery]![deliv_num]")="2") nz(DLookUp("page_no","BL_File2","deliv_num=[Forms]![do a delivery]![deliv_num]")="3")
  3. 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...
  4. cafulford

    Access 2003 Multi WhereCondition Question

    No, I was wrong. Report "Boll of Lading" uses the table "bl_file" and report "BL2" uses table "bl_file2" to get it's data. I kind of have a subreport inserted in to Bill of lading but how to I get it not to print the BL2 piece if bl_file.multi_print is not true?
  5. cafulford

    Access 2003 Multi WhereCondition Question

    Bill of Lading is the 1st page and BL2 is the second page of the same report and believe it or not, both reports get their data from the same table - bl_file. The person who designed this was not familiar at all with database design or worried about normalization. He left long ago and it now...
  6. cafulford

    Access 2003 Multi WhereCondition Question

    I am so new to access I am literally hearing all these terms for the first time. Can you point me in the right direction? How would I check for the multi_page flag? I tried looking at adding the bl2 as a group footer section int he main report and cancelling the printing if the value of...
  7. cafulford

    Access 2003 Multi WhereCondition Question

    Hi Duane, Am I correct in thinking that the approach you recommended may not work because the multi_page is at the record level and the query is at the group level or am I missing something? Here is the query. How would I modify it for the record level? I am so close! Thanks for your...
  8. cafulford

    Access 2003 Multi WhereCondition Question

    Hi Duane...sure: I inherited this application and it was designed very poorly from what I can tell. I am more of a Web UI (Dreamweaver, etc.) type of person but for the most part understand programming. With that said: I created a .jpg with snapshots of the code for you at...
  9. cafulford

    Access 2003 Multi WhereCondition Question

    Duane, could you provide a sample piece of code for me? Thanks, Charlie
  10. cafulford

    Access 2003 Multi WhereCondition Question

    I am sorry, my lack of experience in Access is showing but I am learning. It prints a report called "Bill OF Lading" which is usually 1 page long. There are cases where the BOL will be more than 1 page in which case, the report "BL 2" need to run. I set a flag called "MULTI_PAGE" to true...
  11. 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...
  12. cafulford

    DoCmd.RunMacro Problem/Question

    I have found out that the "print_one_bl" macro is not working because the form has to be open. That was where the print command was before in the old app. I also realized that the WhereCondition:=sWhere does not work with DoCmd.RunMacro. So I guess I am asking: can I check for those conditions...
  13. cafulford

    DoCmd.RunMacro Problem/Question

    I forgot to mention that I know the form is not open and that is problem #1 but also the WhereCondition:=sWhere does not work with the DoCmd.RunMacro command. Ideas?
  14. 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...
  15. 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"...
  16. cafulford

    New field concatenated automatically from 2 other field in form

    Missinglinq, thank you so much! I really appreciate the response. Charlie
  17. 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...
  18. cafulford

    All field not showing from query

    Thanks so much Nigel and Olaf. Much appreciated! Charlie
  19. 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...
  20. cafulford

    VFP 6 Drop Down Search as User Types

    Mike/Imaginecorp, Do you have any examples of a popup or textbox code that I could use as a baseline to try? It would be great to get it working like Google search. Thanks, Charlie

Part and Inventory Search

Back
Top