Search results

Hi Bob, See attached. All I did to prove this was to download a fresh copy from here just a moment ago and pressed the duplicate record button Command44. As you will hopefully be able to see the EquipmentID is stuck at 361? It started at 306. I have dowloaded fresh copies but sooner or...

Hi Bob, Thought I was going nuts, but the EquipmentID record field on the form when using the duplicate record button increments and then for some reason just stops incrementing, although the record counter still increases? The records are being created as they are in the table, but the...

Hi Bob, Yes on a very quick use, it looks to have resolved the problem. Thanks as ever once again. On quick review I see you have added a AND statement in Combo25 to look at the g_blnCreatingDup status of Command44 and moved the requery to AfterUpdate. Using AfterUpdate had the effect of...

Hi Bob, Its Combo25 and Command44. Thanks Mark.

Hi Bob, Thanks for the offer – though it’s doing what I need so I'm happy with the functionality. However, I have just spotted a small glitch, which I think I know what the problem is, but can’t find a way around. The combo sits on a sub form, which has selection criteria to limit the...

Thanks Bob, Works a treat Regards Mark

Some more detail on the Compile Error. It states - "Method or data member not found", and highlights .OldValue in the line. If .Value <> .OldValue Then. I am using Access 2003?? Any help much appreciated. Thanks in advance. Mark.

Hi All, Wrt to your recommendations above (I am a complete VB novice), I searched the net and found some code, which to my untrained VB eye seemed to look as though it may work, so dropped it into the form before update, but it comes up with a compile error. Any ideas welcome? Private Sub...

Hi All, On the scrounge again. I have a combo which I am using to look up values from a table. What I would like to do is once an initial selection has been made using the combo, should a user then go to change the original selection at any time in the future, before committing to the...

No worries, just interested to know how. It works that's the main thing Regards and thanks again

Hi Bob, After tripping myself up a couple of times, it works. Thank you so very much. Does the code of the main form therefore effectively over write the sql default sql in the sub form, as I would have thought this would have created a conflict?? Thanks once again. Regards Mark.

Hello Bob. Details as requested. After investigating you are correct, the sub form name (frm Equipment) looks to be the same as the sub form control. Many thanks for your help. 1). frm Vendors 2). frm Equipment 3). Combo44 4). SELECT [tbl Equipment].EquipmentID, [tbl Equipment].NSN, [tbl...

Hi Bob, Okay, unfortunately I'm not proficient enough with VBA code to know how to "change the Row Source property of the combo box". I can get the code in the right place, but not the generation of the code itself! Could I get an idea of what code would be required? I'm okay editing simple...

Hi All, I have a subform which has a find record combo with selection criteria to restrict the combo to a VendorID on a parent form. However, I also wish to use the subform independently, but on doing so, because the combo box is no longer being supplied a VendorID value, then a “Enter...

Simples!! thank you, thank you, thank you!!

Hi All, Back into Access after a number of years away so a bit rusty. I have searched through the forum a bit, but nothing jumped out as a solution. I have an unbound combo box on a form used to locate/find records. Works fine as per the wizard. However, when a selection has been made...