Recent content by DoctorJDM

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

Hi When adding a person to a contacts form I'm checking for existence of the same name already in the contacts table. I've added the code below as a BeforeUpdate procedure on the forms's LastName field, where qryCheckName is a simple query taking the form's FirstName and LastName fields as...

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

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

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

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

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

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

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

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

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

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

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

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

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