Recent content by gilberto

I'll try this way... not sure if I can implement it. I'll let you know if I suceed. Thanks again, Cheers! Gilberto

Hi Fizzio Thanks again. The error occurs when the other user (not me) tries to include a new paper (I guess because it needs the function date()). So your suggestion seems feasible - let me see if I'll be able to implement it given my (lack) of VB knowledge. Regards, Gilberto

Hi Fizzio Many thanks for your suggestion, I think I understood. I guess I have to run this when I open the main form (Papers)... am I right? Thanks again, Gilberto

Dear all I posted a thread 10 days ago, and despite a large number of views (many thanks for those who have analysed the problem) nobody has replied yet. The problem (users using different versions of Outlook and sharing the database) is described in details there: initial thread I...

Dear all I have an Access database which creates emails using Outlook and that I have to share with other users. Recently I upgraded my system to Access2003 + Outlook2003 and compiled the database in this new platform. The problem is that the other users have Outlook2000, and the database...

hi Pat This was very clever - I couldn't have discovered alone, for sure! Many, many thanks - it's working fine now!

hi there I think I'm too ignorant for understanding the file... I tried this (for writing "Dear" in bold): t1 = {\b, "Dear "} Call SendEmail(t1, Me.[E-mail]) but of course the compiler doesn't accept it. Am I in the right direction, at least? Many thanks in advance for the help.

Thanks a lot Pat and Fizzio - I'll read the stuff!

many thanks for your help, Fizzio! I'll try it.

Hi all This should be trivial, but I don't know how to do it, and I couldn't find it in the Forums. Many thanks in advance for helping me!!! 1) I need to format text in my email (size, colour). 2) I need to format a number, contained in an integer variable. adding zeros on its left side...

hi the_doc_man Rob helped me to solve the problem. Anyway, thanks a lot for helping me, and teaching how to search for problems using the Analyzer (which I didn't know). Thanks again for your help, guys! (The database is already working in the network today!)

The error message remains, even using this one: Me!PaperReceived_Fla.Value = True When I try to use (the Form Paper is where the check box is placed): Forms!Paper!PaperReceived_Fla.Value = True a Write Conflict message appears...

I tried that (I didn't know it's possible to set objects, I thought we could set only fields) and I've got the error: Run time error 2465 Microsoft Access can't find the field 'PaperReceived_Fla' referred to in your expression

Hi Rob Indeed they haven't the same name (the checkbox has the name PaperReceived_Fla). I was wondering if I could solve this problem removing (in the code) the cursor from the check box (putting the cursor in a text box associated to the field name_of_paper in the form, for example) - do you...

Hi Rob I did what you suggest (turned off the On Error Go To), and run the button. When I leave the cursor on the check box associated with FlagPaperReceived (a Yes/No field) and press the button, the VB error window shows the following message: Error 2448 You can't assign a value to this...