Recent content by djh

Never mind, i put the field names in brackets and the clause in paranthesis, and it worked...

Weird... I'm totally baffled. If I put in an ORDER BY clause in my SQL statement, I get an error: "Method 'Open' of object ' Recordset failed" If I don't put the ORDER BY clause, it works fine. Here's what I'm using: Set rst=New ADODB.recordset strSQL="SELECT temp.* FROM temp ORDER BY...

Ok, I did: "Dim rst As ADODB.recordset" and it worked!! Thanks for the help everyone!

Great, thank you Doug. It's just like ADO, I see. I have this code: Dim db As Database Dim RS as recordset Dim strSQL as String set db=currentdb strSQL="SELECT price FROM temp;" set RS=db.openRecordset(strSQL, dbOpenDynaset) and I keep getting the error: "User defined type not defined" on...

Hey folks. I'm so new to VBA, that I'm in need of some simple - I'm 5 years old - type instructions. I do know ASP, and so I'm familiar with how things should work, just not the syntax. Anyway, I have a table from which I'd like to generate a recordset. How do I create a recordset in VB...

My msgboxes are showing up all funky when the text exceeds one line. What's the center property for msgboxes? (vbYesNoCancel). Thanks!

Hello... How would I go about having a field called 'Description' control a field called 'Rate'...so that changing either one would give me a corresponding value? The only thing is that I'd like them to be 1) combo boxes and 2) that they get their values from a lookup table. What would this...

I need your help...you're my last hope (to quote one princess) I have beautiful relationships... I'm just stuck at how to go about it entering/registering new customers with their exhibits to certain shows... So, I have lots of tables. 1) customers 2) shows 3) show attendance 4) exhibits...

Thanks TommyIndigo. Great suggestion. I knew that customers and shows is a many-to-many, just didn't quite grasp the idea of having a show attendance table.. duh. Two related questions: 1) So table Exhibits would then tie into the Show_attendance table or the show table or customer table...

I have a lookup combo box that gets a value from a table and another combo box that changes to the corresponding rate of the first combo box. And I have a form field doing the calculation of the rate X quantitiy. But the number that the calculation field is using isn't the value in the first...

no it's not. What's the code for each box?

Looking for a bit of enlightenment.... Going to just put it real simple. I have three tables. 1. Customers 2. Shows 3. Exhibits If I choose customers as my entery point, and from a customers form, a user chooses a customer, how would I get a form to show me which shows (while also displaying...

Ok, so I'm still missing one thing. I can set the code on the combo box (which I've decided to use) to get a subform of a tab on top. I assume it would work the same if I wanted to disable and enable it, right? But the part I'm not quite getting is that of the tab objects. Don't I need to...

Thanks DML - just need to clarify though. So I type in Me.MyTabControl.Pages("PageName").SetFocus where? And this is for the tab controls right (which methinks is much better than subform visibility thing)? Is "PageName" the name of the subform on a particular tab?? Sorry, I'm kinda...

Thanks Mike, Would the code just be something like... if MyComboBox = "X" then Me!MySubformControl.sourceobject = "frmSubformX" elseif MyComboBox = "Y" then Me!MySubformControl.sourceobject = "frmSubformY" endif This is for a subform, but how would one control which tab is displayed? And...