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 strongm 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: *

  • Users: pmp1
  • Content: Threads
  • Order by date
  1. pmp1

    Centralising code for multiple forms/subform to access

    Hi! I have created a record browsing window (data is displayed in datagrid in subform) which includes custom navigation buttons (first, next, last and previous). The custom buttons are disabled as appropriate (e.g. if at the first record, the GoToFirst and GoToPrevious buttons are disabled)...
  2. pmp1

    RecordCount not working

    Hi! I have reviewed the many other threads on RecordCount and have no reason to think my code should not work, however, it returns the incorrect answer. Private Sub Form_Load() MsgBox(Str(Me.[ctrlPatientBrowser].Form.Recordset.RecordCount)) End Sub ctrlPatientBrowser is a subform - datasheet...
  3. pmp1

    Order of Events

    Could someone please advise where I can find out the order in which some of the events associated with forms and fields occur? Obviously some only occur when an action occurs, however, I believe there are times when several events occur upon a single action, e.g. opening a form. Thanking you Peter
  4. pmp1

    Combo Box limiting another combo box list - selection issue

    I am running Access 2007 on Vista Business. I have used faq702-4289 to get one combo box controling (filtering) the list on a second combo box and it works very well. However, what doesn't work is: (1) as I cycle through records the second combo box does not display the record from the...
  5. pmp1

    Combo Box - Color Problem

    I have searched the logs for my problem without success. I am running Access 2007 on Vista Business. I am using a new Lenovo laptop with 2Gb ram etc - no spec/performance issue. I have a small database with two forms. One form works perfectly, however, the other form causes me problems in...
  6. pmp1

    How do I filter a subform as the user enters a surname?

    I have found a thread [thread702-1209629] that seems to answer my question, however, that answer is not working for me. I would appreciate some assistance in identifying where I am going wrong, to which I'm sure it is to with referencing and have looked up many threads on this but I have still...
  7. pmp1

    Displaying subform information in datasheet AND normal view

    Hi all, I am using Access 2003 and remain a novice with Access, but improving. I have a main form (customer details) with most of the customer's details displayed on Tab Pages. I also have a subform on the first Page of the Tab displaying visit details. The subform is displayed as a Datasheet...
  8. pmp1

    Query - Date group sorted in alphabetical order not date order

    thread702-1199776 is close but does not answer my question. I have created a query, grouping visit dates by months (and have also include cost of all visits per month; number [sum] of visits per month; average visit cost; min visit cost; max visit cost, which all works fine) However, the dates...

Part and Inventory Search

Back
Top