Recent content by gebli

(UPDATE) I managed to display the values, I realized the text boxes needed to be unbound... that's why I was seeing all the records in the table, since the text box was bound to the table. Now the problem is that the loop goes assigning values to the same variable (the text box) so when I...

Hi, I searched the forum and found lots os thereads discussing how-to display query results in forms, sub-forms, etc. But I still can't figure it out. I have a form which is bound to a table. I want it this way because at form-open I don't have the query. The query is actually built using...

Thanks a lot. I will re-read it carefully but it looks that it will help me out. Gerry

Hi! I developed a query which has several nested JOINs in it. Since I need a few fields to be variable, I just use (e.g.) date1 instead of an actual date like "10/20/2008". So, when I run the query, I get a pop-up asking for a value for date1. In my query I have three of these variables, which...

I see... I'll do some research in that direction. Thanks!

Thanks MSAccessRookie for your prompt feedback. You did clarify how to run a query from within VBA but where is the returning result stored? That is: if the query is a count(*), how can I display the result in a text box? Thanks again.

Hi - I hate to ask this question because I'm sure somewhere in the forum is the answer, but I just could not find it and I need to start moving... Can anybody help me by providing a simple example showing how I can attach a query to a form object? I mean: I need to show several boxes...

Thanks! Great news... My fault for not paying attention to an alternate syntax of the case statement!! Gerry PS: edited a previous reply... Boblarson's response came in while in edit mode!

Hi, I think this is pretty easy but I just can't find it... Is there a way to check if a variable has one of several possible values? I know I can use a CASE statement but I'm looking for a simpler method. Something like: IF variable1 IN (value1, value2, value3) THEN true else false end if...

YES! It did work (just some minor adjustments to the field names). Thank you very much! Gerry PS: Thanks for the formatting advice ;)

Hi, I need to (sort of) combine LEFT and RIGHT JOINs, or something like that. Better with an example: Table1: ID Name Value1 Check1 1 John Book Invalid 3 Mary Pencil Invalid Table2: ID Name Value2 Check2 2 Rick North Invalid 3 Mary South Invalid Needed Result: ID Name Value1 Check1...

Just brilliant - Thanks a lot for the solution and its explanation. Gerry

Yes, it does work perfectly. Thank you very much. I am not quite sure to understand the logic behind it. Let me try... The LEFT JOIN will bring A.NAME but since it will not find a matching B.Role it will leave it blank (or null) - though still displaying the A.Role. Am I right? Gerry

Hi - Just found this forum and it looks like it is what I was needing. I am trying to move work from Excel to Access and don't know how to replace the vlookup function... Scenario is quite simple: Table A: (Name, Role) Table B: (Type, Role) I want to create a query that would indicate...