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
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
i need a code to transfer files to and from a https web site
the code has to provide the username & password for entring the site
Thanks in advance
sam
Hay,
9 of 10 comuters in my office response fine to the code ie.Navigate
in a single comuter it dosn't work at all.
application run's on access2007
windows xp
any idea what stuck's it?
thanks
can someone help me to solve a dilemma
i need to check by access timer changes in an sql table every second
now my dilemma is to link the sql table constantly and lookup the table every second
or run a Passthrough query every second
witch method will be moe effective>
thanks
for operating an action in an internet site i use the code:
Set ie = CreateObject("internetexplorer.application")
ie.Visible = False
ie.navigate "http://abcd.com/AsteriskClient.php?......"
but the result is a security messege
is there another way to it?
thanks
with access 2007 on windows 7 Passthrough queries dose not connect to sql server. for waking up the connection i must first link manualy an sql table and then alll Passthrough queries are live.
the odbc string i use is: "ODBC;DSN=Focus;APP=2007 Microsoft Office...
after reinstalling office 2003 with full options and
after registering the Triedit.dll file
still i get error: OLE Server Isn't Registered
what else can be done?
thanks
i have a client list in a Continuous Form
and a small popup form containig client's details
moveing from client to client in the Continuous Form Requers the popup form.
till now is simple.
but how can i move the popup form up and down so it will coordinate with the client row and top of...
while useing TransferSpreadsheet command to export a table from access 2007 with hebrew column names to excel 2007 i get "????" in the excel sheet.
what can be done?
thanks
i have a continues form as phone book
one of the fields contains an ole object with bitmap images (mobile, fax, phone pictures)
in most machines pictures are displayed but in some machines
pictures not displayed.
any idea what is missing in those machines?
thanks
the folowing code is running well in tens machins.
in one of particular machine i get a Run-time Error -2147217900 (80040e14)
"one or more errors occurred during processing of command"
refferences are ok
sql query is ok
compilation is ok
so it must be related to some problem with the...