Search results

Hi, Could someone please post a copy of the Northwind Database from Access 2003. I am trying to use some code from Allen Browne who uses this in his demo. I only have Access 2010. I can't find a copy of the 2003 version on the net. Thanks.

Hi, No comments on my question as yet. Even just some confirmation that I haven't missed something silly or something obvious would be helpful? Thanks

Hi All, Anyone got any ideas about this? Access 2010. I have a form with a duplicate record button. Sometimes when duplicating a record the duplicate is created but the form remains in edit mode (small pencil in the form margin). I also have a manual record counter on the form which...

Screenshots attached. I originally built this DB using A2003 which seems to work okay! This problem exists on two independent installations of Access 2010, my own private Laptop and a Work Laptop? It just recompiled okay! re checked but the problem still exists? I found another thread from...

Sorry for the length in time replying. Unfortunately, the solution proposed above didn't change anything. I have stripped the form right back with the combo and duplicate record command to see if there was anything obvious or stupid causing the problem. From my messing about, as far as I...

If Not rs.EOF Then Me.Bookmark = rs.Bookmark The bold text is highlighted yellow in the line, thanks

Hello everyone, I have struggled all day with trying to find a solution to a problem I'm having with a combo box and a duplicate record command button. When using the command button, I get error 2237, "the text you entered isn't in the list". It keeps highlighting "Me.Bookmark = rs.Bookmark"...

I did think about that, but wasn't sure how best to go about it. That is worth knowing as I have another problem elsewhere which may well benefit from this. Many Thanks

Hi John, I did find this link via another thread. After some more digging this morning I have found another variation of code (posted below for any others) which I adapted, which has finally worked - after two days of tinkering!! Thanks for trying to help though, much appreciated. Regards...

Hi All, The code below is behind a combo box on a sub form. I need this to change some formatting on parent form when certain changes are made to records in the subform to alert the user. The code for the formatting changes is in current event of the main form, so the code below is used to...

Update. Spotted a mistake - fogot the "" around the form name. Now getting 2489, the object 'forms![frm Equipment Primary]' isn't open - but it is? Private Sub VendorID_AfterUpdate() Dim recNum As Long recNum = Forms![frm Equipment Primary].CurrentRecord Forms![frm Equipment...

Hi All, I have a combo box "VendorID" on a subform, where after update I am trying to requery the parent form [frm Equipment Primary] and return back to the record which has just been updated. I have found the code below on the net, Private Sub YourControl_AfterUpdate() Dim recNum As Long...

Hi Pat, Yeah sorry about the important lack of info - it is the forms Current Event which the code is called from. The form is displayed as a Single Form, so will your opening comment still influence this? Should I still look at conditional formatting? Thanks for you help. Regards Mark.

Hi All, I am using the code below to highlight to the DB user that a piece of equipment is available from two suppliers or vendors. I am using a form named Equipment which has a checkbox named MultipleSource and Label51 embedded. The form (Equipment) is used both independently and also as as...

Sorry, yeah it would be all three. Regards

Hi, leading on from this, after updating the form with the new record from the selection from the combo, I would like to be able to set the value of a tick box on the same form if there are duplicate records in the EquipmentID field. Something like - On find record (after update I guess)...

Yes of course - basic errors. Thanks for pointing this out. Regards

Hello all, Re the code below, I am using Combo40 to find an EquipmentID record, which works fine. However, an Equipment can have two suppliers. Both suppliers are listed in Combo40, but when choosing the second supplier from Combo40, the record found always defaults to the first supplier. I...

Hi All, I am using - Me.Comments = Replace(Me.Comments, Chr(10), vbCrLf) - to remove vertical lines and replace with a CrLf when text is copied in to a memo field from Excel with Alt+Enter’s in the Excel text. On the first event procedure “double click” into the memo field, all works...

Hi Bob, Thanks, I was thinking of this, but thought it was a bit of a cop out. However, I have put in an Orderby EquipmentID and it seems to behaving now. Thanks as always Regards Mark