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!

Register Log in
  • Congratulations TouchToneTommy 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: brendanmc
  • Content: Threads
  • Order by date
  1. brendanmc

    calculated total field on continuous form duplicating on each row

    Hi, I have a continuous form which displays each record in a table. The form displays the records OK, but each row also has a total calculated field. The calculated total field works OK for one row but the total repeats itsself for every row instead of recalculating for each row. The...
  2. brendanmc

    simple list contents of a recordsetclone

    Hi, I currently have another thread open in which I'm trying to correct a recordsetclone problem. In the meantime, is there quick and easy routine that lists the contents of a recordsetclone, for example something that I can list in a msgbox? Thanks Brendan
  3. brendanmc

    run time error 3021. no current record

    Hi, I've been trying to nut this out for days with no luck (doesn't help that I program very rarely) I am receiving a runtime error 021. no current record. I can confirm that the record exists. I am using a form, that when opened is set to default as a new record. There are four fields. The...
  4. brendanmc

    form starts at middle of page instead of top

    Hi, I have form. Within that form is a tab box. Within the tab box is a subform. Whenever I click on the tab the screen position changes to the top of the subform, hence cutting of the header at the top of the page and the tab selections. Users then have to scroll up to see the top of the...
  5. brendanmc

    Not Exists in subquery retieves all records

    Hi, I'm trying to get a list of patients in one service that are not being seen by another service concurrently. I'm basing the consition on the patient ID. I have a subquery which lists all patients currently being seen which are not in the service I am trying to get the results for('2327' in...
  6. brendanmc

    How do I prevent access2000 displaying the convert earlier version msg

    I have an environment where there are users on Access 97 and Access2000. The database has been designed in access 97. When people login to the DB using access2000 they are prompted with a message to convert the database to version2000 or leave it as is. Is there a way to prevent this option...
  7. brendanmc

    cant code non-sequential group intervals

    I have a report where I need to group by age that are non standard, e.g. 0-17, 17-64 and 65+. currently I can set the age to every 1,5,10,15...(using standard access groupintervals) years but not with values that are non-sequential. I imagine I could use multiple queries to do this or even...

Part and Inventory Search

Back
Top