Search results

When I try to run a report from my form and it fails, I receive this error when I try to close out of the form: "This action will reset the current code in break mode. Do you want to stop the running code? * To halt the execution of the program so the Module window can be closed, select Yes...

Ok, I tried the multi-select list box and it will populate the title on the report with the accounts chosen for the report, but it lists them vertically. Is there a way to make it list horizontally? Thanks for all your help with this! :)

I have a form that has a list box and a text box. When you highlight an account from the list box and click a command button to select it, it adds that account to the text box. The accounts listed in the text box are stored in a temp table that is attached to a query that a report is generated...

No guru, but will give it a shot If I correctly understand what you want to do, you can just change your page setup to Landscape and hit the print button. It should print your main form and the subforms (but it'll depend on the format and amount of information in your subforms). I'm not a...

Hello! On my form I have the option to choose several different account numbers and run one report to display information for all of them. Since these reports can get quite long, I have an unbound text box, next to the title of the report, that I would like populated with the referenced...

I have a multiselect form that is attached to temp tables and queries. I copied the following code from another database I work with, but am unable to get it to work with the one I designed. I think there might be a problem with my Dim statements because when I comment them out, my form will...

I have a group of tables that filter information to each other in an Excel spreadsheet and I’m trying to set up an Access database that will allow this feed to continue. One spreadsheet has ‘permanent’ information in a three-dimensional format (shown below). Another table reads values out of...

Thank you! I wanted to let you know that I got it to work. I had to do some tweeking to get it to tailor it to my text file, but it works! Thank you so much for your help!!! :D

Fuga, You are correct in assuming I am new to vba loops and macros. To answer your question, yes, the rows always come in pairs where row2 should be at the end of row1, row 4 at the end of row3, etc. I have another question regarding using Microsoft Word for this task. Will Word have the...

Is it possible to combine two lines in a text file to one row/record in an Access database? The import wizard allows me to set my columns, but I cannot create proper columns because my data imports into two rows in a table. Having information on two rows that do not line up make it impossible...