Recent content by VelNPS

I am not sure that I have a good idea but.. Could you set the tag property of the first combo box with a value just so you have a place to reference it and then concatenate this into your string with the first parameter to start the next combo box's procedure/record source? It all seems...

Thank you very much for the reply, However, I am trying to remove the reference to DAO and use exclusively ADO within MS Access. Any other ideas?

Dear MB22: I do not have ideas for Macros because I generally write code modules. However, if you write a code module to run the SQL there is an easy fix. When the code bombs, you could trap it in an error routine and resume appropriately. It is often faster just as easy to trap an error as...

Dear Accel45: It is not too clear from you message how you are changing the record source of the list box. One idea might be to hold module level variables that reference the type of sorting you have on your list box. You could create the record source for the list source using these...

Dear Tipmasters: I would like to get at the "Database Properties" that you see when you select file>>Database>>Properties>>Summary menu items. I would like to use an ADO hierarchy but this may be above that in the "workspace" that I do not understand very vell. I have some code in DAO that...

I enjoyed these postings but am trying to find get at the table properties and eventualy create a datadictionary in ADO since I do not trust DAO to stay around all that long. Does anybody understand the starting objects to begin to get at these in ADO? Do I need to use ADOX? Thanks Vel

Engineers are still pouring into the country on F1, H1B and L1 visas. I was displaced from a job by a Russian F1 willing to work for $10 per hour in exchange for sponsorship for a green card. This arrangement is not supposed to be legal but if it happened to this MIT graduate it can happen to...

I have a large number of files on a network. We would like to do some housekeeping and create some libraries. I would like to run through the windows directory structure starting with some drive folder and get all of the files, their paths, the author, date, subject, keywords and comments from...