Search results

thanks ever so much but i get query error messages with any selection now :S doesnt seem to work.

its what the issue effects (fx) and then the thing it effects ie PC or PDA. i renamed it to acronyms because some of them were a little confidential.

Right i have attached an example, hopefully this will give you an idea of what im trying to do. thanks so much for any help it really is appreciated i am a complete newb to access.

i just want it always to point to the same directory that the database is in. no matter what drive its in. surely theres an easy way of doing that? how would i go about creating a message box? thanks for your help rob

Trying to feed 2 browser components paths to some html docs browser.Navigate (CurDir + "\dir\document.htm") browser2.Navigate (CurDir + "\dir2\document2.htm") it always looks for these in My Documents directory even if the database is placed somewhere else. why? thanks for your help, rob

is there a way i can stop it from appending 'AND ;' i cant seem to get a case statement working. what i want to do, is have a load of records once i check the boxes to select the criterea and clicked filter it makes query and only shows records where its ticked. vbs really confusing, if only...

but if 2 cases are true will it run both? i want multiple check boxes to be ticked then the appropriate code added to the query

right if ill see if i can restructure it. how would the case work surely that can only be used for radio buttons?

right restructuring it really isnt an option, fx are also check boxes, could you give me an example of how to write it with out producing AND. VB isnt my strong point unfortunately. thank you for your help.

Hey i have this really annoying bug, theres several tick boxes that im using to filter records but if i tick more than one i get a syntax query error? any idea what this could be? i have had several people look at the code and tell me theres nothing wrong. Option Compare Database Option...

Just wondering if theres any way of creating a more friendly way of inserting a word document into an OLE object field. Rather than right clicking and insert object etc etc. can i have like a browser button with the usual file browser? if this is posted somewhere else on the forum, please link...