Search results

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...

Never mind. I put an if statement at the end to make values < 0, = 0 Problem solved. If anyone knows of a way to make DateDiff do this automatically, I would like to know how.

I will create an update query and run it at startup. Why should I not be storing values in my table?

That works fine, unless I am comparing two dates that are together. Then I will get a negative number. start date = 5/1/04 end date - 5/2/04 Date Difference = -2

Can you make the DateDiff function exclude the start and end dates? example: start date = 5/1/04 end date = 5/3/04 date difference is = 1

Doc_Man - Thanks for the info. I will aproach this from another direction. Just one more question. How do you make all records update at the same time? I want all of the records to recalculate before I run a report, so the information is up to date. When I call the function that...