Recent content by cynaptic

Is it possible to set the contents of one dropdown based on another. i.e. populating a second dropdown based on the selection made in the first?

Philipe thanks for this If I understand correctly this is building an sql statement on the basis of a set of IF statements, please could you explain the process a bit. I am not sure I understand. sorry to be so slow but am only on first coffee. Alex

I am trying to create a form that will accept multiple search criteria using the following SQL statement. However I am not sure of the SQl or how to create the form. Any help/tips/divine intervention appreciated. The idea is that the form will select records on one or more of the parameters...

Thanks a lot guys - looks like both sites have lots of useful resources. Cheers Alex

Can any one point me in the right direction for tutorials on word templates. What i am tryin gto do is create an appplication that will drop text typed into a TextBox into the desired feild in a word template. Forstly is this possible, secondly where should I start looking for examples...

Jon You are absolutely right, it was the dreaded fat finger syndrome. the whole thing works like a dream. Thankyou so much for all your help ith this. This was My First VBA Application, and I couldn't have done it without you. I hope to be able to return the favour to some poor struggling fool...

Jon I have tracked down the problem line. I am going thru the code in debug and it is one of the fields that is causing the error. The field is null, however I don't understand why it choked all of the preceding fields went through including some null fields. Will an error occur if the field...

Jon Thanks for that. Again seems to work and the pops an error - 3265.Item not found in this collection is this a problem with the path or resolving the fields? Sorry to take up so much of your time but am DETERMINED to get this to work. Alex

Jon Thanks so much Jon, it is working fine, looks like its going through but then pops and error : 3001:invalid argument Sorry to include whole code again but I am not sure which bit is causing the error..... I feel so close to cracking this - it is almost painful! ***** Option Compare...

Hi John Thanks for taking the time, however i should have mentioned that i am working in a 97 envirenment and thats why I was using DAO not ADO. I don't know the ins and outs but have been told that 97 prefers DAO to ADO. Alex

I have taken this code and tried to modify for a small project. I am not a VBA wizard and have come unstuck. The following code produces a compile error "type mismatch" - I don't know what that means, could someone please enlighten me and suggest a solution. This seems to be the...

I have taken this code and tried to modify for a small project. I am not a VBA wizard and have come unstuck. The following code produces a compile error "type mismatch" - I don't know what that means, could someone please enlighten me and suggest a solution. This seems to be the...

http://www.elementkjournals.com/ima/0104/ima0141.htm

a big thanks to all of you who answered this question... I have found an article which covers the subject http://www.elementkjournals.com/ima/0104/ima0141.htm

Pls excuse xpost on Access Modules but not sure where to go for this one:) Is it possible to set up a form in word and then ,collate all information into access. I am pretty new at this but feel sure it can be done. Just not sure how to start. How do you set fields as named text inputs in...