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

    Naming Fields in Query using Unbound cell in Form

    Not sure if this is possible, but I have a file that is received weekly to update on Ship Dates. The file is at the Purchase Order (PO) level. For each PO, I would like to be able to compare the new weekly file for the changes from the previous week. To do so, I had thought to import the file...
  2. sbdeaver

    Broken VBA Code

    Yeah! It works. Thanks so much!!!!
  3. sbdeaver

    Broken VBA Code

    Thank you. I fixed that, but now I'm getting: Run-time error '3075' Syntax error (missing operator) in query expression 'PRHDW_SO_MER.CUST_ORD_NBRFROM PRHDW_SO_MER WHERE PRHDW_SO_MER.STR_NBR = '0105' AND PRHDW_SO_MER.MER_DEPT_NBR = 28 AND PRHDW_SO_MER.MER_CLASS_NBR = 8 AND...
  4. sbdeaver

    Broken VBA Code

    Thanks, but I don't know what you mean to do: "Check that you have a reference to the Microsoft DAO x.x Object Library, make sure it is as far up the list of references as it can go, and, finally, explicitly reference the library in your variables: Dim rsSC As DAO.Recordset
  5. sbdeaver

    Broken VBA Code

    Thank you for the help. Am I supposed to delete the two lines with "Dim rsSC As Recordset | Dim rsORG As Recordset" and replace with what you indicated? If so, I get the following error: Compile error: User-defined type not defined Thanks, Sharon
  6. sbdeaver

    Broken VBA Code

    I have inherited a database with VBA and it is coming up with an error message I can not fix. I'm hoping someone will be able to help me. I'm getting a 'Type Mismatch' error at the 'Set rsSC' line. I'm not sure what information you need to help fix it. Thank you -Sharon Public Function getSO()...
  7. sbdeaver

    Combo Box on Main Form to pull information to Subform

    When I am in the main form with the Properties box open and have clicked on the subform, sfrmHDA is the the "Source Object" on the Data tab and the "Name" on the Other tab. Is there something else that should have it?
  8. sbdeaver

    Combo Box on Main Form to pull information to Subform

    Unfortunately, I've tried that already and it didn't work.
  9. sbdeaver

    Combo Box on Main Form to pull information to Subform

    I have a main form (frmHDA) that has a combo box pulling all HDAs (Home Delivery Agent), city and company information. The bound column is 1. I have a subform (sfrmHDA) that includes information in more detail on each HDA. I wrote the query inside the subform to pull down all detailed...
  10. sbdeaver

    call up information in subform

    I'm having the same issue as the person above. I have a main form and a subform. On the main form (frmHDA) I have a combo box to select the HDA. The in the sub form (sfrmHDAInformation) I have a query to pull the selected data, but it is pulling down any information. My parent/child is linked at...
  11. sbdeaver

    Change Report and/or Page Header with Filter

    Tom, The coding worked perfectly! Thanks for your help. Sharon
  12. sbdeaver

    Change Report and/or Page Header with Filter

    Tom, Thanks. I think that will work, but I'm not a pro at VBA coding. Could you give me an example of what I should put in the After Update event that would fill the text box? Thanks, Sharon
  13. sbdeaver

    Change Report and/or Page Header with Filter

    I have a macro that allows for an option frame to filter my report in different ways (Company, Northern, Southern & Western divisions). I would like to have the filter be 'applied' to the report and/or page header to let people know which report has been printed. Does anyone have suggestions on...
  14. sbdeaver

    Change Color of Field on Continuous frm based on value

    Do you put the information in the formatting of the text box? Thanks, Sharon
  15. sbdeaver

    converting text to date

    PHV, Thanks for the tip. Will that work even if I have the importing automated using a Macro? Is there something I could write into the Macro that would let me change the data?
  16. sbdeaver

    converting text to date

    I understand what the 'cdate' is doing, but I'm unclear where to use it. I have a similar problem importing a weekly file; the dates come over as text (12/04/04). I would like to set it up so that once it is imported that field becomes dates. Any suggestions?

Part and Inventory Search

Back
Top