Search results

Thanks namlaim! I'll clean it up... :) When I tried the pass through query it would "create a copy" of the linked table with "1" at the end. I'm sure i was doing something wrong... I added two screen shots of the pass through query. Where am I going wrong on finding the ?

Done! Thanks David! :)

Absolutely....Take a look and let me know how to improve it. I'm working on getting the "strWhere" clause correct so that I can search by Year & Hospital OR Hospital, Unit, Year. Unit would be optional. The hardest thing after the kick in the right direction was writing the SQL code in VBA...

I have learned much from you master jedi... :) 4.9 seconds... And I thought 14 seconds was AWESOME! Thank you!! I'll add some bells and whistles and hit you if I have any more questions.

new table fields screen shot

IN CAN GO FASTER!?!?! Teach me jedi master... :) In the SQL mgmt studio I converted everything to a number except the Hosp (text) and Unit(text). I took the date part 'year' and 'month' out when I created the view. HD_summary is a linked 'view'. I will modify the vw to only include the...

What is it doing? Did you assign a code to the option group THEN rename the option group? That would cause the code behind it not to work.

OMG..if I could kiss you I would. I fixed it all and now it takes 14 seconds...no I don't think you heard me right. 14 seconds!!! (when linked to the SQL server) Thank you, Thank you, thank you!!!

you have to put an "IF" statement on the report when it opens. if me.yourtextbox = "Open" then me.yourtextbox.backgroundcolor = #FFFFFF End if if me.yourtextbox = "closed" then me.yourtextbox = #A5A5A5 End if

Ok...I apparently suck at VBA. I thought I understood what you were telling me to do but something isn't firing in my brain. I have created another form HD_SummaryR2 with only the first row on it, because i want to make sure the VBA works before I spend the time creating all of text boxes...

Based on the query of the form you wanted to make sure that the product ID didn't "duplicate" for the customer. Some how you have to put those records together in order to make sure the customerID and productID were on the same orderline. I did that with your queries...they basically created...

alrighty then...I'll give it a go and get back with you. Thanks! i believe if I can solve this one then I'll be able to apply that to the other reports!!

Try this...I think it is what you are looking for.

Hey namliam!! Hmmmm....yeah when I run the query linked the time is much greater. They will be using it quite a bit...depending on how many hospitals they are assigned. I did the sum on all the fields in my query and grouped by Year, Month and Hosp. (now they want Unit added) How...

Try going to compact and repair then put it in a zip file....if that don't work I'll message you my email.

Could you post a sample of your DB?

Try this thread and see if it helps point you in the right direction. http://www.access-programmers.co.uk/forums/showthread.php?t=200376&highlight=Duplicate+Record

Hi DCrake, Thanks for the prompt reply and I shall try it out....Is there no way to put in the DSum() function? for some reason I thought there was... I have a related question about my "approach" to this task. I'm attaching a sample DB so you can see what I'm working with on the "after...

Hey everyone!! I have "hopefully" a quick one. I have below code and need to add one more parameter to it however that parameter can be "null" if they don't want to choose the unit. Nz(DSum("[DonorCnt]", "qHD_SummaryR1", "[Month] = 1 AND [year] = " & Me.cmbyear & " AND [Hosp] = '" &...

could you post a sample DB? Welcome to the forum!!! this is an awesome place....