Recent content by johnseito

Copy specific worksheets from one workbook to another workbook, rename and save them to a given directory. '============================= With excel VBA you can just copy it to another workbook by recording a macro 1. First select all the sheets (you want) from one workbook 2. Right click...

Ok- thank you both, that work. It's a bit different than excel VBA but I see how it is. Can't put the path and file name but just the file name.

is there any access VBA code to check if an workbook is open or not open ? In excel VBA - you could just loop through all the excel files that are open and you find the name of the file while you loop through and you could tell if that file is open. I couldn't do this in Access VBA.

I did just this but my ORDER by clause for the outer query to the two union query didn't work. I did first field order by as ascending and second field as descending, my result is second field is still in ascending order. Second field is a field I added - union of the two queries, with the...

I did union all to many queries but how do I order them as which ones goes in 1, 2, 3rd etc. ? It doesn't seem like the first query in the union all is the first one shown, and the second query in the union all is the second one shown and so on etc. How do I order it in a way that the first...

It looks like we have some people on here playing games, aren't we all mature grown up or are we still little kids? Speaking to Paul and people like him who aren't very serious with the issues the form is trying to address.

Paul what are you trying to say?

I did that, but then the values to select from the combo box is gone, I can't select it anymore. When I don't put any value in the control source, I could select the values in the combo box. Why is that and what is wrong? Thx

Attached is the response image.

I thought I saw someone reply to my inquery in my email but when I look at the site, I didn't see the reply. The reply is a replicate of my question, why would someone do that. :-)

Hi, Back to this, I tried to select some of the items I type in and then have these items inputted back into the Bid Table, but when I select the table to input, I can't select the values I typed. If I didn't select the table to input I could select the values I typed. Do you know what is...

thanks for sharing though!

cool, thanks for sharing. everyone starts somewhere and you are right. Right now I just know generally about what access can do and it's purpose but the details stuff, I don't know. I think by reading, which is great and not bad at all, provides you with the concept and theory and what is...

How come you ask me to post my database as if you were going to provide suggestion but didn't? ;-)

I don't think someone can really learn access on a deeper level by just reading, I think it has to be by doing and reading and investigating problem and approaching solutions to it. But yea that is what it is with most things that are details and technical oriented. So that is what I am...