Output to PDF in runtime mode & various questions

[aw]

Could anyone can help to solve the following issues

1. Validation check
how to set at validation to check user should input at least 6 digits & not
start with ‘SC’ in Text field

2. Sub-Form
how to set control for checking all data have been inputed before goto
sub-form for inputting

3. PDF output
how to arrange icon to publish the content in form of PDF or XPS in runtime
mode (if macro is needed, could give me the code also)

Thanks a lot!!

 

[Klatuu]

1. Validation check

Use the control's Before Update event

Private Sub MyText_BeforeUpdate(Cancel As Integer)
With Me
If Len(Nz(.MyText, vbNullString)) < 6 Or Left(.MyText, 2) = "SC" Then
MsgBox "You Screwed Up Dummy"
Cancel = True
End If
End With
End Sub

2. Sub-Form
Use the Form's Before Update event. Same concept as above, you just have to
examine all the controls on the form you want to validate.

3. PDF output
Open Access Help and search for "Print, share, and protect files in the PDF
and XPS file formats". You will find an Add In for 2007 that will do what
you want.

 

[aw]

Thanks a lot! Actually I have install the add-in. My question is how can I
provide this add-in for my user that run our access by RUN-TIME only. (not
the original full ACCESS program)

 

[Klatuu]

That I don't know. I suggest you post that as a separate question in the
Installing And Configuring Group. Hopefully, some one with some experience
with that can help. You may also try googling or search MS KB articles.