Recent content by bass_twitch

Thanks, simple and I don't know why I didn't think of that *facepalms* It is now working with this: CumVal: FormatCurrency(DSum("[PV-PlannedTotalExpenditure]","qry_ProjectMonthlyPVCalc","[ProjectID]=" & [ProjID] & " And [Mth_Yr]<=" & [MthYr] & " And [Yr]=" & [BaselineYear] & "")) Also it...

I guess I have stumped you all :)

bumpity bump?

No ideas? :(

Hi all Firstly, thanks for all your help on my last issue, :D I've got another one that I am trying to solve now. Ok so at this moment in time I am using a dsum forumla to calculate cumulative totals based on both individual projects and time in some of my queries. And this is working...

Got another one for you all now, Whenever access tries to send the emails, outlook wants my permission for each and every email sent. (i.e. I have to click 'allow'), is there any code that can automaticalyl either bypass or 'allow' each email without human interface inbetween each one? Thanks

Hmm it wasn't, but now it is and it is working beautifully :) Thanks mate

As above .

bumpity bump?

Ok so here is my code: Private Sub IDcycle3() 'On Local Error GoTo Some_Err Dim MyDB As Database, RS As Recordset Dim strBody As String, lngCount As Long, lngRSCount As Long DoCmd.RunCommand acCmdSaveRecord Set MyDB = DBEngine.Workspaces(0).Databases(0) 'Me!txtProgress = Null Set RS =...

333333333333333

222222222222

11111111111

Thanks mate I jus tried dumping that in to no avail :( I might just spam a couple more posts, so I can then post my code :)

i.e. is there a cmd that says: wait until [blahblah] cmd is finished, then proceed?