Search results

I have a subreport which consists of a text box which runs a query based on the main report and presents the data with labels. Here is an example of the expression: ="Alteration 1: " & [alt1] & " " & [alt1_int] & " " & [alt1_com] & " Alteration 2: " & [alt2] & " " & [alt2_int] &...

First, I went to the property for each of the boxes and changed the visible property to No. I thought this would make the box not visible when the form was opened, but it didn't seem to change anything. As for why I am doing this. I may be going about this incorrectly but it was what I came...

I have text and combo boxes on a subform which I would like when loaded to not appear on the form. They are automatically updated from other boxes on the main form. I tried setting their property to Visible=No and this did not work. Then I tried the following code in the main form load event...

I have a subreport within a report with vertical lines. My problem is that the vertical lines only extend to the end of the detail section. I need the lines to extend to the end of the subreport even if the details do not go that far. Here is the code I am using, it was writen by someone...

Sorry about that.:) Here is the code which I used in a command button. It exports the excel file to a specific location, with a database field as the filename (references a form). I converted my macro to code. So what you are seeing is a few queries running then the actual export of the...

I figured it out. Actually easier then I thought, now that I know how to do it. Cheers, Pam

If you add a date field to the database table you can run queries to extract the information by month. You would place a criteria in the date field of the query. For example "Between [Start of Month] and [End of Month]".

I have been looking for a solution to this for some time and cannot find anything. I know I'll have to do this in code, but do not know what to write or where. I have a report generated from queries which I need to export to a NEW excel file, I need the file to export to a specific file...