Search results

Thanks Very much That was nice to see some examples. Funny how i didn't get them on my forum search? Thanks a lot Huk

Tried this and I tried that code but i AM getting a run time error 429 "Activex component can't create object" In Debug the following line is highlighted Set EmailApp = CreateObject("Outlook.Application") What can I do?

I Would Like TO See An Example BukHix you seem to be up on this please post an example of some mailing code

OK I know its possible to mail reports etc but it seems that the user will always be aware becase either Outlook or Access pops up a send message box. So if you just want to send a message e.g. "Till Cash does not Balance with Cash book" Does the user have to be aware? Appart from the fact...

cool So does that return zero 0 i'll go try it

Thanks Neil Th NZ() Is cool to know cheers.

you got it one was not defined correctly thanks

it don't like it And im still getting #Error

OK If I have to So I can't use Sum and a range or anything ? Im sure I once used something like that in VB5. OK it will have to be the +'s Ta!

I have a form with 8 textboxes which are unbound and have calculated values. Can I sum them. eg text1 to text8? How?

Almost IMO spotted the "" missing but now I get a new message box appear so I have to click Send and I dont want the user to even know this is happening . And if you don't mind another slight prob. after I click send Im getting this error Fr4om Outlook express. " The connection to the server...

I've been trying to get this and am missing something. Reading others threads I get the idea that its possible to send a report using code something like this. DoCmd.SendObject acReport, "CanInvs", snapshotFormat, "email@wherever.bla" My debugger wont have it but i cant see whats wrong. This...

Success It Was My commas not enough before acDialog !!!!!!! Thanks chaps

Have Tried, but wont give up! I have tried the acDialog and set form property to modal border style to modal. but NO. The form is called from withing a Public Function. If that is relevant? Even as modal the form opens but I cant see my buttons it is like a blank form with record selectors...

I have a form which has 3 buttons. onclick each button sets a variable strDur to a respective vale 1,2 or 3. My code calls the form using Docmd.open form The form Opens But before I can click a button the code continues to the next step. I want to wait until the button has been selected then...

I'll take a look OK Thanks for your help I'll give that a go. It will be a shame to have to go back to thelast working version I did lots of work on form colours (conditional formatting and stuff!) Fingers crossed. Cheers.

I Have a form which hosts 2 sub forms both based on different queries. I Had to add two Fields to one of the tables which one of the subform queries is based on. After doing that My Host form will not open and I get RTE 2501 "The OpenForm Action Was Cancelled" Any Suggestions? :(

Why Cant Access find my form? 1. It does Exist in the DB - I can Openit from the DB directly and I can see it in Project explorer. 2. The spelling is exact - I have checked this >= hot diners. 3. I have used the same method to pass an ID to an Unbound field in other forms and it works. :-...

No And No :) No still cant find it with full names and {tid} is the name of a field in the subform (based on query of the Orders table) "does that make a difference", [TID] is the ToolID in that Order record. So am looking at a form with cust details and subform of orders. if click button in...

Both on Subform Both [TID] & the button are on the subform. What did you mean before about Using the name of the [TID] control ? the form/subform names as i showed last or have i got the wrong end of the twig?