CVS File Exported Using Access Report Format (1 Viewer)

access2010 · Oct 27, 2018

Our volunteer staff do not create proper CVS files for a report which we produce every morning.

Can I/We please be assisted in creating a programmatically created CVS file, for the report = Stock_PortfoliobyAsset_Sergey_SymbolsR

Your assistance is appreciated.

Nicole

June7 · Oct 27, 2018

Not aware of any way to export a report to CSV (Comma Separated Values) file. Export a table or query.

arnelgp · Oct 27, 2018

you may try.

access2010 · Oct 27, 2018

Thank you for trying to help, but we are receiving a =Compile Error.

Could you create a Query to create the CVS file?

For your information we use the CVS file to connect with Yahoo so that we can receive Equity Transactions.

Thanks,
Paul

isladogs · Oct 27, 2018

Arnel's file includes a VBA reference for Excel 16.0 (2016)

If you have an earlier version of Office, this reference will be flagged as MISSING.
Untick the reference to remove it.
Normally I would then tell you to replace with the Excel reference for your version of Office, but there is no need as it isn't actually required here.

As june has already said, these are actually CSV files

arnelgp · Oct 28, 2018

here, I used your query that your report is using

Gasman · Oct 28, 2018

AFAIK the Yahoo prices stopped a good while back, as I used to use them for the few shares I have.?

Would you be able to explain/post a link to how you get the prices please.?

access2010 · Oct 28, 2018

Arnelgp

* * * * P E R F E C T = Thank you for your assistance.

Can you please suggest a code that would let the volunteers click a button on the main form and the Exported CVS file would be created with the date?

I/We appreciate what you have done.

Paul

access2010 · Oct 28, 2018

AFAIK
Regarding your request.
I do not know how the CVS file receives the Yahoo Stock information because the company we use to obtain this information from does it for the organization that I volunteer at for no fee (donation) and I would never ask them for THEIR proprietary information.

Sorry that I can not help you.
Nicole

arnelgp · Oct 28, 2018

im confused. who is access2010? paul by day and xform to nicole by night?!
will you be manually enterinf the date of the generated csv?
currently uses today's date.
just copy the code from the click evnt of the button to the button you have onthe main form.

access2010 · Oct 28, 2018

Hello.
We are a Volunteer group who work at a Charity.

Our hours are flexible and sometimes I run the office and sometimes others run the office and this is why there are posts from different volenteers.

Sorry, if there is any confusion.

Thank you for your suggested code copy of the click event.

Paul

access2010 · Oct 28, 2018

Hello, Arnelgp.
Thank you for your assistance in creating the CVS file, but I am receiving a Compile Errorr at
= Private Sub cmdToCSV_Click() =
Can't find Project or library

I think that something is missing from our database.

Could you please advise me what I should place into the Data Base that you fixed for us.

Thank you,
Paul

June7 · Oct 28, 2018

I downloaded arnel's last posted file. There is no code associated with the export button. How is the export performed?

See post 5 about the error. In the VBA editor menu > Tools > References, uncheck the reference that is MISSING.

arnelgp · Oct 29, 2018

mr.oaul/ms.nicole:

inly copy the code Inside the Sub..End Sub.
dont cooy the sub itself.

on the button that u will re use the code, on design view, select Click Event on its Property Panel. then select Event Procedure and paste the cide Inside the Sub.

access2010 · Oct 29, 2018

Thank you all for your assistance.
I think we are getting close to a working database to create our CVS files.

I am receiving the error message = Can not update. Database or object is Read Only.

Could I please receive a suggestion on how to fix this problem?

Thank you.
Nicole

arnelgp · Oct 29, 2018

what you are seeing is an image (its not supposed to be there).
edit the form, select the object and delete it.

CVS File Exported Using Access Report Format (1 Viewer)

access2010

Registered User.

Attachments

June7

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

Attachments

access2010

Registered User.

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

Attachments

Gasman

Enthusiastic Amateur

access2010

Registered User.

access2010

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

access2010

Registered User.

access2010

Registered User.

June7

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

access2010

Registered User.

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread