Search results

ah ok thanks, if i could read i would have noticed that i used the wrong date and that was the problem Thanks.

If (Me.WCB_Valid_Date < #6/30/02#) Then Me.lprojno.ForeColor = 255 Else Me.lprojno.ForeColor = 0 End If I now think perhaps my comparison operator is incorrect? Can you even test dates in this manner?

I want to make it so that for each record it does a test and if it passes this test it will change the font of a text box one would think the onformat event crap would be where i would look but i dont seem to have any luck making it work any ideas?

I am trying to do a simple compare on my report in a text box. I have the following code in my control source but it is returning #ERROR on my report: =Iif([WC DATE] < date(), "Date is in the past", "Yeehaw") do i need #'s or something?

guess thats the problem. i have 3.51 oh well

Ok thanks hayley, any idea whats going on in my above post?

anyway regardless of that i am getting an error: object variable or With block variable not set here is the lines of code, ssql is a select statement and it is set i just took it out because it was so long Dim ssql As String Dim stDocName As String Dim mydb As Database Dim...

I realize that but does it matter if it exists? will it just overwrite it or will i run into problems?

Is checking to see if the query exists important? Even if it does exist shouldnt it just over write it anyway?

I have a report made which is all laid out how i wish it to be. But i want to change the query of the report to something new based on a users input in a form. I know how to create the new query, but i do not know how to apply that new query to my old report. Is this possible?

I have a report made which is all laid out how i wish it to be. But i want to change the query of the report to something new based on a users input in a form. I know how to create the new query, but i do not know how to apply that new query to my old report. Is this possible? Sorry I will...

thanks alot.

I have a string variable declared and i want to assign it a long string value. I had thought it was done like this: string = "line 1" _ "line 2" _ "line 3" but this does not work. Is there a way to put in a long string across multiple lines?

thanks wayne, that is perfect

Hmm yeah i guess i could. But that seems to prompt the user about deleting data, which i dont want. Isn't there an easy way to do it through a block of code? Using a for each statement perhaps? All i want to know is how to reference a table in VB

I am trying to create a function that will look through a table, and if it finds a blank entry for a certain field, it will delete it. I just don't know how to reference the table in order to scan it and modifiy it.