Search results

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 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()...

Greetings: I'm trying the following statement to work: SELECT myField FROM myTable WHERE IN ([Forms]![MyForm]![myFormField]); This is done at the Query designer; as it can be seen, it is dependent of a field at a Form. By far, this works only if the field contains a single value (in this...

Greetings: I hope this is the correct place to ask for this. What I'm trying to do is to compare the result of a DLOOKUP with a value; this sentence is part of a field defined at the QUERY DESIGNER. It works fine as far as it is compared with a static value (a explicit String). My definition is...

I've ALREADY solved this; the code I'm posting worked for me; I hope that it would be of help for any other one with my same issue. Thanks a lot for all the gentle interest of all the crew at this forum: you guys really encourage us to keep forward with you sincere concern! :D...

Greetings: I'm wish your help in a query concept; I'm pupulating an unbound ComboBox with a Query via the QueryDesigner. The value of the Rowsource depends on the value of another ComboBox at the main Form. After several hours of trial and error, I came to the solution showed at the attached...

Greetings: Perhaps I'm violating some good practices / forum norms, for the title of the post: please let me know how can I improve it :) My issue I ask for help, is of a saved query which I would like to emulated with VBA. The whole idea is to update a set of a table's fields based in the...

Greetings: I'm quite new at the community; I know that all here is done with genuine intention of helping, and there is no obligation of the members at the community to give a proper response to the user concerns. Yet, I'm a little bit stuck, and I would like to know how I can ask for help at...

Greetings: I'm facing a weird bug where at a calculated field (which value is obtained by the subtraction of other previous fields at the same form, helped by VBA code), the result comes with a 1/10^15 (±0.000000000000001) difference. So far, the calculations that have given me troubles...