Search results

hey i have the below code to store options on a list box as a query if some1 can make any recommendations they would change to this would be nice. also how would i make this into a function so i could use the same code on various listboxes for different queries or am i better just changing it...

paul thanks, so if i store the results from my listboxes in a query would i say for filtering by department ITEMTBL.ITEM_IDEP in qryDEPT? and then would this work if i wanted to say do department and group by using strcriteria = "ITEMTBL.ITEM_IDEP in qryDEPT AND ITEMTBL.ITEM_IGRP in qryGRP"...

I have a where clause in a report that works fine across numereous combo boxes Dim strWHERE As String 'set where criteria to nothing strWHERE = "" 'set where conditions for sql 'if dept combobox not empty filter by dept If Forms!frmITEM.comboDEPT <> "" Then strWHERE = strWHERE &...

sorry adam meant Record (like record a movie) :) as in store my filter options for each period.

thanks adam, any idea how i would then for that same form which has text boxes and comboboxes. record each list of options for different comparison periods?

so aje that will work even though i am closing the form after each time?

hey guys I have a form frmComparison with caption header to start with of the below code Dim P As Integer P = 1 Me.Caption = "SALES COMPARISON PERIOD" & P i have a button on that form that closes and reopens that form called cmdNEXT what i want to happen is each time that next button is...

paul never mind figured it out :) silly add on the strEMAILADDRESS thanks again mate

sorry paul one problem with my current code i am getting multiple emails to each email address the number of emails relates to the record number in the table so in a 4 record table first record gets 4 emails 2nd record gets 3 etc. any ideas?

paul that worked brilianlty by opening the report with the criteria then emailing it:) thanks mate.

paul thanks i am trying the following and just wondering how i would get the strCriteria to work on emailing the report, it works fine if i run using the report open but i really need to email it. any suggestions? Dim rst As DAO.Recordset Dim strEmailAddresses As String Dim stDocName As String...

hey what i am trying to do is i have a report called rptTILLTOTALS that contains sales information for various stores. (Grouped on STORE) What i am trying to do is to email this report to the relevant people for that store. So i want user1 who is in store1 to get only there results and so on...

bob thanks but that isnt really what i am after am more trying to figure a way to create a query of values which will be Day=Datediff(fromdate,trxdate),Value(i) where i is the amount of times that form has been run for that report. So say i had run the report 3 times with each date range being...

im just wondering if they might have a raid setup on that server of theres so might try another pc.

bob ok did that the version i am running is 12.0.6211 and they runtime is 12.0.6304 so to me that means they have a later version :(

bob silly question how do i find in access 2007 where the "ABOUT" details are still trying to find some stuff compared to other versions of access. But i think you might be onto something there :) so how do i do that?

hey guys i thought i posted this thread yesterday but dont know what happened to it. i am using the attached code in a form to obtain the hard-drive id and mac address both to be used as a little bit of protection (I know it's not bullet proof but the people who are using it arent that bright)...

Hey guys i have a form called frmCOMPARISON (Screenshot attached for a better idea) this form and its subform contain a series of comboboxes and txtboxes that i want to use as filters on a query to compare data from various periods and other options. what i am wondering is how do i get it so...

Paul attached is a screen shot of the form this might give u a better idea of what im trying to achieve.

paul thanks but what i really want i am trying to do is to use this for a comparison report so for e.g. in the first options i want to choose location 1 for date period x then compare to another set of options e.g. location 2 for date period y i want to be able to repeat this until the user...