Search results for query: *

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

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

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

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

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

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()...

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?

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

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

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

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

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

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

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

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?

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?