Recent content by jastek

I want to put a check box next to a memo field that automatically gets checked if the text entered is too large to be visible without scrolling down. In other words, if the text entered into the memo field overruns the visible size of the memo field, then a check shows up next to the field...

2 questions: Is there a way to make the verticle scroll bars on a memo field always visible, even if the field does not have focus? Also, is there a way to prevent the verticle scroll bars from showing if the contents of the field fit the text box? I want the user to be able to just look at...

I have a DB, which is password protected. I am looking for a way to have the program automatically change its own password after a certain date using code. Is this possible? I know that you have to have the DB open in exclusive mode to set the password, so this may cause a problem.

Rich - That did not work. That gave me a whole new set of errors. Mile-O-Phile - I have extracted the relavent parts of my actual db and set up a db showing what I have (Attached). If you can fix this, that would be great. You may find that I have totally screwed this up and there is no way...

Rich - I was typing my reply at the same time you were, so I did not see your post. I will try it as you indicated. Thanks.

Mile-O-Phile - The example db I posted is much more simplified than my actual db. The if statement is much more complicated and needs to be done in a function. Assume, for the pursposes of this thread, that I cannot simply put the calculation directly in the query grid and I must use a...

I am trying to use a function in a query to calculate a field's value. When I open the form, which is based on the query, I get the error "You entered an expression that has no value" I think my syntax in the query grid may be incorrect: DayCountResult: CountDaysToFinish() Here is the...

OK. I have created the new query and based my form on it, and created a new field that calls the function. When I open the form, I get an error "You entered an expression that has no value". What am I doing worng now? I think it has to do with the way I call the function in the query. . ...

My form is based on a table and not a query. I know this is not correct, but I started this db before I realized that. Is there still a way to do this, even if my form is based on a table?

Back to my original question; how would I call a function from a query? The example I am using in this thread is much more simplified than the db I am working on. The number of days calculation involves 3 date fields and multiple conditions, which has to be done by a function. In looking at...

Where would I put this code?

I guess I am not explaining this clearly. I have a form that has 2 date fields; [dtInitialized] and [dtFinished]). I also have a field (unbound) that calculates the number of days between [dtInitialized] and [dtFinished]. If there is no entry in [dtFinished], then the calculated field shows...

Because the number of days changes every day. The calculated field not only shows the number of days it took to complete, it also shows the number of days as work in progress if it is not finished.

Yes, you are right. The field should be unbound. I do not know why I am using an update query. What is the best way to go about this? I need to be able to update all the records at once, as well as be able to run a report showing the updated values.

1st time trying an update query. . . I am trying create an update query, which will update a calculated field that shows the number of days between two dates on the same form. I created a public function that performs a DateDiff calculation for the field. How do I call this function from...