Search results for query: *

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

Part II of this problem is that when I am in the tabbed form with the blank field and enter data somewhere else on the form, the field THEN shows the number. WHY??? I'm not sure how to work around it, nothing else seems to work. Thanks for you help in advance!

I have a tabbed form that on one page it calculates the totals of a continuous form in a footer and is then referenced by another page in my tabbed form. Here's the weird part. Anywhere that my continuous form has to scroll down, the field that references the footer shows up blank. Every...

I wrote this code to sum four fields based on the ContractorID grouping (there's a left join to get Contractor info from a different table and list the contract price even if there are no change orders). When I run the procedure, I'm getting the overall sum for the project number, not grouped...

Mark, That was quick! The other problem is that I have a subform linking that Project Number together, but there isn't always a record started yet so obviously I get an error. Would it be better to remove the child/parent link and check for that project number some other way? Once I get that...

I am trying to populate a field on a form that will give me the sum of two numbers if that project number exists or return a zero value if it does not. Table ProjectNumber (check to see if there is a project number) PropCost (sum) AppCost (sum) If there is a record, my equation works but...