Search results

I have currently got a helpdesk system setup that generates Tasks via Microsoft Outlook, the operator selects a fix within time and then the number of days allocated to the call is worked out in code. The problem we are having is that if a call comes in on Thurdsay and the operator selects a...

Thanks for your help i will give that a try!

Yes I would like the message box to appear immediately. Thanks for your reply.

I have got a Text box on a form that is used to enter in the record possition this will be used to sort the data and used in an Export. What I want to be able to do is to stop the users from entering the same number twice e.g if they enter 10 into the first field and try to enter 10 into...

Thanks for your replies, dcx693 you are right the query isn't being sorted at all, I know this is unreliable but if I were to have sorting set the output would not be what the user wants. I guessed that there wouldn't be a way of allowing the user to click the record and move it to its...

Is there anyway of setting up a form that would allow the user to select a record and manually move the position of that record. e.g. A record with the a Client Code of 111 is currently at position 10 in the table and you want to move it to position 2. I cannot use the sorting tools from...

Thanks for that works brilliantly!!!

Yes the text box is set to currency but the Text Box is displaying the Total correctly it just wont display it as Currency in the Message Box.

Tried that but still doesn't show the Total as Currency it is displayed as 556.6545 instead of £556.65. Thanks again.

Thanks that works a treat the only problem I have got now is that when the Total is displayed in the Message Box it does not display it as a Currency. This is what i have got: Dim Tot As Currency Tot = DSum("ReCharge", "qryExportTotal") MsgBox "Export Total is " & Tot, vbInformation...

Display a Query Total in a Message Box I have set up a simple query that gives me a grand Total of charges from one of another query. I don't need this information to be stored anywhere but i want to be able to display the total in a message box once I have exported the Invoices. I have set...

Thanks for that i will give that a go.

This is probably really easy but i am having trouble finding any posts with the answer. What i am wanting to do is to display an error message when the user tries to enter more than 30 characters into a text field. i have restricted the field size in the table to 30 which stops them entering...

Thanks for that i will have a look!

HELP I have found this code on another website which suggests that it might work as a sloultion i'm just a bit lost as to where i need to put the EmailSend coding?? Anyone any ideas where i need to put my code?? I would be very grateful for any help as its driving me crazy now. Thanks! '...

Pat thanks for the suggestion I have had a look at that article but doesn't seem to give any resolution to the problem, just tells you what the problems and issues are. Does anyone have any other ideas??

Thanks everyone for there help i will have a look at them all and let you know how i get on!

I have got a Database running via Citrix that is used to store Helpdesk information and allocate jobs to members of our team using Outlook Tasks. This uses the EmailSend function in a on Click event and has been working fine until we recently installed Office 2000 service pack 3 onto our Citrix...

Thanks for your help again Mile-O-Phile it is much appreciated it worked a treat!

Not sure what was going on but everything is working now, just been one of those days i think. Thanks for all your help anyway!!!