Recent content by robertsfd

Thanks, this seems useful. However, I no longer have access to an earlier version of Access. This apparently only goes through Access 2007 (I'm running 2010). Perhaps I can get an earlier version so as to be able to use this. Thanks for the help.

I have a large number of databases that I want to get various properties from to populate a spreadsheet. I can use the Database Documenter and hand input all the values that I want in the spreadsheet, but I can't imagine there isn't a way to query that metadata so I could import query results...

What I have always done is displayed it in a listbox (sized like a textbox) and put the SQL as the Row Source. Since I'm not an expert (or even an intermediate), I don't know if there is a reason NOT to do it this way. But it definitely works.

Thanks to you both. As I suspected, this is beyond what I know at this point. I will need to "learn up" on some material before I can adequately follow Skip's solution and apply it. PH's I can understand and will need to mess around a bit to see if I can apply it correctly. Again, thanks to...

I have a form with a listbox control lstVIN which is populated with records from a table of vehicles (bound on the field VIN). Based on what vehicle the user selects, I want a variable to hold the result of the following query (which will be a single number): SELECT Max(EndingMileage) FROM...

Oops, I mean "thanks for the info PH...

OK, thanks for the info Skip. As you can see, I'm a long way from being knowledgeable. My earlier comment was just based on code from macros in spreadsheets I've used. This spurs on my quest to learn more...a godd thing in and of itself. Thanks again to you both. Have a nice day.

Thanks Skip. Now I see what I did wrong so that it didn't work exactly as you showed. And PH, I've seen and used the "cel" many times. I can't tell you what it is, but if you google it (along with "Excel VBA" or something, you should see many examples and might be able to tell where it is...

PH, I'm only a beginner, but I think "cel" is shorthand for the current cell.

Thanks Skip. Not sure I didn't do something wrong the first time I tried your solution, but when I added "ActiveCell" to your variable2 statement, it worked. variable2 = ActiveCell.Offset(0, 1).Value Many thanks to you. Have a great day, Doug

I have a macro that requests input from a user, stores in one column (column A), and another column (column B)calculates a formula based on that input value. I want a message box to then report both the user input value in column A and the calculated value in column B. Each time the macro...

Thanks for the thought Glenn. I should have been more clear - there are column headings in row 9, thus the first of the code just gets past those (and any other rows that might already be filled up) to add data to the first available row. The problem has been solved. Apparently my problem was...

Just to clarify something mentioned above: It isn't that the macro fails to work the first two times each time the worksheet is open. Rather it doesn't work for the first two rows of the spreadsheet - once the first two rows are filled in, it works as intended.

I have a spreadsheet with several columns. Half the columns are formulas based on the other half of the columns that contain values input by the user. For the user input cells, I have a macro that requests these input values with an InputBox and puts them in the cell, moves a few columns over...

Thanks so much. These both indeed help.