Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

**breadwinner** · 05-22-2014, 08:06 AM

Dear Experts

Here i am looking for ur help in VBA thorugh set of table data In Ms-Access, I have set of data in table and in form i create two textbox and one commandbutton

i want generate report from table move to save as xls file depends upon dates pick from start and end date in form of Report

Where ever data filter through date and generate as xls file particular data i want save it into existing file in particular location.

"C:\Users\mani\Desktop\Save\ReportFile.xlsb"

Please find the attachment msaccess & xl file...

**alansidman** · 05-22-2014, 08:45 AM

You have several date fields in your table. Which date field are you wanting to filter on?

EDIT: Just saw that you specified Order Release Date. OK!!

**alansidman** · 05-22-2014, 09:06 AM

See attached.
1. This file is in AC2000 format. It cannot create an xlsb file. They did not become valid files until XL 2007 and early versions of ACCESS will not recognize them. You will have to create an .xls file. I have built the code to reflect this.
2. I created a query that takes its date values from the form
3. If there are no dates in the form, a message box appears
4. I added a filter to clear the dates for you.

Post back with any questions you may have.

Alan

**breadwinner** · 05-22-2014, 12:45 PM

Dear sir

See 24th Column Name is "Order Release Date" Date Field is for date filter

**alansidman** · 05-22-2014, 05:53 PM

Yes. Figured that out. See my Edit in my posting #2. Did you look at my solution in post 3?

**breadwinner** · 05-22-2014, 10:48 PM

Yes, sir really i didnt see it fantastic it works..... Solved Keep help me sir thanks alot once again

**alansidman** · 05-23-2014, 07:52 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the rep

Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

LinkBack

Thread Tools

Rate This Thread

Display

Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Re: Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Re: Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Re: Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Re: Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Re: Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Re: Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file

Thread Information

Users Browsing this Thread

Similar Threads

The latest poi.jar file is anable to generate the excel report ou java application

Unable to perform auto mail merge to ms words using .xlsb file as a data file

Cannot save Project file as MS Access file

[SOLVED] Cannot save Project file as MS Access file

[SOLVED] Automatically save report to new file name each month

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions