Search results

I'm not sure but I think that IsDirty event was new with Access 2000...if you're using 97 or earlier I don't think it is available.

All right, another question... Is there any case where neither form would be loaded? :)

Ally, I'm not sure (then why is he responding, you ask) but, the If statement below doesn't see to have any value for the false result...for true result you indicate the value as frmepisode.unitno but for false the value ends with the other form name and no value... [B] Shouldn't there be a...

Mademois elle I didn't see any attachment...did you forget? Dennis:)

Good question, Rich. In order to include the year, you would need to variables input. (datepart("yyyy",[PlannedDeliveryDate]=[Year]) so the complete statement would contain both datepart functions connected by AND The prompt for the year would come after the prompt for the month. Thanks!

Cos, I noticed your question...that's partly what made me think of that solution...:)

Another option is to set the following criteria in a query that pulls your [PlannedDeliveryDate]: (datepart("m",[PlannedDeliveryDate]=[Month]) In this scenario the user would be prompted for the number of the month (i.e. September = 9, October = 10, etc.) The query results would only contain...

Thanks, Auto Unfortunately, that method changes the color on all of the records. I will take a look at the download mdb when I get home this afternoon and see what code might be there to help.

Macros work for this.... Sir Don, I have used macros to accomplish this task. Use the OpenForm action in the macro to open your main form and set the where condition to: mainform.refno = prevform.refno Then add the close action to the macro to take care of closing your first form. When you...

Open form where... Homer, The way that I have done this in the past is to tell the new form to open up with the parameter set as the where condition. I have done this successfully with a macro...using the OpenForm action and setting the Where condition to: mainform.textbox = myform.textbox...

You can also use the TRIM function to take out any trailing spaces. For instance: =Trim([Address1]) =Trim([Address2]) =Trim([City])&", "&([State])&" "&([Zip]) In the body of your letter, just apply the same function to the text field. If it is null there will be no space there. I think:-) Dennis

Event code for New Record I concur with Hayley's suggestion... the code there is what Access puts into the OnClick event when you build the button using the wizard.

Hi, all...this is my first post here. I'm trying to figure out how I can highlight the current record on a form in datasheet view. In otherwords, change the backcolor on the fields in the CurrentRecord. I have tried a coulple of things but Access changes the back color of all the records...