Recent content by redxtb

the code is actually pretty simple but it goes to a large group and it is on a loop.. Here is the code for reference only Set appoutlook = GetObject(, "outlook.application") Set msg = appoutlook.createItemfromTemplate("\\itserver\public\SOP&A\Emails\templates\SVD20160518.msg")...

Has anyone else experienced this issue? when using vba to send emails ( i send about 1600 a day to different recipients with different data and attachments in each one.) it seems that i am only allowed to send 5 a minute. I need to increase this to 100/minute. I checked with my exchange...

need query to transpose data ID numStore cntStoreManager cntAstMgr cntTeamLead cntReceiver cntTeamMemb sumTotalLoss numDate 1 100 0 0 1 1 10 12 20141227 1493 100 0 0 0 1 12 13 20150124 2985 100 0 1 0 1 11 13 20150221 4477 100 0 1 0 1 10 12 20150328 5969 100 0 1 1 1 11 14 20150425 7461 100 0 1 1...

Jdraw Works Great!!! Thanks a lot!! can you explain a little bit? where i can use in other situations?

Hey jdraw, I looked at your link and that is what i tried to do already, but it ran for 1 hour with no results. i have 5 of these tables and need them to run very quickly. probably less than 1 hour for all. the first 3 columns is all that is really necessary in this query the others are...

I have a table that has 108076 rows and 8 fields wide 4 percents, 1 currency, 2 numeric (store & deptNumber) and 1 text. i need to rank each store(1500) by dept(74) Sales$. I have tried this Rank: (select count(*) from [qryTop10Dept] where [qryTop10Dept]![Store TYTD Sales $]>= [cw]![Store...

Awesome worked like a charm pbaldy!!!

it was something like this.... i have long deleted it now.. I tried several different ways. like adding table names to the beginnig of everything. dlookup("datFiscalMonth", "tblFiscalDates", "now() between " & datWeekStart & " AND " & datWeekEnd

I have 2 tables tblSales & tblFiscalDates. In tblSales, I have datWeekended and curSales. In tblFiscalDates I have datWeekEnd(Saturday); datWeekStart (Sunday); datFiscalMonth; datFiscalYear; datFiscalQtd In my query I want to use a criteria that uses Now() to get fiscal month. I have tried...

Thanks Namliam and arnelgp!! Both of these worked!!

now i get a parameter Value for the datWeekEnd & datWeekStart and get Syntax Error (missing Operator) in Query Express [EVENT DATE] Between and '. and This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated...

thanks Plog and Ranman!! i appreciate the help but i am not picking up what you are laying down!! [EVENT DATE] has 364 days in it and needs to know which Fiscal month it belongs to. [tblFiscalDates]![datWeekend] and [tblFiscalDates]![datWeekStart] is in a table that has fiscalmonth fiscalweek...

ok so i tried this.... fMonth: DLookUp("[fiscalMonth]","tblFiscalDates",[EVENT DATE] Between " [tblFiscalDates]![datWeekend]" And " [tblFiscalDates]![datWeekStart]") and got an #error

Trying to look up fiscal month from another table. looking at Event Date and fiscal table has a start and end date. Where is my formula incorrect?? fMonth: DLookUp("[fiscalMonth]","tblFiscalDates","[EVENT DATE]<=[tblFiscalDates]![datWeekend] And [EVENT DATE]>=[tblFiscalDates]![datWeekStart]")...

Thanks Tonez!!! I think I can tweak the code and make it work for me.