Search results

Dear Jim Thank you very much for your help - I'll check the directions you gave me and try to discover what is going wrong. Do you mind if I'll contact you again about that? Best wishes. Gilberto

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 David Many thanks - it worked fine! You guys (David, Pat, and Rich) can't imagine how helpful you were - I was struggling on that for almost one week. Best wishes and thanks again! Gilberto

Hi Pat Many thanks for your help, but I'm still having problems with the button. I typed: stLinkCriteria = "[PersonID]=" & Me![RefereeID] & "[PaperID]=" & Me![Paper_Record] DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria When I click on it, the following message appears: Syntax error...

Hi Rich Thank you very much for your help! Following your advice (and some test-and-try)I changed the event: stLinkCriteria = "[PersonID]=" & Me![RefereeID] DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria Now the report is being automatically created. The only problem is that it shows...

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

Thanks indeed Geoff I'll try it. Best wishes.

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