problems r us- opening word docs, reports from crosstabs and

[rhintintin]

i need help with the following problems please

1) I am trying to make a macro to open a word file from access, i have used the runapp and the command line

drive:/dir/dir/winword.exe -drive:/dir/letter.doc

i have tried numberous variations on this and none work can some one help me

2) i have made a report from a cross tab, however if when i make the crosstab one of the cross tab fields is empty (does not appear on the query) it cant be added to the report, if data is then added to the table, that means this crosstab now has data in it does not appear on the report.
I tried to make the report with the crosstab having data in each field, but then if the field is emptied then the report does not work with the following error coming up 'The microsoft jet database does not recognise '[field name]' as a valid field name or expression'.

 

[THoey]

I have done this with code (from a button click on a form) instead of a macro, so if you really want to have a macro, you could modify this code and call it from the macro:

Private Sub btnRun_Click()
On Error GoTo Err_btnRun_Click
    Dim stAppName As String
    stAppName = "word.exe " & """" & Me!cboWord.Value & """"
    Call Shell(stAppName, 1)
Exit_btnRun_Click:
    Exit Sub
Err_btnRun_Click:
    MsgBox Err.Description
    Resume Exit_btnRun_Click
End Sub

This form had a combobox that allowed the user to select which document to open. Make sure that you fill in the complete path to MS Word.

Hope this helps...


Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[maria28gr]

I think you can find an answer at your 2nd problem at

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/703/qid/35663

Maria28gr
maria.karakiza@usa.net