Search results

All, I am trying to correct the punctuation around my query criteria. In the QBE window it looks like this Like "U" & "*" Since the value U will vary, I declared a variable CriteriaStr = " """" & rstSelected!SurveyType & """" & """""""" " My SQL statement looks like this st5SQL =...

Thanks Pat, Adding the quotes worked like a charm!

Hello, I have coded a basic append query to add a single record to a table. One of the fields I am adding to the table is a hyperlink and it is producing an error "Syntax Error in date in query expression '#http....#'. Here is the query: DoCmd.RunSQL ("INSERT INTO Docs (DocID, DocName...

Hello, I am trying to manipulate the CanShrink property of multiple textboxes on a report using VBA code. Is this possible? In the detail section of my report I will have textboxes containing Null values. Some of these boxes need to shrink while others should be visible and full size. I have...

Thanks to Pat's advice, my problem is half solved. The detail section of my report is set up in a three column 'table' where the borders of the text boxes joined to form the table's grid lines and by separating the text box borders they now shrink when null. However, if the record is not null...

I am having the same problem. I have set the can shrink property to yes for the detail section of my report, however a large blank area appears when I preview. Any suggestions? Thanks In advance.

I have looked high and low but I cannot find a filter of any sort attached to the report. Any other suggestions??

I am trying to populate a report and a form with results from the same query. Currently, the user enters the criteria of a parameter query and a form opens displaying the results of the query, one record at a time. I have a command button on the form which opens the report. However, the...