Recent content by zaqyu

Well import specification has 255 field limitation, it should have been easy if the source CSV file columns is within that. thanks...

Thank you for the replies. I'm sorry i cut short my specs. The SOURCE file is a CSV file with 1412 columns (No Headers), it's a proprietary file which is only available to subscribers, so requesting it to match my need is i think not possible. All the Columns in a record seems to have use but i...

Hello Everyone, I want to import selected fields/columns from a text file with 1412 fields into an Access 2007 DB but Access has a limitation to read only the first 255 columns. Is there a way or work around on this limitation. Any VBA code? Also another option is to use Excel make some macros...

Delete the Exit Sub statement and put it after every msgbox within If..End If statements in your VBA Code. zaqyu

Here's the corrected version that addresses your need

Hi, Is txtsection is of text data type? if it is then the SQL should be like this: "SELECT DIE_NUMBER, DIE_DESCRIPTION, SECTIONTYPE FROM EXTRUSION WHERE extrusion.SectionType='" & [txtSectionType] & "' ORDER BY DIE_DESCRIPTION; "

Can you be more specific on your question. Do you want to have a button to print an Access Report (your letter) that will contain the Info or do you want a button that mail merges your info into a Word Doc?

Try to add a textbox under your subreport that is your subreport will be above this text box that contains your message. With this when your subreport has no data, your message will be the one displayed, if your sub report has data, it covers the textbox.

Interested to Help Hello Elena, Just shoot me an email if you still need help. You can check my profile on these links: http://www.guru.com/emp/company-ViewProFeedback.cfm?PID=766c445354726c53 http://www.odesk.com/console/users/Developer_8213e3948989e643 Thanks, Alexis ZAQYU AT YAHOO DOT COM