Search results

I try not to use the query window when I can write the SQL...habit from working on a shared database; users will mess with queries, but you can protect your code (and I know, there are things that you can do to protect access to your queries too, but objects can be exported and imported into...

change "AND" to "OR" in my previous example, and lstSearchResult to me.subForm1 I would think that would do it. I'm having a slow day, if you want to post your db I'll take a crack at this for you.

How do you plan on displaying your results? In a list box? If so, add a "Search" command button next to your combo boxes and construct your SQL statement after all the combo boxes selections have been made. Example: Private Sub cmdSearch_Click() dim strSQL as String strSQL = "SELECT...

I got my answer... frm.repaint

Hello Everyone~ Does anyone know of a way to update the visibility of a control twice within the same event? Here's what I want to do, I have a form with a command button (cmdGo). On the click event, I want the following sequence of events: 1- a listbox (lstFiles) to become invisible 2- a...

nevermind, I figured it out... With rmCatalog.Tables .Item("tbl1").Name = "tableone" End With

Bob~ I did some research and this is what I have so far...my problem is that I don't know how to set rmCurrentTable to "tbl1" in rmSource (make sense?) Private Sub cmdTest_Click() Dim rmCatalog As ADOX.Catalog Dim rmSource As String Dim rmCurrentTable As ADOX.Table Dim rmConnection As...

Thanks Bob...now how do I do that?

Hi~ First off, sorry about the title; I couldn't really come up with anything that made sense. Here's what I'm trying to do, I am trying to rename a table in one database from within another (there is a really good reason why I want to do it from somewhere other than the db that contains the...

I just started a new job and took over a database that has been in production/use for about six years...quite robust, but also quite confusing. I need to add some functionality to some forms to accomodate for changes in fiscal year (FY), and I don't want to build a new form for each year (as my...