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.

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

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

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

I am trying to set the Control Source for a textbox = to a function in a global module that contains an elseif calculation. When I open the form, I get the error "You Can't Assign a Value to This Object". Anyone know why I get the error? Attached is a very simple database to illustrate what I...

I want a calculation for "textbox1 (called from a module function) to execute when the value in "textbox2" is entered or changed. Which event for "textbox2" is the best one to call the function; After Update, On Change, On Exit, On Lost Focus? Is there a disadvantage to making all of these...

I created a moderately complex query, which works great. However, when I try to go back into the query in design mode I get the "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." message. To see if it was an issue with my database...