Recent content by Mermogoat

Hmm...On Dirty is listed as one of the events. it says its used before a record is modified or something. I'm using Access 2002, btw. Anyway, thanks for the help and God bless

In my form I have this code as the Dirty event of text box named "Completed." Complete is the checkbox): Private Sub Completed_Dirty(Cancel As Integer) If Me![Completed] = "" Then Me![Complete].Value = False Else Me![Complete].Value = True End If End Sub So...

Oh ok, thanks i'll try that. I didn't know to do that. Why do you need them, anyway?

Ok, when I am opening a form, in the OpenReport command, as the WHERE paramater I have the following code: "DateValue([RequestDate]) Between " & StartDate & " And " & EndDate RequestDate is a field in the query that is the report's recordSource StartDate and EndDate are variables of the Date...

Thanks for all the help. God bless

How would I reference the form field? Textbox.value = [form text field] <--what goes in there?

Then is there a way to pass text on to a Report that you are opening?

Can someone give me an example of the use of OpenArgs when opening a report? I have tried it according to the Help file, but it does not work. Thanks

In my query that is the Report's RecordSource, I have a field of the Yes/No type that is connected to a checkbox on a form. On my report, if I have it display that field, all i get is a 0 or -1 for True(yes)/false(no). Is there a way to have, as a text field's ControlSource, some kind of If/Then...

Can anyone else help me out with my second question?

Two questions: First of all, is there a way to subtract dates? I have two dates, the date a house was complete and then the current day, if I want to find out how many days old it is, how can I do that? Second, When I use OpenReport and as part of my WHERE expressions, I have this as my...

Thank you, the split function is exactly what I was looking for. Can anyone help me out with the OpenArgs paramater? Am I trying to access it incorrectly? I set a definite string in the OpenReport method, but when i try to access Me.OpenArgs I get null

Hi, first of all, when I use DoCmd.OpenReport and have a string for the OpenArgs parameter, when I try to access it on the opened report with 'Me.OpenArgs', It says it is a null expression. Also, what are the function(s) for string manipulation? In my openArgs, I want to have multiple values...

Column width works fine :) My problem is ListWidth

How can you get the current text of a Combo box? When I use the value property, it gets the value of the bound column, and when i try to use the text property, it gives me the error that the box must be currently selected. Is there another property or way I can get this? Thanks