Search results for query: *

Im using a Form with 2 other subforms inside of it. Im working with the 2 subforms inside and recently I got the code to make them update dates when I changed the number and dates in the milestones. But the problem is it only changes when I click on the field that I have the code in. Ive...

Private Sub days_after_AfterUpdate() If IsNull(Me![Combo119]) Then Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due]) Else DLookup("[Miledate]", "Mile1", Me![Date Due].Value = Me![Combo119].Value) = Me![Date Due].Value = DateAdd("d", Me![Seq]...

I want to put a java script in the background code that runs when the message is open anyone know how to do that?

How do I get the VB to read whats in the combo box with out making it an = "blank"? Heres what Im using: If IsNull(Me![Combo119]) Then Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due]) Else DLookup("[Miledate]", "Mile1", Me![Date Due] = Me...

Does the SQL work in a VB coded if statement? if so how do I get it to look in SQL from there. This is a form its going to/from as well.

AHh yea good idea. Thats why I come here heh. Thanks alot.

Im using this line here: DLookup("[Miledate]", "Mile1", Me![Date Due] = Me![Govt]) And it wants me to enter an object for Me![Govt] so it looks like this Me![Govt] = "PPR1". Im trying to get the Dlookup to lookup the value thats in the combo box because theres a...

It looks like one of those 2 will work. Thanks alot I just wasn't sure how to get it to read a null value if there is one. Ill go try those out. Thanks again.

Im trying to write an if in VB that will check a combo box and see if its blank or not and if so go onto one of the other statements. Anyway is there a way to do that? If Me![Govt] Is Null Then Didn't work so Im assuming theres a special way to check combo box's?

Anyone know what would cause the Excel program to lock in portrait view. I cant figure out why it is locked in Portrait view and wont change to landscape. Several of my office mates are also having this problem anyone have any idea what would cause this? It doesnt matter what excel worksheet...

Oy, nevermind silly me. Forgot to take the brackets [] off the Me haha.

Other than the obvious 2 forms and fields which I have checked and are there it seems to think theres a field called forms somewhere. Can anyone tell me why it thinks that from this code? [ME]![Date Due] = DateAdd("d", [allTracking]![Seq], [ME]![Milestone])

If Is Not Null([Me!Combo119]) Then Me![Date Due] = DateAdd("d", Me![Seq], Me![miledate]) still gives me an error on the Is Not Null part, had to change it around to this before it would accept. If Is Not Null Then Me![Date Due] = DateAdd("d", Me![Seq], Me![miledate]).

I'm using this string here to do a date update for a form in a subform. If Me![Combo119] Is Not Null Then Me![Date Due] = DateAdd("d", Me![Seq], Me![miledate]) The problem is the first part of the string says it needs an object, "If Me![Combo119] Is Not Null Then&quot...

This should be pretty simple but its just not working for me. Im just trying to multiply a cost * Days type thing and get a total in a query, But it isnt putting anything at all. What command do you use in a query to multiply stuff together?

Okay thanks, Ill look into it.

Im fixing a database and this is the only thing I cant figure out. Its supposedly code to take a number of days change +/- and then recalculate the date's due for any documents with the same milestone number. Any ideas on how to do that or what this actually does would be appreciated...

Thanks a lot, I'll go give it a shot now.

=DLookUp("[suppl]","MAKEBUY","[part]=Forms![Change Board Records]![P_N]") Thats the line I'm trying to change to use in a report for the same information. I tried to change it to this: =DLookUp("[suppl]","MAKEBUY","[part]= Reports![CBR...

Actually nm, I figured it out I was doing it in the wrong place. All I had to do was put it down in the Criteria [Look up LC] and it worked.