Search results

Hi everyone I know it's possible to use Access to create a Word document and think it's possible to have a button (or combobox) open a Word document saved on the hard drive. If I'm correct with the second belief, the Word file(s) would need to be moved with the Access database if it's moved to...

Hi everyone I've seen a number of threads here, as well as elsewhere, which suggest that it's good practice to use a query to provide data to a subform, rather than placing data directly from the table. I can understand the need for this if a special function of the query is needed, such as...

Hi everyone I posted this question about an hour ago but I seem to have been logged out by the time that I actually pressed "send", so I don't know whether it was posted correctly - I can't find it! I've created four buttons on a form to negotiate my way through the records. When I come to...

Hi everyone I have a main form with two subforms and one of the subforms has a further subform. Lets call them Main, Sub1, Sub2 and Sub1Sub. I have the following code which triggers as soon as I open Main: Private Sub Form_Current() Sub1.SetFocus On Error Resume Next DoCmd.GoToRecord , ...

I came across some code on http://www.mvps.org/access/ which validates the UK postcode. It was created by John Nurick. I've used it successfully in: Private Sub Text0_AfterUpdate() If Not rgxValidate(Me.ActiveControl.Text, "(?:(?:A[BL]|B[ABDHLNRST]?|" _ &...

I came across some code on http://www.mvps.org/access/ which validates the UK postcode. It was created by John Nurick. I've used it successfully in: Private Sub Text0_AfterUpdate() If Not rgxValidate(Me.ActiveControl.Text, "(?:(?:A[BL]|B[ABDHLNRST]?|" _ &...

Hi everyone I use MS Office 2003 and have seen several threads which give samples that have forms and code to take data from Access and merge it automatically to a Word document. That's fine, but is it possible to have a unique document reference ("Our ref:" in the Word document) which is...

Hi everyone I use Access 2003 and saw Ken Higg's sample database to filter records in a form using a combobox. I managed to replicate his settings and wondered about an extension to the principle, but I don't know if it's possible. In the sample, a value is selected using a combobox and all...

Hi everyone I use Access 2003 and have created a form with several subforms which I've placed onto a number of tabs. I'd like to have some of the most recently entered data from the subforms displayed on the main form. For instance - if one of the subforms details the repairs to my car, in...