Recent content by da poet

The listbox is a multiselect listbox but the bound column is the problem that im having. I have two listboxes that i drag and drop things from. I would like to run the query which is an update query on only the item selected and dragged as opposed to having the query executed on everything...

Im running an update query but in the criterial field i would like to include something that instructs the query to be executed only on the value selected in my listbox. i need some help with the syntax cause i dont know how to bound the query's execution to the selected/highlighted value in...

My query is executing on everything in the listbox. I only want it to be executed on the value that i select. What codes can i use? I really need some help on this one.

The thing is I have two listboxes both of which list the component parts assigned to particular machines. I wanted to be able to switch components from their assigned machine to another one based on the machines service tag number. i have an update query which executes to take values from...

How do i apply a query that i want to execute only on a highlighted record in a listbox. If there is a link, sample database or lines of code could you please assist. Currently everything is being executed on all of the records in the query. Also Does Access 2000 support codes for drag and...

Thanks for the reply. It turns out that i did add the exact code that i posted earlier to the forms Current event, it doesnt work how it should actually. It keeps locking all the records. Please advise

How can i apply the following code to the immediate record in my subform. I would like when the assigned check box value = true, then the fields for that record become locked. Ive written the following code to an onclick event for a check box labeled "assigned" on my form, the problem is it...

Back to square one. It seems as though it would be best if i made the first combo box unbound but how do i prevent all the others in the form from changing when i change the value in only one of them?

I have a table that keeps putting a zero value in the new recordl. It was previously an autonumber field. I changed that and deleted the zero from the default value property. How do i get rid of this???

I keep getting this messgae that says "tyhe current field must match the join key in the table that serves as the one side of the one-to-many relationship" Im working on a subform that im using a query on, Can someone advise as to what i should do, THANKS IN ADVANCE >> i found a waya around...

Thanks much for the post for the after update. Myu problem is slightly different, i got a type mismatch error so i changed the field from number to text and that works except now i get a message when i click the record that the record is not found . Please advise

I seem to be having some listbox troubles. I would like to know how to use the highlighted record that i have selected in my listbox to update another field on my form. I had used a macro with the event on dblclick, the problem is the event seems to be carrying out the update on all the...

I just found something in throught the search option/ Its okay, if i still need help then i'lll make a pst

I have three subforms that i want to open optionally by using one open button after selecting the form that i want to open from a combo box. or open the subform when the value in the combo box changes. Please help

I know that it isnt advised to store the concatenated value but in this case, I have a memo field which is the description of a particular system component. i have Unbound Combo Boxes for descriptive elements such as COLOUR, SIZE, CONNECTIVITY, MAKE. ALL of these i would to store in a field...