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 Chriss Miller 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: DoctorJDM
  • Order by date
  1. DoctorJDM

    Check that person being added to form isn't already present

    Hi Guys Always know I'm in safe hands with you two. The Me.Undo is what I needed (and forgotten), thanks. It seems to me it's better having the BeforeUpdate on the name field rather than the form - otherwise wouldn't the latter fire off when scrolling through records having allowed a duplicate...
  2. DoctorJDM

    Check that person being added to form isn't already present

    ...LastName field being set to null when setting the FirstName to null is ok. Or maybe there's an easier way of clearing all the fields in the form? **************** If DCount("*", "qryCheckName") < 1 Then Exit Sub End If Dim stDocName As String stDocName =...
  3. DoctorJDM

    Query parameters set by form

    Great - thanks SoCool. That did the trick. Set - combo's value list Row Source to 0;"Yes";-1;"No" - Default value to 0 In the query I couldn't immediately get it to show results, cured by taking out the criteria for ExplorerArea and adding extra column with Field ...
  4. DoctorJDM

    Query parameters set by form

    I have a form frmMergeData containing two unbound selector fields, SelectArea and SelectStatus, and want to pass their values to a query that is the source for an embedded subform. Passing SelectArea, which is a text box, to the query's Area field works fine using the criterion...
  5. DoctorJDM

    Split Database Backup

    Thanks guys, first to Genomon for the lead, then picked up by jbrbarnett. The FileCopy command worked without need for scripting and without problems of 'file in use' since it is the backend database I'm backing up from the front end. Used simple OnClick procedure to create copy with date...
  6. DoctorJDM

    Locking Subform

    Have a form frmHospitals containing - a set of controls including HospitalID - a subform sfmRestrictions showing restrictions applying to the current hospital, as a single field in Datasheet view; linked by HospitalID - a second subform sfmContracts also linked by HospitalID, containing a set...
  7. DoctorJDM

    Split Database Backup

    Thanks Genomon Looks like I need to do some learning on this one.
  8. DoctorJDM

    Split Database Backup

    Thanks Genomon, I'm sure you're right. Any pointers to doing it? David
  9. DoctorJDM

    Split Database Backup

    Hi all Have a split database and would like to back up both parts from a command button on a front-end menu form. I can use a simple command like this for the front-end If MsgBox("Do you want to back up the database?", vbYesNo + vbQuestion + vbDefaultButton2) = vbYes Then CommandBars("Menu...
  10. DoctorJDM

    Pass extra parameter to report

    Thanks guys, works fine. It also gives me a way of doing a quick and dirty mail merge without going near Word.
  11. DoctorJDM

    Pass extra parameter to report

    Hi Is it possible to pass a block of text to all records in a report? Have a report based on a parameter query and it would be very useful to be able to generate an extra block of text that would appear in all of the report's records. The parameters are passed to the query from an unbound...
  12. DoctorJDM

    Report based on parameter query

    Have a command button on a menu to launch a report rptHours based on a simple query qryHours that uses [Enter Start Date] and [Enter End Date] parameters to define a date range, as below. PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime; SELECT tblCoordinatorHours.Hours...
  13. DoctorJDM

    Look up names and Not In List

    This is a pretty basic question about looking up people's names then pulling in extra data about them, starting from the position that I want names stored as separate FirstName and LastName. In the Northwind Orders form there are two lookups, both using the technique of a combo box with an ID...
  14. DoctorJDM

    Show extra records in report

    Thanks Duane That looks to be spot on - I'll adapt it to my needs. Really appreciate your time.
  15. DoctorJDM

    Show extra records in report

    Sorry Duane, must be missing something. I created a new database to replicate what I'm trying to achieve but simplifying to make sure there were no glitches in my original. As before, Access only allows the HomeType table to be added to the query by creating a new query combining the two...
  16. DoctorJDM

    Show extra records in report

    Thanks My post was slightly a simplified version so here's the fuller background. The main form shows data for Supervisors, with a subform containing the Hours recorded against people they supervise. The subform's underlying query is derived from a qryContacts (Names of the people supervised)...
  17. DoctorJDM

    Show extra records in report

    Thanks Ralph but no joy. HomeType is just a lookup field at present. Adding the HomeTypes table to the query underlying the report doesn't change the data set for any of the join types.
  18. DoctorJDM

    Show extra records in report

    Slightly odd request from a client. A report shows activities occurring by Area, each area having a fixed set of HomeType options (say A, B, C, D, E), each HomeType having hours, activites and dates recorded against them. The report asks for a start and end date and then it's just the total...
  19. DoctorJDM

    Report calculations

    A report displays hours spent on various activities for staff members, grouped according to their supervisor. All the calculations have to be done in the report, whose structure is Supervisor Header Detail StaffName Date Activity1Hours Activity2Hours Activity3Hours David Smith...
  20. DoctorJDM

    Copy unbound to bound field values

    Thanks Ace Which is the best event to trigger this if I continue? Otherwise, if the data doesn't go into a table how would you use it in say a report that outputs the details of several Jobs?

Part and Inventory Search

Back
Top