Search results

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

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

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

i have a quick question... I am having a slight problem with a query that i am using in my database... i am trying to calculate miles per gallon. The query i have set up looks at the previous records odometer value and subtracts the current odometer value to get the miles driven since the...

Hello, I need some quick help. I have a database which as a Switchboard, the switchboard can take a few seconds as its performing some tasks in the background upon intialization... What I would like is a form that pops up temporarily that says (Please Wait) The problem is, my please wait form...

Thanks for looking at my post. What I have done is this, i have built a custom search form for my access database. What i need is a textbox that shows how many records will show up if the user clicks generate form.. I want this textbox to update every time the person changes his search criteria...

My title is a little confusing, i have a form with a subform, what I want it to do is this say i have 10 records, 3 of which are missing any data in the subform... then when i show the form it only shows 7 records. This way all records have data in both the main form and the subform... is this...

This is a very quick question. I have a query what i need it to do is show me all values that equal 2 and any records that are blank, this is what the criteria looks like currently Field: Month([FDate]) Total:Group By Criteria: Month([DDay1]) Now the way this works is it only shows records...

I have a report that is linked to a query... lets say my query returns no records the report comes up with a whole bunch of #Errors on it. How do i prevent this from happening? thanks Green

Thanks for helping me out with this question. Im sure this is pretty easy to do. I have a query with a few paramaters set up... one of them runs a custom function all i want to do is this query one Average water flow:Avg([WaterFlow]) when run this just shows me the average water flow for the...

Im really stumped.. and I really need some help, Here is my problem, I have a field with a whole bunch of regular peoples names in it (user_names). Home Developer names are also in this field, it has to be this way to show if the home is still owned by the developer or moved into. What im...