Recent content by MichHart

I am programming in VB 6, connecting through ADO to ACCESS 2000. I am lost with regard to your suggestion. Sorry!! MichHart " Never regret yesterday because it cannot be changed; Instead make sure today does not become a regret of tomorrow."

I have a program that will be accessing data from over 200 tables in 4 Access Databases. How do I retrieve data from tables from more than one database at a time?? I am running a select statement that requires data from tables from more than one database how can it be done?? Thanks for any...

Hi zemp: Actually I got a syntax error with your above suggestion, but I have discovered that it only happens with the field in the table is empty. I had thought that the vbnullstring would cover that. Any suggestions is greatly appreciated. Thanks MichHart " Never regret yesterday...

Hi everyone I have a series of sql statements that are being executed when a name is selected from a list. These sql statements take the field from the record and apply it to the list in the combo box that the statement is being written on. I hope that makes sense. The program executes the...

Hi everyone: I have this select statement that is joining 3 tables, but it is telling me I have a syntax error in the join? Anyone pick out what is wrong with this?? Set rs = db.Execute("SELECT Leagues.[Index], Leagues.[ShortName] FROM Leagues INNER JOIN (Leagues INNER JOIN [Teams] ON...

Hi everyone: I am sort of new to this SQL stuff so I am hoping someone can lead me in the right direction with this: I have a form that has several choices that a user can make to filter the master table by Name. On this form there are 2 sets of option buttons (3 choices each) 3 checkboxes, 8...

Thank you so much, it was starting to drive me crazy!!! lol Sometimes a second set of eyes is all you need! Thanks MichHart " Never regret yesterday because it cannot be changed; Instead make sure today does not become a regret of tomorrow."

Hi Heathco: Try this: "SELECT Funds.Date, Funds.Trak FROM Funds WHERE (((Funds.Date) Between DateValue([Enter Begin Date]) And DateValue([Enter End Date]) AND ((Funds.Account)="IRA")) ORDER BY Funds.Date;" I hope this is helpful MichHart " Never regret yesterday...

Hi eveyrone: I have this Select statement that is giving me an error "missing ).], or item in query expression" Here is the statement: Set rs = db.Execute("SELECT * " & " FROM DraftDetails WHERE DraftDetails.[Player] IN (SELECT Players.[Index]" & " from...

Thanks Matt, I will make that adjustment. MichHart " Never regret yesterday because it cannot be changed; Instead make sure today does not become a regret of tomorrow."

Hi everyone: Matt I have figured out the problem. In this line of each of my recordsets Set rs = db.Execute(("SELECT Teams.[Index], Teams.[LongName], Players.[ColCommit] " & " FROM Teams, Players WHERE Players.[ColCommit] = Teams.Index"), db, adCmdText) I had to remove...

Matt I hope you are still viewing this thread. I have a question that concerns all the recordsets that I am setting up.. Should I be closing each one and setting rs to nothing each time or should I do it after all are completed.?? Or is there a better way to do it. The program is now booting...

Ok thanks Matt for all your help. I will take a look at all these suggestions today. Thanks again for all the help. MichHart " Never regret yesterday because it cannot be changed; Instead make sure today does not become a regret of tomorrow."

Hi, well this is what the debug gave me Last Name: 'Hart' First Name: 'Michelle' SQL: select * from Players where FirstName = 'Michelle' and LastName = 'Hart' Then when it moved to line: rs.movefirst the program kicked me out. Sorry to be a nag, but I have to figure this out. MichHart...

ok i stepped through it, and it is returning a value. I am getting a name. I will run it again and see what happens. MichHart " Never regret yesterday because it cannot be changed; Instead make sure today does not become a regret of tomorrow."