Search results

Re: Error 2046? - THE SOLUTION :) I have been struggling with this all day when installing onto new computers. It turns out you can easily fix it by installing outlook from the office disc, leave it installed and just change the default email program back to Outlook Express. Fixed.

search for "docmd.sendobject" this has a lot of options and can send using cc etc. a lazy way of doing it without access would be to setup outlook with some message rules to forward to whoever you want - leave message on server etc etc and can run every 1min so there is no user action required..

im not sure on exactly how to write it but a messy method that would prop work is to place your sum on the main form not the subforms. if you search the forums for a select record method you will find some methods on landing on a specific record this may then have to be put on the after update...

Ok heres one im stuggling with... I am using a sms service and trying to mass sms the mobile numbers i have stored in a table. Only problem is the sms code understands to look in a particular text box on a form for the numbers each seperated by a comma. i.e. 07979 797979, 07979 079797, etc, etc...

u r a star u r a star as always :) thank you

:confused: I have 3 identical fe be database running each with a table called cars that has identical form values just obviously different data. I want to create a table or query to display all the results from these but whenever i try and make a query i cannot seem to work it out. Anyone got...

I have just got my head around a aggregate query to count the number of results of a certain date using the search here on the forum but . . I was trying to count all dates by the day of the week? There are over 1000 dates but i was hoping for a query with 7 results showing how many on each...

Was being stupid - just figured it out - i will sum the 0 values and minus from the qty in the sum.. Thanks for looking

I am trying to create a field that displays a count on all records which are 1 or above. I was using =Sum(IIf([financecompany]="Black Horse",1,0)) to count individual companies but i am trying to use the value field instead. I searched and found a thread using...

If it is a reference database have you considered a data access pages and making it available on the web?

Excellent DateDiff Thank you Jon K that is a cracking bit of datediff.

thanks for your reply. I am looking to automate an invoice generated each month which charges for the working weeks during the month (or between dates), i cant seem to apply a working days calculation to get it to work?

I think i am missing the obvious but cannot seem to get this one.... I am trying to get my form to return a value of the amount of working weeks in a month i.e. a 4 week month (like june - 4 mondays) or a 5 week month (like may - 5 mondays). i can calculate the number of full weeks using the...

Im sure the guys on here would not approve of writing the form in this way but the end resulting report on the data would be ok to make it look the same so they have got some familiarity.

solution - - overtype the long date format in the control panel / regional settings section to dddd, dd MMMM, yyyy

Aha ! made a partial break through - if you change the regional settings to United States the day then appears, however change it back to United Kingdom and it disappears ???

Its access 2000 on windows xp pro. I have another pc here running access 2000 with xp and that doesnt show it either.? Nuts?? :confused:

I wouldnt worry too much - I have done many little programs to replace spreadsheets and no matter how close you get it to the thing they have been using for the last 100 years they always moan like hell because people just dont like change, i dont bother anymore and just write it so its...

This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a...

Does anyone know a nicer way of writing this. I basically want the form to quickly check all the fields to make sure they are filled in when the print button is clicked, different fields need to be filled in for different print buttons so i used this which works but seems very messy. Private Sub...