Alvaro Mendoza
Last Activity: Dec 13 '11, 04:26 AM
Joined: Oct 24 '11
Location:
-
I know, sorry, I read the instructions, but when I tried to save the DB as 2003, it said it could not. Is there an alternative way to do this? I could send the tables, and then the forms (dividing the DB) will that help? -
Dear NeoPa,
This is exactly what I don't understand....Leave a comment:
-
Dear NeoPa,
I know the value is what was supposed to be, and actually, it only needs the [c_ficha] value, since it is the key for the Fichas table.
I ran the query, and this is the result:
"([c_ficha] = 11) AND ([Nombre] = 'Gabriel') AND ([Apellido_P] = 'Giulietti')"
I think it's the right one.
Now, the form is FormMenu, the container is [SubQryInfoUtilP roximasPartidas]. I don't...Leave a comment:
-
Hi, NeoPa!
First of all, you do not need to apology! It's me the one using your time! So thanks and sorry for the unclear content.
I did try your code, but to no avail. The answer was exactly the same as before: it did not bring up the register I was clicking.
Your assumptions are correct: [Nombre] & [Appellido_P] are strings and [c_ficha] is numeric.
The sub-form is called [SubQryInfoUtilP roximasPartidas]...Leave a comment:
-
Thanks for your patience. Since I'm a rocky in VB, it takes me time to get to what you are asking. I'll try to answer now.
nombre, apellido_p and c_ficha are text boxes in a subform "SubQryInfoUtil ProximasPartida s" that is a result of a query in the form of a spread sheet. All the info comes from a single table called "Ficha". There is a form "MenuFrm" which has the sub form as part of it.
I...Leave a comment:
-
I tried to work this out, but to no avail. This is the code I wrote:...Code:Private Sub nombre_DblClick(Cancel As Integer) Dim personaID As Integer Dim personaName As String Dim personaApellido As String Dim ConditionSelection As String personaID = Me.c_ficha personaName = Me.nombre personaApellido = Me.apellido_p ConditionSelection = "[c_ficha]Leave a comment:
-
Hi, NeoPa,
Sorry for the delay in getting back to you.
FOA, thanks for the clarification, I actually did not pay attention to the fact I was not giving an object.
Second, the problem is now in a "type mismatch" situation:
This is the...Code:Call DoCom.OpenForm(FormName:="Fichas", WhereCondition:="[c_ficha] = " & Me.nombre![c_ficha] & ";")
Leave a comment:
-
Hi again, NeoPa.
1. Funny as it is, [SubQryInfoUtilP roximasPartidas] is a Form (as I told you before, I inherited this development :-))
2. [c_ficha] Is an Integer, which indicates the Key of the main table (named Fichas) I guess the first developer called it as a short for "code_of_the_fi cha", though I wanted to change it to [PeopleID]. But the amount of code to change (and the inestability) would have been major!...Leave a comment:
-
Hi, NeoPA,
First of all, thanks a lot for answering.
c_ficha is a variable I inherited from the original programer. is the key for the main table, from where I selected the data to fill the form.Code:[Forms]![FrmMenu]![SubQryInfoUtilProximasPartidas]![c_ficha]
the rest was my last trial: is a way to extract the value again from the selected record. In any case, I tried also:
...Code:"c_fi
Leave a comment:
-
How do I Pass Values to Forms
I tried to pass data to a Form (to open a certain register from a list into a Form). I used DoCmd.OpenForm procedure, and passed the data. but it does not work. Can somebody help me?
And I watched the correct value in c_ficha, when it was called.Code:DoCmd.OpenForm "Fichas", , , "[c_ficha] = [Forms]![FrmMenu]![SubQryInfoUtilProximasPartidas]![c_ficha]"
No activity results to display
Leave a comment: