Search results

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...

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...

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...

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...

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...