Search results

Thanks gents. I will try the solutions on monday.

Hi, My company receives order strings. Order codes that are comma separated. I also have a set of validation rules to validate the order string. So i do the following: Extract validation rule and split codes into an array. Lookup the validation codes to see if they are in the order...

Hi the returned result should only be boolean. For example: bool = (False Or True) And True And (False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or False Or...

Continue button is disabled. The field is long text so cannot set maximum. Should I be setting record and field validation rules for this? Are there alternative functions to eval()

Hi, Getting failures when the string length is very long. What is the maximum string length eval() can handle? For example runtime error '10025' is flagged when the rule is..... (False Or True) And True And (False Or False Or False Or False Or False Or False Or False Or False Or False Or...

Hi, Hi Eval worked a treat. Top man thanks!

How do I store it in the ODBC settings?

A VBA text string so: Dim string1 As String Dim result As Boolean string1 = "(True Or False) | False | (True And False)" result = string1 So in this case result should be Boolean True

Hi All, Hope you are well. I am looking to solve a string containing a textual Boolean expression. e.g. I want to solve Boolean result = "(True Or False) | False | (True And False)" How can I do this?

Hi, Thanks for your response. I am looking for my access file to autoexec the download from the ODBC tables on open. Unfortunately every time I open the access file on the first use I have to enter my password at the prompt. I want to automate this so it logs in on file open. My company...

Hi, I use linked ODBC tables to access tables on a server. I run queries to download fields I need from these links. It requires a login which I want to automate in VBA code. How can I automate this so I do not have to login all the time? Many thanks.