I have used the "use a form to enter report criteria" help in access, and everything works fine, except:
When I run the report I get my form up and I can enter the criterias. However when I press OK, instead of running the report, I get the standard Access "Enter Parameter...
Hi Leigh
Your advise to Dim myFile As String actually solved the problem. Allthough I still dont understand why it works on my PC and not some of the others.
Thanks
Brian
Hi Leigh
Thanks for your reply. Error message "error in hidden module".
Myfile is being defined in the first line. Like I wrote it works on my own PC
Brian
I have tool in Excel 2000, which can run a quesionaire in forms. One file has been made as a "administrative" tool where all questions are kept, and another file to run the questionaire.
Problem: When running the files on my own PC everything works out fine, but when trying to run...
Hi Neil
By duing that you copy the comment into another cell, which then has the comment as a comment. What I'm interested in is to copy the comment into another cell.
regards
Brian
Hi sohunter
Tried your second formula, and I don't have any problems in making it work. (asuming that you seperate the argumentsin the formulan with ; and not ,)
Could be your cellreferences which are not correct?
regards
Brian
I have a cell, where a user has entered text in a comment, and I want to copy the comment itself into another cell. I have tried different approaches, but none of them work. Any help appriciated.
Brian
Hi Ann
It dit'nt work exactly the same way, because I have the combobox on the same form. But if I put the Me.combobox.Request on the Combobox's own property under "On got focus" it works perfectly.
You've earned a star for this
Brian
Ann
I have the same problem and it sounds like you have solved yours by adding the WHERE clause. It works partly for me. I get the right "filter" but alwas the POC's related to the first vendor. So if I choose another vendor my form doesnt seem to be updated. Any suggestions?
Brian
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.