Search results for query: *

You guys are smart and I feel like an idiot/moron. I had remarked out the line in the Double Click event when I was trying to isloate the code for testing/editing purposes and I never did away with the remark! I used all your responses to resolve the issue and it works properly now. I left the...

TheAceMan1... I understand your point about the object and changing it to a variable will definitely eliminate the error message. But I need to get that value back into the active control of the form from where the modal form was called up with the double click. So I need some link...

I have a line in the Close event of a modal pop up form which is designed to send a value to the control in the form from which the modal form pops up. The modal form is called up via the On_Click event of that control. The line in the Close event of the modal form that is creating the problem...

Thanks to everyone for all the insight in the responses to my original post. You have provided several different angles, legal and otherwise, for me to consider.

If there is another forum where this would be more appropriately posted please let me know. I am working as an independent contractor under an annually renewing services contract. I do all the IT work for this company which involves machine configuration, network configuration and security...

Well, I got it to work by using the value method which I hadn't considered. I also took the DLookup parameter out of the control source for the field and stuck it in the After Update event of the second combo box. Taking the Dlookup out of the field control source property and using the value...

None of these approaches seem to work. And Access 2000 doesn't appear to support recalc as a method. I just don't understand how the second combo field can requery successfully to a blank field after the first combo box is modified from a prior selection (there is a me.combo2.requery statement...

That is an approach I have tried. When I apply that code, I get an error that says "I can't assign a value to that object". Even if I use a variable to accomplish that, rather than assigning the value directly, I get the same error.

I have a from which has 2 combo boxes. The list for the second box is dependent upon the first box selection. The combo boxes are working properly. I have an unbound field which performs a DLookup based on the selection in the second combo box. If selections have already been made and the fields...

I'm using DAO. No need to get into the details right now. I am just getting into the nuts and bolts of it today. As my plan becomes more clear, I will share the details with you. I have some reference material that I am looking at and it appears there are several ways to do this, some more...

Then can I bring a record from the recordset into a form for editing by using a combo box looking up the values from the recordset. Is that possible?

Thanks for the info, Ken Reay and Remou! I will do some homework. What about my question about recordsets. Are recordsets limited to step through looping type actions as opposed to random selection from a lookup? I am speaking about recordsets created during an event through a variable with...

As a followup question, is it possible to have a global variable populated with a recordset based on some criteria and then have a form perform a combo box lookup on the contents of the recordset (global variable) or do recordsets not allow this type of action? Are recordsets limited to step...

I'll work on that this morning and report back on any difficulty. Thanks Remou!

I am not sure how to go about this and I'm not sure if I can explain this very clearly either but here goes. I have a table that has item numbers no duplicates and a second table that has item manufacturing templates, of which there can be more than one per item number (one to many...

Thanks for the response MajP! I've not used global variables before but it all makes sense. I'll work on that this morning. A couple additional questions, once you set the global variable to a particular value, does it retain that value indefinitely or until it is changed elsewhere? I am...

In Access 2000, I have a Receipt Form which allows the user in a particular control, to bring up a modal form using the Double_Click event of the control. The modal form provides for a numerical conversion and on closing sends the value to the same control from which the modal form was...

PHV: I invoked your solution and it works perfectly. Not only does it clear the apostrophe allowing the INSERT command to run properly, but the inserted field is left in its original state when inserted in the table, without the double '. Can you explain how the data was only changed during the...

MikeC14081972: That's exactly where I was headed with my question. If the change is permanent, I think I would want to change it back afetr the insert is accomplished. Thanks for your help! I'll proceed with this and post back if I can't get it done!

Thanks for the reply! I did a search on this after I posted and I found various posts indicating this solution. As a followup question am I changing this data temporarily just to make the script work or am I changing it permanently?