Recent content by crumpet

Hi all , wondering if anyone can help i have a database in which i want to create a hyper link to a website that i have to log into via user name and password i tried just bookmarking straight to once im already inside but when i try get info from the website it dosent let me in (obviously...

dam , looks like i spoke top soon seems that the file path that gets copied across inst behaving like a hyper link if i copy and paste a path from explorer it works but from the browse button its like dead link , any ideas ?

yippee it works i tells ya , thanks so much bud when you said i didn't assign anything i removed all i had done so you could start from scratch the problem was i didn't use a _ between assignment and path, i didn't realise i had too thanks again mate

ok i did what you said and now it will fit , here it is , when you open it , open the customer form and you will see on the subform i have 3 attachment paths all with a browse button next to them , i need those paths to be filled by the choice made of the browse button thanks for all your help

database is too big unfortunately, im using office/access 2003 as stated i have a table which contains the field "attachment path" this is a hyper link. my form is directly based off this table i now have a command button with using your instructions allows me to select a file, problem is i need...

ok i tried on the lost focus secion of my command button which calls up my browse for file the following Me.Attachment Path = fGetFileFolder and it dosent work it says "method or data member not found" now from what i can tell the hyper link field name is attachment path as sated in the...

when i go into references the Microsoft access 11.0 library is already ticked , what else do i have to do from this point ? edit my bad , there 2 that look similar, ok now i get the browse screen yippee , but my final question is how do i tell it to input that results of my browsing into the...

ok when i do it the way you have shown i get the "user define type not defined" and it highlights the following section Function fGetFileFolder() As String Dim dlg As FileDialog Set dlg = Application.FileDialog(msoFileDialogFilePicker) With dlg .Filters.Clear...

ok now when i click on my command button it says "cant find macro fgetfilefolder" why is it looking for a macro , i simple wrote fGetFileFolder in the on click section of the command, was this wrong ?? alternatively my module is called module 1 and if i type in fGetFilefolder in the build area...

ok the object library is already ticked, can someone show me how to get a command button to run the code that ive inputted into the module

sorry guys im a total noob with code and i cant find the tools>refernces , im using access 2003 can you guys give me a step by idiot version step by step

Hi Moniker , thanks for replying, Ive managed to create a hyper link field in my table called attachment path so now i simple type in the path and it will provide a separate link for each record the only issue i have is the long windedness of this , is there anyway of me having a button next...

Hi Guys, This is my first post and I hope to become a active member of this forum . Was hoping anyone could help me , i have a complaint database in which i would like the ability to attach a jpeg/document to the complaint record via the complaint form, like a "attach attachment" command button...