Recent content by fedupwithaccess

SQL Statement error Thanks Allan, all works fine now. I'll take more care next time. Many thanks, Iain

Hi, I currently have a date and time picker for which when the user selects a date and presses ok, data for that particular date is extracted from a linked server table and appended to a local table in my database. When I specify the SQL in my code this works fine within queries, but when I...

Emailing current record/screen John, Thanks for your reply and it sort of confirms what I was expecting, as in I'll have to go via reports. I was hoping to take a look at your sample, but unfortunate your database link no longer exists on that previous thread. Could you repost this at...

I'm not sure this is possible, so I suppose I'm just wanting it confirmed. Is there any way that I can automatically email the current screen from within Access. i.e. call outlook along the lines of Dim x x = fHandleFile("mailto:" & Me!EMailAdd, WIN_NORMAL) ' me!ContactEmail and then add...

Thanks for the pointers. Luckily all my calulcated formulas are on my queries then (which my reports run from and the user ultimately sees), but looks like normalisation is the next chapter for me.

No it's not summing other fields just yet and got that one covered thanks. It relates to bonuses for staff (which is currently on a very slow 35MB spreadsheet) for which they are graded against various measures and then their scores adjusted/weighted according to the system speeds, volume of...

error in formula Thanks SJ. Like your suggestion and would have implemented it, but since realised that my value for UKAdjTot would always be 0 or a true value. Basically the answer can only ever be returned correct or as 0 (#error) Working on this basis I changed the formula to: UKAdj%...

Hi, I've currently got several formulas like the one below in my query for which when dividing by 0 I get #error (which I was aware occurred). However, I though my formula would return 0 in such a case (lilke Excel would), but it hasn't The fields which it is using to calulate the formula...

No, it just runs through the code to the End If (I check for blank fields first). On the form that it does work on, it produces the object guard model. Where as it fails to activate this on the others. It's as if it cannot connect to Outlook anymore.

My problem is a little strange as my database works pretty well, but is now playing up since I've put navigation/main menu forms on top of it. The database is made up of a number of forms for users to raise invoices, credit notes, new accounts, or account amendments. After completing each form...