Search results

Sorted it! Format(Abs(.Fields![Transport]), "0.00") Changed the Abs function round, so its included in the format.

Thanks for that Mile, works of a fashion... It now reposonds with, We Currently Owe The Client £0.4 Misses the last 0 :(

As the title really :) This is the code: ElseIf .Fields![Transport] < 0 Then MsgBox "We Currently Owe The Client £" & Format(.Fields![Transport], "0.00") & " For Transport" The message box it produces says We Currently Owe The Client £-0.40 I want to remove the leading - from...

Funny that, i've had a similar problem :) http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=252424#post252424 There it's said that the DoCmd.SendObject works best outside of the Do and Loop statements, as Travis says in the above reply, create it outside and use a function...

Well after trying, i still couldnt get it to do excatly what i wanted. So after lengthy calls to our IT department, i got them to allow me access to my computers C drive (yes, they really do block users from accessing their C drive) and from then i could create a temporary directory and extract...

Ahh, right cool! Got it thanks :)

Thanks again for the reply.... Im not getting something tho, if the SendObject is outside of the Loop, how can it send a seperate email to each staff member?

Hi, and thanks for the reply. For the first part, it has to be in the DO statement, to send an email to each different staff member. If it was outside of this statement, it would send one email only to the first record it finds. Secondly, as i said in the original post. I dont want to have to...

Hi, well after many hours of trying with the standard: "DoCmd.SendObject acSendQuery, "Appendix A Data Required", acFormatXLS, .Fields![SW Email], , , "Data Needed For Appendix A Forms", rstSubject.Fields![Subject],0" For some reason the above wouldnt work, it basically is in teh middle of...

Not sure i understand what you mean... Most of the queries were created long ago, before i knew how to use VB. Now i know what im doing there, im just simpley changing them over to the VB way of doing it. Some work off date parameter's from forms, some dont...

Dont think i explianed myself well at all then :/ What im doing, is changing the queries like i had at the start of the message, into code. All of them are either select or Make table queries. So they can be done in code, without having to have a query there too. Ok, i know the database is...

It is indeed. 70meg database too :) Im cutting it down tho, most of those queries are ones that can be done in code, which is what im doing now. I'll half that amount by the end of next week.

Thanks for the Idea mile, but in a database with over 200 queries i really didnt want to do any more :/ Finally figured it out: Set rstTeamCost = CurrentDb.OpenRecordset("SELECT [Manager Ref], Sum([Player Cost]) AS [Total Team Cost] " & _ " FROM [tbl EnteredTeams] " & _ " INNER...

Currentdb.OpenRecordset Failing :( Can anyone help me, as tell me why this: CurrentDb.OpenRecordset("SELECT [Manager Ref], Sum([Player Cost]) " & _ " FROM [tbl EnteredTeams] INNER JOIN [tbl Player] ON [tbl EnteredTeams].[Player Code] = [tbl Player].[Player Code] " & _ " GROUP BY [tbl...

Hi Thanks for the reply, clients can have more than one professional and unfortunatly they can have more than one at a time.

Hi We currently have a sytem, that well lets say isnt the best. But its what we've got so i've gotta use it! First we have a tblClient, which as you can guess is a table full of clients, it has about 70000 records in it. We then have a table called tblInvolved_Professional, and that is all of...

Is there anyway this can be converted from Bytes to MB/GB ?

Well, this has got me beat! I've got Windows XP, running Office 2000 (Full Install).. What im trying to do is install Access Developer, mainly so i can use the VBA Package Deployment Wizard.... I've installed what i think i needed to, but it seems i havent dont all that's necessary. Looking at...

Thanks for that.. But it doesnt get the Owner/Creator of the file, which is the main part we are after :(

Hi We're doing a major clean up of our network drives here, we one folder with nearly 2500 files in it, of all breed's (xls, doc, mdb, you name it we have it) What we'd like to do, is generate a list that will have the following info in it. File Name Location Size Owner/Created By Date last...