Hi, i have a problem with a query which get corrupt after use. Problem is like this. I'm exporting a query to excel format and everything works fine. But if i turn of the setting under startup options lik this:
ChangeProperty "StartupShowDBWindow", DB_Boolean, False
ChangeProperty "StartupShowStatusBar", DB_Boolean, True
ChangeProperty "AllowBuiltinToolbars", DB_Boolean, False
ChangeProperty "AllowFullMenus", DB_Boolean, False
ChangeProperty "AllowBreakIntoCode", DB_Boolean, False
ChangeProperty "AllowSpecialKeys", DB_Boolean, False
ChangeProperty "AllowBypassKey", DB_Boolean, False
Then i'm able to export file once. If i then try to open the query I get a error saying there's no destination output. I can't open it in design mode either. So i deleted the query and recreated it.
I don't want user to have the opportunity to edit anything so i want it hidden.
Any suggestion?
Regards
Steven
ChangeProperty "StartupShowDBWindow", DB_Boolean, False
ChangeProperty "StartupShowStatusBar", DB_Boolean, True
ChangeProperty "AllowBuiltinToolbars", DB_Boolean, False
ChangeProperty "AllowFullMenus", DB_Boolean, False
ChangeProperty "AllowBreakIntoCode", DB_Boolean, False
ChangeProperty "AllowSpecialKeys", DB_Boolean, False
ChangeProperty "AllowBypassKey", DB_Boolean, False
Then i'm able to export file once. If i then try to open the query I get a error saying there's no destination output. I can't open it in design mode either. So i deleted the query and recreated it.
I don't want user to have the opportunity to edit anything so i want it hidden.
Any suggestion?
Regards
Steven