Search results

I have a data entry form that I want the current date to be automatically added. When I add this function to that field it returns the following error: ---------- You may have used a DoEvents, LBound, UBound, Spc, or Tab function in an expression. You may have used an SQL aggregate function...

I have a form that displays the filtered results of a search for a keyword - there is code that uses a where clause in a memo field. The keyword comes from a form that "collects and holds" the variable information. I want to be able to have a command button on the form to click and print a...

THANK YOU. I added the code to the "On Open" property and it works great.

I want to use the "order by" property within a form. However, I want it to sort in descending order. How do I make that designation? I've tried adding DESC after the fieldname to no avail. Any other ideas? Thank you.

Thank you! Your suggestion works. I thought I had tried this before without success, so I must have missed a step along the way.

The query is only based on the main case information. The subform info comes straight from that the Action table based on the linking field.

I have a subform which reflects all the action associated with a particular case. The main form (main case information) is sorted in reverse chronological order by the query that brings up those records that satisfy the search, i.e. keyword search based on file name. The subform is based on...

I have a Main form based on a parameter query for a keyword within a filename field. Within the query I sort by caseno=D as the query may return more than one record. Within the form itself, I have a subform which lists all the action associated with that caseno (master and child link is the...

I have a report that prints based on the results of 5 queries. The third query prompts w/ a parameter for the first day and the last day of the report period. Is there a way to get these two dates to automatically print in the page header of the report? FYI - Query 1 - Pulls all info...

I have several fields within my page header that can shrink and grow (mostly grow)- they are memo fields which include a filename and issue of the case. When these grow, the page header does not grow so therefore some of the fields below the growing fields are not displayed on the report. I...