Hi Guy's i haven't come accross this before but my front end database won't print a report either from a command or trying to open the report direct
It works on another front end
When opening the report direct the following message pops up
This is what message comes up when trying from a command
Before all of this, may have done this in reverse error but been on holiday for 10 days and can't see a user input error but this was the 1st thing that didn't work!
The message on the following comes up data member not found Highlights Workbooks
Code:
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Open pathSave & fileSave, True, False
End If
Although when I copy this over from another part of the database, this works (doesn't highlight the word "Workbooks" and opens the file!
Code:
Set apXL = CreateObject("Excel.Application")
Set xLWB = apXL.Workbooks.Open(pOpen & fOpen)
apXL.ActiveWorkbook.SaveAs pSave & fSave
apXL.Workbooks.Open pSave & fSave, True, False
Any ideas why a front end file won't open reports, communicate with printer when other front ends do ???
Hope I have explained these problems correctly
Kind Regards