Search results

Private Sub Command784_Click() On Error GoTo Err_Command784_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Visits Order" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command784_Click: Exit Sub Err_Command784_Click: MsgBox Err.Description...

Thanks Minty. I put that code in. In the debug window, after hitting Control G, I get the word "Value:" down below.

I have a MAIN FORM that has field [MR#]. Would like to open a new form VISITS that is a data entry form. Upon opening the VISITS form, I would like the [MR#] in the VISITS form to pre-populate from the MAIN FORM's [MR#]. I'm VERY VERY new to the "coding" side of things in Access. Under the...

Thank you!

=iif([actual start time]>#2:59 PM#,"OT","") [actual start date] is a time field in the query. Trying to use this expression in the query to determine OT. Yields error: The expression you entered contains invalid syntax. You may have entered an operand without an operator. I'm not...

Funny, yesterday I did just that and I was getting an error message! Tried again after your response and worked. THANKS for the good vibes, and confirming I was on the right path! ;)

Good day, In Access 2010, trying to use the SetProperty function in a Macro to update another field. The other field that I want updated is an Option Group. The option group is called "criteria", and there are 5 options. In the macro, what would I use for the Control Name? I tried...

GBLACK - thank you! thank you! thank you! Worked like a charm! :D

GBLACK - thank you, thank you, thank you! Worked like a charm! Appreciate it!

I'm trying to calculate a person's AGE in MONTHS but to the closest 1/2 month. (i.e., if someone is 37.1 months old it would be 37.5 vs. if they are 36.9 months it would be 36.5, etc.). Can anyone help? Thanks! Michele

Thank you... yes, that was a thread typo. I changed output format from pdf to snapshot: DoCmd.SendObject acSendReport, "Activity_KR", "SnapshotFormat(*.snp)", "name@company.org", "name@company.org", , "KR time off/change submission" Still getting the same error message. Could it be...

I see. Still learning this complex world of coding. Thanks for your help. DoCmd.SendObject acsSendReport, "Activity_KR", acFormatPDF, "name@company.org", , , "KR time off/change submission" No longer getting syntax error! However, am getting message: The command or action 'SendOject'...

Thanks!... I went ahead and tried that: Private Sub Command32_Click() DoCmd.SendObject acsSendReport, "Activity_KR", "acFormatPDF", "name@company.org", , , "KR time off/change submission", , End Sub Still getting a syntax error :confused:

I'm working with Access 2003 with very little coding background/experience! I've created a command button to email a report (as a pdf) to an email in Novell Groupwise. The code I used is: DoCmd.SendObject acsSendReport, "Activity_KR", "PDF", "name@company.org", , , "KR time off", , With...

I have created a report that I am sorting/grouping by Patient#. I am using a group header (header for each patient). However, it is splitting the page after the group header and before the Detail. I've tried everything... page is not too large, no force new page selected. Thoughts? :) Michele

Hey there Uncle Gizmo, Thank you for your help. That formula didn't seem to work for me! See attachement - maybe I wasn't clear on what I'm trying to do in my report. Thanks for any offered help! :) Michele

I have a list of providers in a form pulled from a query of records. i.e., 1 Smith 2 Jones 3 Lina I want a field in the footer to read these in a text box as "Smith, Jones, Lina". Not sure how to do this with text. I know with #'s I could do a count or sum function. Not sure if...

But I still want them to run in the order of the table. I.e., I don't want it to run all the diabetes ones first and then all the endo. I just want it to skip over running the endo reports IF the field (patient_type) in the appointments table is "diabetes". Is this at all do-able? :o

You've been a huge help! Here is my current code (abbreviated version): -------------------- Private Sub Command0_Click() Dim rst As DAO.Recordset On Error GoTo Command0_Err Set rst = CurrentDb.OpenRecordset("APPOINTMENTS") Do Until rst.EOF diabetes patients reports...

Getting there! Thank you so much! Am am getting a msg "Open Report action was cancelled" when it hits a report that doesn't need to be printed. (as indicated by the underlying query)... Ex: a patient that doesn't have allergies, the allergy form won't print.... The code doesn't just keep...