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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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
  2. aucamusc

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

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

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

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

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

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

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

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

Part and Inventory Search

Back
Top