Search results

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...

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...

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...

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...

Is it possible to have different subforms pop up in a form depending on the choice of a list menu/combo box? Thanks!