Recent content by focus10

In access 2016, How I can Hide the Ribbon and display instead at the top of the screen an existing menu bar? thanks ahead

problem with this solution that in some cases there is no registered default program for csv. so i search for a solution that will force opening the csv file with excel with the shellexecute module. any excel version that is exists in the computer

i know that i can write the excel.exe in my line like: StartDoc = ShellExecute(Application.hWndAccessApp, "Open", "C:\Program Files\Microsoft Office\Office14\excel.exe" "c:\a.csv", "", "C:", SW_SHOWNORMAL) but in other cases it can be another folder. so what i need is the default excel application

for opening a csv file i use StartDoc = ShellExecute(Application.hWndAccessApp, "Open", "c:\a.csv", "", "C:", SW_SHOWNORMAL) line what can i add to the above line for opening the file with excel application? thanks

csv can be a good solution for self using. but not enough when customers are involved thanks for the answer

acSpreadsheetTypeExcel9 did the job until the last update by microsoft. after the last update we are in a new era with a new problem.

acSpreadsheetTypeExcel12 is not recognized by access 2003 must be some where another solution

after the last microsoft update access 2003 fail to export to excel 2010 by DoCmd.TransferSpreadsheet is anybody has a solution? thanks

i'll be glad to have your code

i have xml data stored in sql server table. because sql server dose not support utf-8 encoding i want to export it to an xml file from access. i can retrive the xml data by using a pass through query. is there any code to can help me to export this data to an xml file? thanks

1. copying to clipboard by passing the filepath of a file to a procedure ("c:\a.exe") 2. manually Navigate in Explorer to d:\ 3. Right click paste

no need to open the file or read it's contents. just copying any kind of file onto clipboard by passing the filepath of a file to a procedure

i mean copy the file to the clipboard for pasting it into another application equal to Ctrl+c when selecting a file in disc

sql server can produce xml file as unicode utf-16 but i need it as utf-8 is ms access can create the transaction between the unicodes? thanks ahead

is there is a code to copy a file into memory (for pasting it) by giving file name and path? thanks ahead