Combo Box Edit 1

[Guest_imported]

When the user attempts to edit a combo box entry, upon typing the first character, they get yelled at with a Parameter value form. The client wants it removed. Does anyone know how to suspend this in Access '97?

 

[elizabeth]

Have you looked at the Properties of the combo to see what the row source is. Possibly a parameter query, in which you'd need to remove the parameter. Or have you checked the events for that control, such as After Update, OnChange, NotOnList etc. for code pertaining to it.

 

[desiboy]

Sounds like the rowsource of the combo has a parameter. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=

http://www.matatechnologies.com>Mata

Technologies</a><br>visit

http://www.matatechnologies.com

 

[Guest_imported]

Yes, persuant to your suggestion, I decided that the After Update code, which simply reads Call SaveEdit, needed something more to it. The Limit To List property is set to No. There is a query associated with the row source, but, I don't understand how it's causing this problem. Thanks for your help and any other suggestions you have.

 

[elizabeth]

Open the query. If it has anything in the criteria row with opening and closing brackets, such as <i>[Enter the date:]</i>, you may need to modify or delete that criteria. What is the exact message on the parameter value form?<br><br>If you didn't investigated the&nbsp;&nbsp;custom sub or function CallEdit, take a look there also tounderstand what it's doing. It may have some error-checking in it.

 

[Guest_imported]

Ok. I deleted the criteria from the rowsource query ([Forms]![ReqOrder].[cboItemCat]), and, the Data entry from, which read &quot;Enter Parameter Value [Forms]![ReqOrder].[cboItemCat]&quot;, went away. Am I not going to be screwing up the query by deleting this criteria?

 

[elizabeth]

Do you understand what the selection criteria does? It limits or filters the recordset created by the query to those that match the criteria. It sounds as if the query was taking it's criteria from the form. You said the client wanted the parameter value form removed. So now you've removed it. If you've now found that the client misdiagnosed the problem and asked you to implement the wrong solution, join the club Just restate your problem carefully and we'll try to help you find a better solution.

 

[sliptdisk]

Thank you, Elizabeth. I appreciate your response, and, am going to discuss this with El Heffe and see what he wants mt to do. I'll post again, later.

 

[sliptdisk]

Ok, Elizabeth. Apparently, we're going to let sleeping dogs lie, on that one. I do have a couple of other issues to address, if you think you can help. This same program has a multi-line text box, with several fields for each entry (name, description, etc.). When the user double clicks on an entry, the value is passed to a text box for editing. The problem is, they need to save null values, sometimes, and, it's not accepting them. Also, I need to make the multi-line able to allow the user to rearrange the entries, from top to bottom, according to their liking, by dragging and dropping them. Any ideas on that? Thank you so much. I'm new at this and feel like I'm getting thrown to the wolves.

 

[elizabeth]

1. not saving null entries - check the properties of the field in question in the table's design view. Maybe you have AllowZeoLength or Required or something set to &quot;No&quot;.
2. multiline text box editing - doesn't sound familiar, so I'm having trouble picturing this...can the user simply use the windows cut and paste (higlight to select, hit Ctl-X, click on new location, hit Ctl-V) ? If by &quot;entries&quot; you mean records in an underlying recordset (table or query), and your user wants to sort them different ways, I know of no way to do that by dragging and fropping. A more common solution would be to give the user a control to manage the sort order in the underlying record source.

 

[sliptdisk]

Well, you go girl! That Allow Zero Length tip did the job! It had been set to No, after all. Btw, I AM, indeed, the artist formerly known as Coffee Achiever (I reinvented myself when I registered). On the multi-line thing - I made a big boo-boo, assuming that it was a text box. The person who designed this has no regard, whatsoever, for naming conventions, and, it turns out that it's a list box, not a text box. So, the question, then, would be - can I configure the list box to drag and drop, or, would something else, like a grid control, work better? Thanks, as always.

 

[elizabeth]

Drag and drop re-ordering is not a built-in capability of an Access listbox. Normally a listbox is ordered by an underlying recordsouce (table or query). What I'm trying to get across is that the listbox is just a display mechanism. To reorder what is in the display, the easiest way is to address the recordsource, not the display mechanism. If you want to set up some complicated code, you can achieve almost anything but the point of using a tool like Access is to use the provided built-in functionality whenever possible. So if for instance you wanted to allow the user to order a list of multiple values by filed1 vs filed 2 vs field3 or even ascending vs descending, you would create some kind of control to allow the user to indicate the criteria, then use that criteria to set the sort order criteria of the recordsource (query) underlying the listbox. Very similar to the form you just got rid of that sets the criteria for that query.

 

[sliptdisk]

Well, you sure saved me alot of time. I can't find any sort of control that will allow drag and drop reordering. So, it looks like I'd better try and string some code together. You've been a tremendous help. Thanks.

 

[elizabeth]

Glad that helped. Also you might be interested in checking out the listbox wizard article in the MS knowledgebase for an interesting twist on using 2 listboxes. It's old - from version 1.0, but it might spark an idea.

http://support.microsoft.com/support/kb/articles/Q97/5/18.ASP

 

[sliptdisk]

Hi Elizabeth,

After speaking with the client, I found out that what I need to do is to allow them to click on an item in the list box, then, after it's highlighted, click on an up or down arrow, off to the side, to move that record up or down, relative to whatever record it's adjacent to. Got any ideas on that. I've been looking around, but, not having any luck and the deadline's on Friday. Yikes.*S*