Recent content by on-2

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