Recent content by RyanBurns

Got it to work. I passed my string parameters through this function: Public Function DBStringInput(ByVal Value As String) As String Dim strValue As String strValue = Replace(Value, "'", "''") If strValue = "" Then Return System.DBNull.Value.ToString Else Return strValue End...

To be more precise, using '' inserts or updates to an empty value, but the '' itself does not reside in the database. It's just a zero length string. Which is fine in a regular SQL statement, such as: UPDATE table SET stringfield1 = '' WHERE id=1 However, the difficulty is when passing...

I'm using ASP.NET with a Microsoft Access 2003 database. In trying to pass values to a parameterized query, I get the following error: System.Data.Oledb.OledbException: Parameter [@ParameterName1] has no default value. The underlying query looks something like this: UPDATE TableName SET...

Yeah, that's my whole problem. Can't put text boxes on the page header to show my data. I can only get them on a top level group header, which I cannot get to print on each page if the group spills over onto multiple pages.

Please help!! I'm working on a report that needs to have a header print on the top of every page. I tried the idea of labels on the page header, but can't find any way to populate them dynamically with recordset data. So, I moved to the idea of a group header. That works fine, unless my...