Search results

thanks ghudson - not a bad idea, the only flaw i can see with it is that storing it as a hyperlink means that if there is a link for that record then the link will displayed - if there isn't, then nothing is displayed (looks a little bit tidier imo) whereas the way you've suggested, though it...

thanks Len, that works perfectly!!!! thanks very much, i've been baffled by this one for hours. any reason why that # symbol has to be added? thanks again Dave

my Hyperlink hell!!! hi guys I'm having problems with a hyperlink. Basically, I have a msg box that opens - when the name of a PDF is entered, my code adds the full UNC path to the name of the pdf and saves it as a hyperlink. In theory, it works perfectly. When you enter "test.pdf", it saves...

thanks Matt Maybe I'm being stupid, but that doesn't seem to work for me - are you using A97? I see what you're saying about dropping the link criteria though

hi guys Have an issue with opening/searching forms etc in Access... Usually I'd use the code below to open a form at a particular record, but what I'd like to be able to do is open the form at that particular record, but still be able to scroll up or down through adjacent records. Does anyone...

thanks Sean but I've sorted it - not really sure how though! Basically just set up a new workgroup, changed the permissions for users etc and it all worked ok. I think that it could have just been a permission thing - maybe the code was trying to fire something which the user didn't have...

hi guys Having a strange audit trail problem in Access 97 Basically, I didn't develop the database but have "taken over" after the developer left. I'm quite experienced with Access, but usually use my own security modules so am not too familiar with the "user-level" security stuff. Anyway my...