Search results

Im getting a compile error stating function or sub is not defined with regards to Call arlRefreshCheckBoxes

Yes they do update. But I will still implement your code if you think I should.

Sorry Vlad...I am just now seeing you had posted this earlier! I made an update above and it is now working. Thank you for everything brother...I certainly appreciate it ! -mgm

*****UPDATE******* It works. Three things fixed it. 1. I adjusted Arnelgp's function code from: Dim i As Integer 'the sample also assume you have 4 checkbox For i = 1 To 4 Step 1 Me("Chkbox" & Format(i, "00")) = DLookup("AttachFile", "tbl_Attachments", "AttachmentID = " & i)...

ahhhh now we are back to the check box being bound to the record and uneditable

Vlad, This didn't work...I tried it in the AfterUpdate code and also tried putting it in the function....still didnt work. I can tell you that it is definitely has something to do with the number of checkboxes and the Function code. I also tried many variations in the function as well as...

Ill give it a shot....stand by....

Ok I found the issue. It was a typo. I had placed =fncUpdateTblAttachment() in the AfterUpdate Control. The correct code is =fncUpdateTblAttachments() It works...however, I am getting one error message when I "uncheck" the box. I am suspecting that it has something to do with the number of...

it compiles...but it does throw one error regarding an email button...but it is totally unrelated

Let me try..... stand by

hmmmmm...nope didn't like that either....

Thank you for this Arnelgp... I appreciate the assistance. I placed all the code in the right spots...but one issue...upon clicking the attachpdf box (by way of the afterupdate function you provided) I am getting a message stating access can not find the function. I have placed this function in...

I have been trying for a while and I can't seem to figure out how to use the "AttachPDF" checkbox to update the value in the AttachPDF (Yes/No) field of the tbl_Attachments table. Arnelgp made a great suggestion earlier...but I am unable to implement. I have 5 unbound checkboxes named...

Yes understood...Im going to play around with that approach and see what I can do...thank you!

*****UPDATE***** Vlad, I took your suggestion and it worked. I put the following code in my object source property and it worked! Thank you! =DLookup("[DocPath]", "tbl_Attachments", "AttachmentID = 1") -mgm This is awesome news and it puts me on the right track...but one last question.... I...

Thank you Vlad, Yes...I saw the same thing you did and I did change the field in the table to short text and have stored the full path there. The field name is caled DocPath. I can now attach the stored path to the web browser object and it works. However, I don't see how I can make the web...

So I have been trying to follow your instructions on this and have made a bit of progress. This is what I have done so far... 1. Created a table called tbl_Attachments with the following fields: AttachmentID (PK) Autonumber Category number (from one of my LookUpTables) UpLoad Date Date/Time...

ohhhh I like this approach. I totally get your logic here.... now I gotta go find the right code for each of the steps...but i do understand what you are saying. First thing I'll do is create a table with all the PDF files (25 of them). Then Ill attach the form to that table by record source...

ahhhhhhh so you are saying to place your function code in a module and then making a call to it from the double_click property of the thumbnail window...so when the user double clicks the thumbnail it will open the actual document....correct?

Ok first off...I am not asking for anyone to write the code for me..I don't expect anyone to donate their time or effort to that level... However, I am asking for someone to point me in the right direction for me to do some research and figure out the answer. What I need to find is "the happy...