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

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

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