Search results

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

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

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

Hi all I have a form 'Paper' with a combobox 'Submitting author' and also a subform 'Author'. When a new record is created, the user should select the names of the authors in the subform, and then select the submitting author in the combo box (a query selects the authors of the paper in the...

Hi All I'm trying to send a Word file (a field which is an OLE type) attached to an e-mail. I searched in the forums, but I couldn't find. I'm using the SendObject to create the e-mail: Dim Text_email As String Text_email = "Dear " & Me.[surname] & vbCrLf & "Text test" DoCmd.SendObject , , ...

Hi All I’m trying to create a report from a sub-form button for a scientific journal database. I have searched in the old topics, and they provided some solutions – but it still isn’t working. Any help is welcomed. I have a form (Paper). For each record in Paper there is a subform (Referee...

Hi All I'm a naive Access user, and I'm trying to implement an index system (not autonumber!) for a journal database where a form provides the number of papers in that year (eg, 2001/001, 2001/002, 2002/001). There are two fields (year and sequential number), how can Access calculate the...