Search results

I need to make a validation rule that would allow digits and spaces - any number. Something like: Like "[0-9 ]*" but I need a '*' whose meaning is "repeat zero to infinit times" like in regexp. How do I do that? What is the repeat charachter in Access validation rule? The field is a list of...

Hello, There is an "Options" form to configure some values (prices). Upon hitting OK, I would like to run a piece of vb code that edits a query with the updates values. How can I edit a query from code? (The query is the data source of a report) Thanks Tova

Hello I made an "Options" form in my DB to edit some fields. When a field is used by a reoprt that is open, that fields in "Options" form is locked. This is fine, but the user has to know why is it suddenly locked. How can I make it pop up a message when the field is locked due to report that...

I am getting "Query is too complex" when I try to open a report. The DB was working fine, but 4 values that were hard coded really needed to be soft coded, because a. they repeated themselves in several queries and reports, and b. they need to be configured easily in 1 place. So I made a new...

Hello "Detail" section in my report contains 1 field. It results in a list of names. I would like this list of names to show up in 3 columns. That is, there are the header and the footer of the report, and in the middle, there is the "Detail", which is a long list of names, and it would be...