Recent content by sk1hotpepr

I did some more searching and found this thread: thread702-940780 Option group for parameter it solved my problem. It seems funny to have to send parameters this way, but it works. Thanks Duane for your help!

I learned to late, so ADO is what I've been using. I did some checking on ADO - some more clear than others. 'this is the other part of the code from VBA. Set cmd = New ADODB.Command cmd.ActiveConnection = CurrentProject.Connection cmd.CommandText = "spProsType" cmd.CommandType =...

Duane, How would this work using ADO??

I have a report that accepts one parameter with a stored procedure for it's record source. I have a frame with four values - "Past Clients", "Current Clients", "Prospective Clients" and "Show All Clients". The first three work fine but I can't seem to get Show All Clients to work with the...

Ianatagsl, Sorry it took so long to reply - thank you for helping me figure this out, you solved my problem (don't worry I'm sure I'll have many more)! Now I can fix a couple other forms I've been wanting to do this to. Have a star, I hope that your reply helps others too... Enjoy your...

I want to have the ability to check for a duplicate entry - if duplicate, go to the existing record, else allow new entry. It seems that every entry I type in is "duplicate" even when it is not. How can I fix this - or is there a better way? any help/guidance is much appreciated. Thanks...

Jedel, Thanks for the quick response! My Marketing Number is my Unique ID for the RFP Log. Main Form: MktNum (Primary Key) School District RFPDesc ...other fields Linked Secondary Form: MktNum (Shared Primary Key) - The default value for the MktNum is set to equal the MktNum from main field...

I've searched on the popup form on here, and sad to say I don't quite understand the answers. Hopefully someone can enlighten me! I have a continuous form that creates a marketing log and I have a button that when clicked will open another form in continuous view to let user enter all...

I have a continuous form that I want to allow the user to choose in the header of the form a district once. when the user chooses a district, the continuous section (detail) will be made visible, allowing the user to enter multiple records for that district. my problem is - i want to filter...

I spoke too soon - this seems to work... Private Sub cmbState_Change() Me.cmbSD.Requery Me.cmbSD.SetFocus Me.cmbSD.Text = "" End Sub Thanks for your help PHV, you got me in the right direction!

When I try to add the Me!ComboBox2.Value=Null I get the error: Run-time error '3162' You tried to assign the Null value to a variable that is not a Variant data type. I'm guessing that's because I have the Combo Box set to "Limit to List" as yes? I don't want users to be able to add anything...

I already had that in my code, but it doesn't clear any current entry in the second combo box. If I choose a different state, the second combo box keeps the old value in view but changes the list that I can choose from. I want to clear out the entry so that it's blank when I go to choose...

This is probably an easy question... I have two combo boxes linked together - the first one chooses the state, the second then chooses a county. What I want to do is when the choice in ComboBox1 is picked, clear any current value in ComboBox2 so that I can pick from a list fresh. Right now if...

Thanks for writing back, I swore I was able to enter information at one point. But I got rid of the "group by" in my record source. I had to add a subform just to pick up that summed field since I didn't need it to be updatable anyway and it seems to be working now. I don't know if there's a...

I'm having trouble trying to figure out why a recordset is no longer updatable on a form I'm using. The table has a primary key, so that's not it. I haven't done anything different. Can a user entering information somehow create an error that would no longer make a recordset editable? Here...