Recent content by greenfalcon

wow, thanks bob.. you have always been an amazing help. Thanks again for the support. Ill keep trying to find out if it is possible. Jason

Ok.. thats not it either, thanks so much for your help... maybe i can better explain by showing you a working example with an array The code below, if you test it, allows me to refer to an array with a variable... maiking it easy to pass more arrays to the function. I would like to do the same...

Maybe i can re-write it so it makes a little more sense Sub test() tmpResult = updateValues("Name_of_Variable1") tmpResult = updateValues("Name_of_Variable2") end sub Function updateValues(Dim myValue as ??) myValue = 1 + 2 + unknownFactor End function So in turn the sudo code would something...

That is correct, I want to update the variable that i started with...

I will attempt and keep this short and sweet, I essentially have a lot of code that is duplicated within a case statement that updates the values of separate variables before performing computations... my question is this, i would like to be able to pass the function the name of a variable and...

I have a slight problem. I have a form that is controlled by vba, it starts out on record one. it then uses dlookup to check a query this query is looking at the current forms date text box. it then retrieves the value that i am looking at, the vba then moves to record two and peforms the...

MVP = Most Valuable Programmer!!! Thanks again!! Jason

Hi all, Quick question... i am trying to grab the nearest date using vba... I have two tables... (Table 1) 2/1/2008 3/1/2008 4/1/2008 and (table 2) 2/20/2008 2/21/2008 3/21/2008 What i want to be able to do is if someone is looking at value 3/1/2008 in table 1, it would show the date...

here is one last question... how do i modify your query in order to create a running sum by month? Ill try to figure it out myself and will let you know if it works... thanks

Wow that was amazing pbaldy... i worked on this thing for 8 hours yesterday and couldnt figure it out and you do it in only a few lines of code... I am going to have to put this code in a vault... a vault wrapped in gold. I don't think many people have an easy time with this concept... i find...

Ive got it working by making another query and referencing that one... However, since i am trying to create a running sum i seem to be having some issues. I want to be able to create a query which shows everytime a debit or credit is being made. Currently i can only get running sums for months...

Thanks, ill check this out! I will get back to you after i check it out. Have a good time with you.

Here you go, this should work

Here is the sample database... (Its actually a Rar file) you can see what im trying to do... internal_fuel_summary_3 is the query i am trying to get working... cur_Value is the field which should be taking the running total and subtracting the used gallons and that should equal the current...

Hi all!, i would really appriciate it if you could help me out. I have this complex query... in one table i have dates and costs associated that show when fuel was put into the system such as: 1/1/2008 -- $200 1/20/2008 - $100 1/25/2008 - $150 I then have another table that has data when fuel...