Search results

This is a nice idea to ensure correct data input, but it's possible for a "lazy" user to simply copy and paste the incorrect data from the first textbox to the second. Is it possible to disable copy and paste, as well as CTRL-C and CTRL-V, whilst the data is being entered into txtboxes1 and 2.

Sorry about the double post - my laptop crashed whilst posting. Can a mod remove the other post? I managed to get it sorted. I went to Insert>Module and then copied the Function, along with the Public Declarations into the new module. I modified the code slightly: Sub Text0_AfterUpdate()...

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...

Yes, I understand. I can see why one may wish to hide forms, tables etc., but it doesn't take a great deal of playing around to unhide them! I'll look into more permanent ways. I realise that a determined "fiddler" will probably get around most methods, but at least they're likely to foil the...

That's brilliant - thank you for reposting it to the samples area. Your solution goes further than I need - it filters by cbo1 AND cbo2 AND cbo3 but I only need cbo1 OR cbo2! I'll dissect the forms, controls and code to see if I can figure out how it works. I have a query which relates to...

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...

Thank you Andy. That article gives a very nice extension to what I need to do. I hope that others find it useful too.

Just after posting my reply, I saw DFirst and DLast in the help facility. That might just be what I want!

Thank you Andy. I understand now how DMax and DMin work, but it doesn't do what I want! Imagine a subform with 3 rows of data, each having 6 fields and I want fields 2, 5 and 6 of the 3rd row to be displayed on the main form. If I add a fourth complete row of data, I'd want the information on...

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...