Recent content by paranap

Thanks for the reply. I do appolgise but wasnt able to open the zip as where I work are a bit anal about files and stuff like that. Also sorry if I'm being a bit dumb. I have created a query but the criteria needs to access what is selected in the drop down box ie = form(session)dropdown...

I need to get the result of a query (i think) and then use that date to popluate another table. I have a combo box and want to get the ID from a table that matches the combo box and be able to use that ID when adding data to another table. Any help would be very useful, I know access can do...

I'm adding data to a table from lots of drop boxes and text boxes and want to add an attchment as well. Have tried the same method as I've used for the other data but it doesnt seem to work.

Can you use the VALUES function to add an attachment to a table??

The code given you use me.text where text is the name of the text box. What does the the "me" denote?? Want to add an attatchemnt do a table now and the same process doesnt work!

Thank you that worked really well. I knew there must be an easy way of doing it. Found the link useful too!!

Thank you Sam will try that shortly and will let you know how I get on!!

New to using VBA in access and wish to add data from text boxes or drop down boxes to a table. I'm sure it is simple but cant for the life of me seem to work it out!!

Hi My name is Neil from Kent in England. Used access and VB years ago but it seems to have changed a lot, or I've forgotten a lot, and finding it difficult to get started again.