Search results

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.

Really not sure which way to go with this new requirement and need your help in deciding what is the best and easiest way to accomplish the following... Currently have an Access db filled with different departmental information. Trying to build a workflow mechanism that will validate the...