Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by aucamusc
-
Access 2007 combobox doesn't work
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- aucamusc
- Post #10
- Forum: Microsoft: Access Forms
-
Access 2007 combobox doesn't work
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...- aucamusc
- Post #7
- Forum: Microsoft: Access Forms
-
Access 2007 combobox doesn't work
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...- aucamusc
- Post #5
- Forum: Microsoft: Access Forms
-
Access 2007 combobox doesn't work
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...- aucamusc
- Post #3
- Forum: Microsoft: Access Forms
-
Access 2007 combobox doesn't work
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...- aucamusc
- Thread
- Replies: 9
- Forum: Microsoft: Access Forms
-
Total special location on a report
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...- aucamusc
- Post #7
- Forum: Microsoft: Access Reports
-
Total special location on a report
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...- aucamusc
- Post #5
- Forum: Microsoft: Access Reports
-
Total special location on a report
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...- aucamusc
- Post #3
- Forum: Microsoft: Access Reports
-
Total special location on a report
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)...- aucamusc
- Thread
- Replies: 6
- Forum: Microsoft: Access Reports
