Search results

Hi, After a few more hours, I think I have moved this on (a little). Have found another example which has helped me modify the code. However, instead of selecting once from the combo, you have to select once for the product and then again for the supplier?? After endless attempts/variations...

Dear All, Thanks to everyone for taking the interest and time to help on this. I am no VBA expert and have just used code from other - what I see as similar situations as a base to start from. Therefore I have no doubt I could well be making fundamental Access mistakes. I was getting the...

Still says MS Engine does not recognise JunctionID as a valid field name or expression?? Dim rs As DAO.Recordset Dim ProductID As Integer Dim JunctionID As Integer Dim strCriteria As String ProductID = Me.cboFindProduct.Column(0) JunctionID =...

Just dawned on me, the field JunctionID is on a subform so the syntax pointing to the field in the FindFirst could also be a potential problem. The subform is [frmPoductSuppliers], the frame of the subform is also [frmPoductSuppliers]. However I have still not had any success. I have tried...

This is the SQL from the combo if it helps diagnose the issue? SELECT tblProduct.ProductID, tblProductSupplier.JunctionID, tblProduct.Description, tblSupplier.[Supplier Name], tblProductSupplier.SupplierIDFK FROM tblSupplier RIGHT JOIN (tblProduct LEFT JOIN tblProductSupplier ON...

Not a VBA expert, but I did have something similar in just below strCriteria =.... MsgBox "Junction ID = " & JunctionID & " Product ID = " & ProductID & "" The values are what I expected. The only other code in the Combo After update event apart from error handling is Set rs =...

Hi, Anyone got any ideas why Access says the engine doesn't recognise JunctionID as a valid field name or expression? Have tried numerous ways to re configure the srtCriteria line with no success? Thanks Dim ProductID As Integer Dim JunctionID As Integer Dim strCriteria As String...

Solved in the thread below. http://www.access-programmers.co.uk/forums/showthread.php?t=263638

Hi, Main Form: The user needs to choose a piece of equipment from a combo box (100's of Equipments to choose from). The combo box lists all Equipments and Vendor combinations, so you may have in the combo list; EquipA-VenA, EquipA-VenB, EquipA-VenC, EquipB-VenA, EquipB-VenB...

Thanks for the reply No, not cascading. The three combos just allow the user to select by either (1) End User Part Number, (2) System Integrators Part Number or (3) Manufacturers Part Number. So one doesn't limit the range of another, just alternative ways of selecting. Regards

Hi, Following pr2-eugin's comments below, I have re jigged this thread to hopefully make it a bit easier to understand. The essence of my problem is summarised in the summary directly below and the attached DB example. Main Form (Products): The user needs to choose a Product from a combo...

Update. Couldn’t get the BrowseTo to work even after trying to recreate it as an Access Macro, same issue as before RTE 6054. However persevered with OpenArgs which captures the record ID on the open form button on my form and passing this into some FindFirst code in the OnLoad event of the...

Hi Michal, Sorry have been away on a trip for the last few days with limited internet access. Also, in my rush to leave for my trip, now I have had time to review this in slower time I have spotted a mistake at my end using the code you provided. I have corrected this and the 6054 RTE no...

Hi Michal, Its coming up with RTE 6054; "The macro action BrowseTo requires a valid Path argument. A valid Path argument is of the form: MainForm1.Subform1>Form1.Subform1". Its highlighting all the code in yellow except the first stLinkCriteria line. Thanks and regards Mark

Hi Kajtam, Thanks for the reply. The code was originally from the Wizard, but I have been messing about with to try and get something to work. Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmPrimeEquipment" stLinkCriteria = "[EquipmentID]=" & Me![EquipmentID]...

Dear All, I have been looking for a solution to an issue we are having. Looked at the following sites and tried a blend of them all, but with no luck. I am sure the solution is a variation of one of them or a combination...

Thanks, got the second method to work oaky. Seems a lot of bother through for just adding a few records. Regards

Hi, Youyiyang, In A2010, it seems to create command buttons using macros to do the work instead of a VBA event procedure as in A2003, but there is an option to convert the macro into VBA, which I did. The converted code which A2010 created wasn't the same as in your example, but I tried to...

Hi, I am trying to create some additional records in an existing Access table by copying (Ctrl C) the data from the excel rows and pasting into the table using paste append. All that is happening is Access is creating the additional auto number rows, but the data I want copied over does not...

Hi Mihail and Youyiyang, Thank you for taking the time to reply. The code for the record counter is below. What is strange is I use the same code elsewhere in the same database on other forms and subforms and with other record duplicaiton buttons and there is no problem?? I have tried to...