Search results

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?

Thanks to the link that was posted above (thanks :) ) I've managed to use that to create a process, and it is working to an extent.... HOWEVER It is sending the email to the previous record's email address!... Help?? Essentially it is not updating the records before it tries to send the report...

I am trying to reply, but because I have <10 posts it is not letting me post (it says I have email addresses in my post.. even though I do not. I only have the words 'email address'

bump? .

Hi mate Thank you for your reply It is good to know I am on the right track with it. I have been giving this a bit of thought, and this is the way I was planning on attacking it: 1) on the click of a button it runs a loop that: a) replaces the first/next projectID into the cboID on the...

Hi all I'm still very new to the Access/VBA scene, but I have managed to copy,adjust and fumble my way through the creation of some smarter forms/reports in this database. However I have just been assigned to create a 'magical email button'. Ultimately what I am looking to do is this: On...