Running App using Macro

[sonaljain123]

Hi,

I am trying to create a macro to open an application called CRONOS.

My question is that can we use the macro in MS Access to open any application stored on our computer?

Also is it possible to write a macro which does the following:

1) Run Application CRONOS
2) Exports data table which is a result of a form in excel
3) Export that excel data table in CRONOS

In case you want to know, CRONOS is a time series analysis tool.

Thanks!

 

[pbaldy]

Not sure about a macro (perhaps the RunApp action), but with VBA code either Shell or FollowHyperlink can be used to start other programs. It sounds like you want to control CRONOS from Access, which I'm not sure about. You can automate other Office applications, but I don't know about an outside application like CRONOS. I'm not familiar with it, so that's just a general thought.

 

[sonaljain123]

Thanks!

Also is it possible to create a macro that can basically ouput the results of a form in ms excel? How can I get the macro to do the same?

So I know about the "OutputTo" functionality but the issue is that if I use that then only the layout of the form gets exported in excel not the result (which is a table) of the form.

How can I export the result of the form in excel using the macro?

Thanks!

 

[pbaldy]

Presuming the form is bound to a table or query, you should be able to output the table or a query. Bottom line, you want to output data, not an object. If you select form, you're outputting an object. Try either using the table or a query that restricts to the record displayed on the form, if that's what you're trying to do.

 

[sonaljain123]

I understand that the form is an object and not a table.

So basically you are saying that I should have the results of the form to be saved as a table first and then may be have the macro export the table in excel?

Is that what you mean?

 

[sonaljain123]

Also would you a know of a way in ms acess where if we can get our results in an unsorted manner?

So we know that ms access by default returns the sorted results in a table. Now I want a view of a particular type where the results are unsorted. My querry has the fields in an unsorted way but ms access sorts it by default and returns the table which is not what I want.

is there a way around this?


Thanks!

 

[pbaldy]

If the data is intended to be stored in a table then yes, the simplest method is to export data via table or query. If you didn't intend to save it, you can get something from the form to Excel without saving, but it's more involved (automation).