Replies

Paul & John,
Thanks a bunch! Those are exactly the tips I needed and wasn’t finding outright.
Dashiell

I thought the embedding would have problems but wanted to be certain. I used the ShellExecute and it worked great. Thanks for the help Hans!!!

Really the transmission part of the code. I’m sure I’ll be able to transfer the dataset to an XML file. Once that is complete, how do I upload it to a specific server so it is encrypted using SSL?
Thanks again!

You cannot delete records from linked XL files (although you can append records). You could use your append query as a select query and run a transfer command to transfer the query results to the XL sheet but keep in mind it will overwrite the entire workbook so you would want to separate your sheet from the rest of the workbook (you could always link back it to the workbook later).
Hope that helps.

I need to transmit an XML 3.0 file using SSL protocol and am planning on using code.
Thanks for your help Charlotte.

Very vanilla format (no sprinkles) and the transfer is for retrieval.

Hi Charlotte,
I dusted this post off as it pertains to a project I’m working on. I need to capture data from a query and transmit it in XML format to a web server. I don’t have any experience in XML in an Access environment (I’m still a v2000 user but would upgrade). What type of XML tools are provided in v2003? Are there any books/documents/sites that might help me with this or that will educate me? Do you have a sample app that performs something similar that you could share? Any direction would be appreciated.
Thanks!
Dashiell

Hi Mark,
I am embarking on a similar project and found your 2003 post. How did your project turn out? Did you find a way to convert data to XML and upload it via the web? Does Access 2003 do anything to help the situation? And, lastly, did you find any good resources on the topic? Any direction would be helpful as I know nothing about this but am willing to roll up the sleeves to learn and implement.
Thanks!
Dashiell

Worked perfectly!!! Thanks Hans for sharing your expertise!

Please describe your form structure. Do you have one form containing information on the drum and another that processes the disposal or is everything contained on one form?
If everything is contained on one form, couldn’t you use one table for all the drum attributes? Unless the drum is shipped to storage more than once or shipped for disposal more than once, you could make the storage and disposal fields part of the drum table. Then you could see all the drum attributes, the storage data and the disposal data all on one form and eliminate the subforms. This might greatly simplify things for you. If it doesn’t work, tell me why so we can try another avenue.
Dashiell

Add a text box with the control source =1 then set the running sum to Over All. that should do it.

Hans,
I think that’s the direction I was looking for. As always, I thought there would be some neat pre-packaged Microsoft solution (in that case, why would they need me). I like the timer idea. I’ve never set code to run on a timer…I assume the On Timer event is the one I would need – correct? If so, what code instructs Access to repeat the code every (let’s say) 60 minutes?
As always, Thanks!

Hi John,
I looked at KB #197420 and it appeared I would be able to use this approach perfectly. The only problem was when I copied the information and pasted it, it parsed the date on each blank space. Any thoughts on how to prevent that?

All I really need is the name and subject. Is it possible to mecahnize the Outlook export so the user doesn’t have to do anything?

Nope…I always remove that as it kills my reports. It must be something else.