Search results

@jdraw, Thank you for your replied. I think I know my problem. I should not have the Cal that occur in three different day into three different line of code, I should place it into on line of code, like cal 97 should be: Case Me.HoldCal = "Cal 97" If Weekday(Me.FIRSTCDATE) = vbMonday or...

Hello, I found this function ' Calculates the date of the occurrence of Weekday in the month of DateInMonth. ' ' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed. ' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed. ' '...

I do have EmployerCodeID in the form for looking how many employers that the employee has. I will try to get a test DB upload. Thanks for your time

@Gasman, Sorry, not sure how to do this. I used DCount is for if more than one than save both but I guess my code is incorrect so it's only keep saving the first one even if it has two employers

@Gasman, Sorry to bother you. I did use the DCount but it seems only looking for the first record and not move to the next record. Please let me know if I should post my code. Thanks!

@Gasman Sorry, in my current Database(not the DB I uploaded), I use the same method as the DB I uploaded for the save report as pdf. I'm trying to save the Employer record(s). An Employee can have more than one employer. so when I save employer records which an employee has two employers...

@Gasman, Thanks for your suggested. It works! I have one more question, if the a TagNo has more that one record, I noticed when try to save the next record with the same Tagno overwrite the first one, how do I save it if there is two records under one record. For example: EE00001 has two...

@Gasman , Do I need to change the query? as you can see in my database that I attached on this thread, I used TempVars in the tagno in the query, so I need to do the same?

you meant instead of If me.Salvage = true, replace with TempVars("Salvage")?

I have a text box on frmParmEqA for the Salvage, so it will check if the record is true or false.

@Gasman, What I'm doing on the reports is, if the Salvage is true in the record(s) then it should have the report name as Salvage A & Salvage B, if it's false the it should be InventoryA. For example: I have three records mark as Salvage = true (EE00001, EE00002, EE00003). the rest of the...

Hello, I'm working on Save a batch reports to pdf individual(with the tagno). Everything seems working however if I have the IF statement then it's not loop through all the records, I have a If statement like If Me.Salvage = True then do this else do this End if This If statement...

@theDBguy , Thanks for the example! @Uncle Gizmo , great info but do I have to create table for it or if anyway I don't need to use a table? Thanks!

@theDBguy , Sorry, how to I set up a recordset for that?

@theDBguy , Yes, that's exactly what I want. Sometimes there are 10 orders in one OrderDate. For example, if user enter 12/7/20, Dept: Fiscal (sorry on the description I put Location, it should be dept, but the code is correct for the location). so it might have 5 different order#, each report...

Hello, I have a question how to save multiple reports to PDF. How do I save them into individual page by order# instead save them all into one page by individual order#? I have a form that users enter Order date and Location. When I click Save Reports, if I have four order#, it save four...

@all, I think I got it works now. I set a location as FilePath then use @arnelgp's method: FilePath = Environ("userprofile")\OneDrive\Order-PDF Forms\" DoCmd.OutputTo acOutputReport, "rptOrder", acFormatPDF, FilePath & Me.OrderNumber & "-rptOrder.pdf" Report(s) saved to the specific folder now...

@theDBguy, I did not assigned the location of the OutputFile because I don't know where the users want to save the reports to, that's why I leave open. But I think I show assign the location, correct? @arnelgp, I tried your method, it works the way I want , but one more question, is there a...

@all , sorry , I wasn't trying to ignore any suggestions or questions, if I make you feel that way, please forgive me. I might have missed reading one or two replies but I would never ignore. I respect each of you for your knowledge and skills and appreciate your assistance. I sent the screen...

Sorry, here is the screen shot