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...

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...

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...

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])

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?

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...

=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...

How do you make a query that takes 1 input from a table then looks up the information for that row and fills in the query with the right information? I've tried a few things but the most I get is just an input of my number then a return of the whole table with my number in place of all the...

Im trying to make a pop-up window on open that will search for the conformation number of an item and take them right to that record and load all the stuff in the form that goes with it. How can I go about doing this?