Search results

Hello again... So, I've downloaded the "Zombies ComboBox"... and well, I can't get pretty well the use of it. I mean... is this related to the Value List issue I posted in the beginning of this thread? or is it more related to Gasman's concern of a "feature/bug" natural to Access's ComboBoxes...

Greetings... yes, it works if the affected ComboBox is unbound; any way for it to work if the ComboBox is bounded to a Table (besides using a query, that is)? or is this part of the Access definitions and there is no way around? Thanks for the quick response :)

Greetings: I've searching in the web for a while and perhaps I've been foolish, but I cannot find a concrete answer for my issue. At Microsoft online Access API site, says that if I've a ComboBox with a rowsource as Value List, I can update it's values via VBA with a list of items (a String)...

Greetings: I know that this is such an old post; yet, more than trying to "revive it", I just wish to give my approach to this issue stated here. I've faced this same necessity nowadays, and came with this solution: For Enable/Disable all the Controls in a Form: For Each ctl In...

Now I get it; properties of other kind, like Value, might be VariantType, so they can receive several kind of data, but DefaultValue is Text, so, if I don't treat it like that with the data I assign to it (aka, "quotes"), the assignation will fail. Numbers, are casted automatically to String, so...

Mm... is there a reason why the DefaultValue property only accepts explicitly data in difference to other properties where Access assign the value in the variable instead of its name? Perhaps I'm thinking too much about the subject, bit it is quite interesting the behavior. Yes, I've done my...

Greetings: Yes! This worked! Me.FieldName.DefaultValue="""" & strValue & """" Could you please give the reason why this strValue="NewValue" Me.FieldName.DefaultValue=strValue does not work? This will be great for learning a little bit more of the principles of Access. Thanks again for the...

Hello! Yes, this is exactly what I'm aiming for... how can I make it work with Strings and not only numbers?

Greetings: Yes, the idea is that all the instances of the ComboBox in the SubForm will have the same DefaultValue based in the ComboBox at the MainForm. The challenge I've is to be able to do this via VBA and not the DesignViewer. Any thoughts?

Greetings dear Access Programmers fellows: As the title says, I'm trying to set the DefaultValue of a ComboBox in a Continuous Form on the fly, based of the Value of another ComboBox in the MainForm. I'm trying the following code without the desired result: Private Sub Form_Current()...

Oh! Yes... My thoughts is that this forum is used as an internet resource for answers... so is the case that today I reached this thread and found it useful :)

Greetings: Just for the record, this solution worked for me in a smoother way: = "$" & Format([field],'Standard') Regards

Ok... ok... amm... "Family" represents a sort of category for the materials. It is different than the "Color" (which represents another paradigm for categorization). It could be created another field called "Color", I guess, and such category would impact the materials as well. The numbers in...

Hello again jdraw: This is getting somehow "hairy" n.n"... lets see... The uploaded DB models my issue in the sense that, I believe, it would be too excessive to upload the whole business DB (besides, it would be too heavy in MBs), to show the problem itself (too much stuff outside the main...

Hello jdraw :) Thanks a lot for the detailed interest in all this. Right now, I'm uploading a DB that models directly my issue. I've tried to translate to English as much as possible. As it can be seen, the idea is that at InventoryForm, the user could "configure" the Query, and then, run it...

Hello jdraw! Exactly! This is my need (only that with numbers, not Strings). I can see that the suggestion is to read the values of a List and then create the final Query. Can that be done at the Query designer? or just by VBA + Report? (as suggested before by plog). Thanks again for the...

Greetings: Mmmm... I see. I can do like a sort of *auxiliary table* for the relationship (or "translation") of the ID's to Strings. So, I guess that my approach was out of place. The answer is, then, that Access will always input as Strings a parameter to a Query, isn't it? (just for the sake...

Greetings jdraw: Sorry for my clumsy description of my need. I'll try to be as clear as my English is capable to explain: I've got a Table with several registries, from which they are classified with a special ID (not the pk). I wish that the user, after selecting a element from a ComboBox, a...

What I'll have to do (I wanted to avoid it: it seems not possible), is to make a Query for *each* numeric combination; that is: 1 query for: IN (17) 1 query for: IN (1,8,16,30) etc.. Thanks a lot for the help... I've for a limit and it's important for the considerations in my designs. If any...

Hello Ranman256! Thanks a lot for stopping by and help; I receive the next message: "The expression is too complex to be evaluated". The phenomena is the same: if I put a single Integer, it works, several, fails. Any ideas? Thanks a lot in advanced :) p.s. It all seems that plog's reply came...