Dear MajP, your help have being invaluable, The problem was solved adding DISTINCT to the source quey, now it works find.
Congratulations for your outstanding support.
Thanks a lot,
aucamusc
This is what I got after recreate combobox (works find):
Row Source: SELECT [qryBuscaApep].[Apellidos], [qryBuscaApep].[Nombres], [qryBuscaApep].[Ficha] FROM qryBuscaApep ORDER BY [Apellidos], [Nombres];
Control
Bound: 3
Col Count: 3
This is what I got after closing and reopening the db...
This is all the code it has:
Private Sub Ape_AfterUpdate()
Me.Ficha = Me.Ape.Column(2)
End Sub
**********************
Ape = Combobox name
Ficha = Textbox name
By the way, I recreated the whole database, except the linked tables, which I linked after the import of the objects.
Behaviour...
Thanks a lot MajP for your attention.
I have compacted and repaired the databasde, I recreated the combobox, and it works find testing with many calls of patients, but as soon as I close the form and open again, it doesn't work. This is my first system under W7 platform.
Thank you again. I'll...
Pls. in spite I have been working many years with Access this is the first time I have this problem.
I have a form with a combobox and a text box, fields in the combobox: Id, surname, givenname. Surname y givenname ascending.
The first time I type surname it shows exactly what I need, surname...
Excuse me, there was something wrong with the typing.
I meant in this suggested coding:
Name: txtCountTimes
Control Source: =Count(*)
Visible: No
I replaced the asterisk with an "F" that it is the name of the control that supports the date.
With the asterisk I had always an error.
Now it is...
Excuse me Duane for the delay.
Unhappily I don't know what is happening with my PC in which I canno send you replies.
About the theme, I checked every letter and the whole spelling was OK.
Instead of the (+) I used the control F (which represent the date and it worked.
What's happening with...
Thanks Duane for your kind and quick answer, I follow your instruction literally, unhappily when I open the report I get the following pop up message:
"Insert parameter Value" (really it is in spanish, so this is a rough translation).
"txtCountDate"
a txtbox, and last line: "OK Cancel"
If I...
Hello!
I need some help with a simple report,
It's a monthly timing report for the personal.
It has 5 columns: Id, Date, clock in, clock off and difference (active time), like that it works fine.
But I was asked to place a total in a 6th column just at the level of the last movement (last row)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.