Search results

Right guys, im getting there with this :D Option Compare Database Option Explicit Private Sub ProductName_Click() Dim Blanket_Orders As DAO.Database Dim rstRequests As DAO.Recordset Dim Count As Long Dim ProdID As String Set Blanket_Orders = CurrentDb Set rstRequests...

I'm thinking i will need to incoporate FindFirst in there somewhere. Also, sticking with the coding route, how can I get from the name of the item clicked, to get the id from that table, to then post the ID to the other table - if that makes sense

Cheers guys, Thing is, i feel im pretty much nearly there with what I have currently done - this was the last part that I needed to get working really.

I have a feeling deep down if I use the bound option, i would be re-writing the whole database I already have set out. I'm not saying its not a good idea (i will probably have a sit down some time and actually re-learn Access - did it all at college years ago, and have forgotten most of it now)

Are you saying the way I am doing it via code, and a link for each on the actual database, I cannot assing the ID to this? (ie on php link i could do the link test.php?id=1 and so on, and call the ID from that link. I think i kinda have gone the long way around on this from my php background...

Not at all - help is muchly appriciated :)

Probably my fault as im used to coding in PHP and HTML and what not, so usually take the coding route then the "easy" options, as this was the only way i could see it doing what i required. Thing is, i want/need most things hidden, and do not have the time to take a course before I need to get...

Like I say, im new to coding in VBA, so was just following tutorials and what not and puttin peices together to make the code work. tehNevllie - You see where the values "9" and "47" are, i would like these to be linked to the form, ie when you click on "65w Power Pack" which has ID of "9" it...

Anyone any ideas - this is puzzling me now

Right so the code is kinda working now Private Sub ProductName_Click() Dim Blanket_Orders As Object Dim rstRequests As Object Dim fldEnumerator As Object Dim fldColumns As Object Set Blanket_Orders = CurrentDb Set rstRequests =...

Hi Guys, Right I would say i need a bit of help with this one - I am quite new to VBA, but have used access DB's for a while now - but i program in other languages so can get my head around things once im shown. Anyway, I have a database that I have setup, and is mostly working, apart from...