Search results for query: *

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

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

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

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

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

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

Have a form frmJobs with a set of separate subforms to calculate total costs of materials, labour etc. I'm bringing the subtotals from each subform into unbound fields on the main form, by setting the sources like this Field : ubdMaterials Source ...

Have a form that records events, the people taking part in a first subform, and the amounts collected by each person in a sub-sub form. So the hierarchy is frmEventName - single form view contains sfmParticipant - single form view contains sfmParticipantAmounts - datasheet view On...

Hi Have a main form with subform in datasheet view that builds a history of transactions. The history is getting long and it's tedious for users to have to scroll down the list every time when adding records. What's easiest to resolve this? Tried adding a command button on the main form to set...

Have form which on repeatedly going to new records just keeps saving them even though nothing is being added, so ending up with lots of empty records. I've used this procedure to check if the most important field is blank. It sort of works but eventually causes an untidy exit from the form when...

Have a Company form where contacts are entered on a subform. On a Jobs form containing the Company field I'd like to be able to pop up a list of the contacts for that company, pick one and enter it onto the Jobs form. When new jobs are created for a company the relevant contact for each job...

Hi Have this union query to list all items making up a Job SELECT QuoteRef,Description,Cost,Type FRoM qryActualComponents UNION SELECT QuoteRef,Description,Cost,Type FRoM qryActualHours UNION SELECT QuoteRef,Description,Cost,Type FRoM qryActualOtherItems UNION SELECT...

Hi In a subform displayed in datasheet view I need to produce an index number for rows as they're entered. The subform creates a sequence of invoices for any particular job, and given the index number I can then identify the invoices for say JobRef 1234 as 1234/1, 1234/2, etc. I'm taking the...

Hi This should be trivial but is causing a problem. Have an order form fed by a query based on two tables. The Customer field in one table has a lookup to a Customers table, with the Customer field as key. This allows the form to pull in the Customer's address when any Customer is selected...

Hi Have a quote/job process where a quote is built up in one form with a QuoteRef. If accepted a status field is changed to Job and a JobRef is allocated. The tables behind the Quote build up data on usage of Timber, Components and Hours, and contain both quoted and actual values in each case...

Hi Have an order form whose contents need to be saved if a user hasn't completed all details and/or switches to another window. Have tried using On Deactivate to put up a warning asking if the record needs to be saved. Only trouble is it's too enthusiastic and triggers if any other command...

Hi all Have situation where a client receives payment for orders as a schedule. The schedule can be up to 6 monthly payments, depending on the order value. The data has to be extracted from a table that gives OrderNo, TotalDue, FirstPaymentDate I can get to a query that calculates the...