Code:
Private Sub buttonPrintIndividual_Click() On Error GoTo Err_buttonPrintIndividual_Click
hansnext
Last Activity: Aug 3 '10, 09:17 AM
Joined: Jul 23 '10
Location:
-
Apologies if I was obscure - NeoPa's post is what I meant. You just write the query with the fields you want in the letter, then the report with the boilerplate text and the fields (such as client name & address)from the query. Then on the form where the users sees the individual record you put a button with code LIKE this behind its OnClick event:
... -
I'd be interested to see your function code as tested with this error.
I just pasted your code into the VBA editor and ran it as a separate function, mainly to see if it behaved any differently from that of MTB. Mind you - I think I actually broke the debugger - as in completely confused it - with all my trying of different code variants that night. Today I have just tried your code again in a clean session of the VBA editor and...Leave a comment:
-
Thanks you for your assistance. The MTB code appears to work correctly with all dates entered. I would be interested to know why my code won't, but hey - yours works so I will adopt it. I agree that dates can be tricky - I know that the US date format is required for SQL statements in code, but I have found in many instances it is also necessary to format the dates to US format to get VBA to work as required/expected.
Just for the...Leave a comment:
-
As the user permissions are effectively at form-level in the FE I think there should be no impact on the input of data into the BE for users with the right permissions. If User Group A cannot see forms that Group B can see, they will not be able to enter data via those forms. The usual issues about record-locking will apply of course but that should not be affected by the security system. Remember to keep a master copy of both the FE and the BE...Leave a comment:
-
A way to do this would be to create a report based on a query which uses the ID of the current record in its WHERE clause and with the boiler-plate text of your form letter as a label on the report. Include the donor's details (name etc.) in the query and then you will be able to place it on the report. The button on your form would run the report to acPreview and then you can just use the Export to Word function from the tool-bar to get it into...Leave a comment:
-
VBA Boolean: Date is between two dates - T or F?
I am "writing" a boolean function in VBA (Access 2003)to test whether a date entered by user is within the financial year that a project is planned for - the financial year runs from 1 July YYYY to 30 June YYYY. The function parses the project's ID code (called "Ref")to determine the project's financial year, then sets the start and end dates of that year to test whether the date entered is between them. "Ref" is a...
No activity results to display
Leave a comment: