Search results

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

Greetings: In my case, the problem was in the synchronization between my Form and its related Table (it was not ready by just creating a new record). It got solved by including a Me.Refresh before I tried anything else with the Form. I hope this might help someone else in the same issue. Regards,

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... Could you expand a little bit your explanation? I just couldn't catch it :confused: ... Thanks a lot in advanced.. Regards,

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: Just for helping anyone in my same situation; I was having troubles with the conditional formatting ... Googled for a couple of hours, this forum, etc.. :banghead:... until I reached this post. The trick is as direct and simple as CJ_London said: + Go to "Design View". + Select...

I knew it... this forum kicks ass n.n ... (Please forgive if this comment is out of place n.n")

Thanks for the tips Galaxiom: I'll try to be more careful with the formatting, so it'll improve the way to present things :) (y) And about this specific subject... yes, I'd no idea how could I tell to the VBA that I was referring to a field and not a control of the present form; so, your...

lol n.n... actually, your sentence was properly expressed and has the whole sence. I appreciate deeply for the great community you have got: its quite harsh to have doubts in this issues and have no place to run for help.. Gracias :)

Hey, that worked!! Thanks a lot Galaxiom for giving yourself the chance for helping.. This forum is truly helpful and professional :) My best wishes... and thanks again:)

Greetings pbaldy, thank you for passing by and give your view: It is important to now that I'm able to set a value to Null, previously knowing that the field is configured to accept it... Regards

Greetings Galaxiom: Thanks a lot for passing by and give a hint about this issue; mm.. you are right, I got a mistake, if the real original query is: UPDATE EntradaPatiosDetalle SET EntradaPatiosDetalle.precio = IIf([Forms]![EntradaPatios]![patioCheckBox]=True,[precio_patio],[precio_pyme])...

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

Hello Simon, nice to salute you once again :) Thanks for your help and suggestions; I've finally implemented what I was looking for. I've done the following: * Took the "hyperlink" property of the ImageControl, so it would let me do the "thumbnail -> physical file" effect that I was looking...

Hello Simon :) Thanks a lot for the amazing reply!! .. I'll take the time to study and understand your approach. I'll give my feedback as soon as possible.. for what I've been able to see until know, it seems great! Regards :) Javier

Hello again Simon: Thanks a lot for the quick reply; I've modified the AccessDB file so it shows all the context of this request (attached to this message). It contains: + A table with 2 registries (aka, 2 clients) - The last 4 fields of the table are OLE objects, which are *.bmp files that...

Hello Simon: First of all, thanks *a lot* for re-considering this old thread... some people had me loose any hope I had for any help about here.. so, your interest is *really* appreciated :) But well.. I try to do my best for explaining the situacion. This portion of the system intends to...

Greetings: So, your advice is better to not ask for any further help as I lost the chance? Please let me know how possible is to recieve a sort of help: it would be quite appreciated to recieved it: I want to solve such thing. Thanks for the concern; regards,

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