Recent content by Ishim684

Umph! Found it!!! Minty, here are the screenshots of the table and the form: [/url][/IMG] image share

Thank you, Minty! I'm afraid to appear an ultimate dummy, but I can't figure out how the 'Insert image' button of the message window works :D:banghead: Last time I pasted a Google Drive link to the screenshots but they didn't display properly. I've also tried pasting a path to files on my...

Hello, Minty, thank you for your response. What I’m trying to achieve is this. I have a table, tblMASAll which has a field ExcludeFromDisamb; some of the cells in this field contain the text “Exclude_All_Basic”. Then, I have a form, FORM2Copy which has a combobox cboDef. I want this...

Dear experts, thank you for your patience and your explanations ))) In the case described above I have now used a Recordset, as advised by The_Doc_Man in #1. It’s the first time I used Recordsets, and although I tried to build it properly, there is still some hitch occurring. When I try to...

Missinglinq, thank you for your valuable comments! In fact, I didn’t use names like “Table” or “Field” in my real code. But I thought that the real ones were longish and difficult to read for others, so I replaced them in my posts with what I thought were neutral names, just to improve the...

No, this value is not in this form; it is in a table (which is bound to this form).

Dave, thank you very much for your prompt response. Could you give me some pointers how this could be fixed? It's my very first project in VBA and in programming in general, and I definitely don't know very simple things, but I'm trying to learn. I would immensely appreciate you help.

Dear Access experts, here am I again with my new problem. I want to populate the RowSource for my combo box on a form filtering it by a value in the table field. I’m running the following Sub on the GotFocus event of the combo box (CBO) in the FORM. When I debug it, I get a compile error...

Dear All, I can't even express how I am thankful to you all for your incredible help! That was quite a lot of information for me to digest )))) But I made it! I ran an UPDATE query and it worked! Thank you for giving me this little triumph! :):):):):)

Dear Access experts, excuse me for asking questions about primitive things, but this is really confusing when you only start using VBA. I'm trying to do something totally simple: Dim strString As String strString = "TEXT" "TABLE.Field1" = strString I keep getting a syntax error. I guess there...

Oh, that's great to know! Thank you, Paul, you've saved me any possible fruitless attempts! :):):)

Oh, Paul, I've figured it out myself, after many trials and ordeals! I first built a query where all these fields were present, and bound the form to this query. It got to work! Sorry I bothered you. Thank you.

Dear Paul, may I ask one more question? This time I’m trying to design a form (FORM1) which is bound to a table (TABLE). The text field (Field1) in FORM1 is populated from the field Def of TABLE. But I want the values that enter FORM1!Field1 to be filtered by the value in the text field in...

Dear Paul, thank you SO much for your generous help!!! Your advice has been SO helpful to me!!! It took me a while to get it all work as I wanted, but now it's perfect -- exactly what I needed!

Dear Access experts, excuse me if my question is very simple, but I am entirely new to VBA. I need to write an IF... Then... Else statement where the conditions run the check whether a certain value is found in a table. Something like: If strString is IN [tblTable]![Field] Then But there is...