Search results for query: *

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

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

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.

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

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

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?