Search results

Re: attaching file to table using VBA Sorry for the confusion. was entering the thread on my tablet. have an access 2010 db that uses forms for data entry. i want the user to fill out a form and attach a sign in sheet to a table. all the data and the attachment will be written to a table...

looked at other threads for assistance. they either confused me or did not help. have 2010access db. what to attach or link PDF sign in sheet to a table when user saves form, also email pdf, all with VBA. can get attachment to work if bound to table and use access controls but not with VBA...

Once again, I seek your assistance. I have an Access 2010 database that had functioning buttons until today. I am assuming our IT installed a Windows patch that has killed my save buttons. I could not find any kind of fix on the Microsoft website. So, does anyone know of a fix that can be...

Thank you again very very much! I knew I would get a fast correct answer from this site!:)

I am combining two tables into one to create a report. I want to erase current data in combined table restarting at record 1 each time I pull the report. Doing this with sql code in access 2007. right now, doing erase table, write query 1 to table, append query 2 to table. right now getting...

Thanks Gina. I put the code in and it works beautifully. I knew there was a short and sweet way to code it. You GURUS are AWESOME!!!!!!!!!!!

Hi again. You have been very helpful with my previous issue, I am trying you again. I want to update a main table if a secondary table has a particular value. I am assuming you have to write every field in a table when data is being updated; that you cannot just send one field a new value...

thank you all for your assistance. Paul, I tried your solution % and it did work this time. I had tried it before with no luck, so I must have had a quote in the wrong place. My code is working as expected and you saved my database. thanks again all.:)

this is the code I am using. Dim localconnection As ADODB.Connection Dim rsactivity As New ADODB.Recordset Set localconnection = CurrentProject.AccessConnection sql = "SELECT TBLActivities.actDateReceived, TBLActivities.actTypeSupport, TBLActivities.actProviderName," _ & "...

wrote SQL statement in ACCESS 2007 using LIKE that will not work. If I create a query with the same function (user input) it works fine. please tell me what I am doing wrong or if there is a setting or something that needs to be installed to work. sql = "SELECT tablename.fieldName FROM...