Search results

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...

Probably isn't the best written routine you have read Rob... When I use the debugger step-by-step, the error never appears, so I never know where it happens. Thanks in advance, for your help! Private Sub PaperReceivedEmail_Click() On Error GoTo Err_PaperReceivedEmail_Click Dim Text_email...

Dear Rob Yes it is a Yes/No field - but indeed it's already a check box (and not a combo box, as I wrote previously, sorry about that) Is there any special setting I could use in the check box for avoiding this error? Thanks a lot for your help!

I put this thread yesterday, but there wasn't any answer so far- and solving it is quite urgent! Does someone know how to solve this problem? I have a combobox in a form linked to a Boolean field message_sent in a table. There are two ways of setting it True: - the user can click on the...

I also can quit the message clicking OK, but this isn't really nice... Any other views on the problem? (which seems more common than I thought...) Thanks again Gilberto

Hi all I'm quite a naive Access user, and I'm trying to solve this problem: I have a combobox in a form linked to a Boolean field message_sent in a table. There are two ways of setting it True: - the user can click on the combobox or; - the user can click on a button, which has a VB routine...