Search results

Ranman256, That actually works perfect for now. Where could I add an message if no error and import is successful? Thank You

I'm stumbling my way through creating a basic import procedure in VB using the Transfertext process. I have the code working to browse to the text file and import successfully but I have no validation in making sure it goes in successfully or error if it fails. Ideally I would parse through...

arnelgp, That worked Perfect! Thank You!

Hi All, I currently have a btn that exports my query to a text file but as of now I have it hard coded as to where to save and file name. Preferably I would like to allow the user to be prompted to name the file. I'm very new to this and was hoping to be pointed in the best direction. Public...

Well there was a super simple solution... Create an unbound text box on my Report and make it's control source a non existent source...it then prompts you to enter a parameter Value and I can enter my transaction number and then print my report. Thanks for your replies and solutions

The report gathers a running total, once that total is displayed we use that total in another system to generate a transaction number that I then would like to add to the report. Yes, Saved as pdf.

I have a report that after it runs I would like to allow the user to add dynamic text to it so when it is saved\printed it has it on the report. The report gathers a running total, once that total is displayed we use another system to generate a transaction number that I would like to add to...

Wasn't sure how to do this but it was very simple. Thanks for pointing me in that direction! :)

I have a main report that is basically acting as a template. It contains no data itself but uses the Main query as the Record Source and Prompts the user with a Start and End Date request. Within the Main report are 4 Sub reports that are all using different queries built off the main query...

Thank you Plog! I got it figured out now!

plog, Thank you for your quick reply. Sticking with your field names...if I'm following correctly...I don't need the full Sum of [A]. What I need is for the query to only ADD the Distinct Values returned for that day from column [A]. Column [A] is returning duplicate data because column [S]...

Hi All, I'm running Access 2016 with a SQL back end containing 2 tables CCR & DCR. The query I have successfully pulls the data I need for a single day but when I need more than one day I can't figure out how to Sum the Distinct Values in the DCR table. The main issue I believe is while the...