Search results

Hi all I've tried to follow the MS example in http://support.microsoft.com/kb/210039 which works for just 2 tables, but I have more! tblDistances / tblRaces / tblResults. Each race has a single distance - there are many races with the same distances - each race has many results. So the...

Pulling my hair out with this one! :mad: Append/insert records which exisit in the template table but don't exist in the working table against a specific Project ID. The working table contains MANY other records relating to specific ProjectID's. So the actual process should be...

Hi I'd like to be able to filter a form (fed by an underlying query) by using a toggle button setup on the form itself. My simplistic pseudo-code would go something like this. Default state List all records where DateRemoved is Null. Toggle state List all reocrds where DateRemoved is NotNull...

Can anyone help..... I'm trying to import/link a single excel cell reference value (Currency) into a specific field in an Access table. The field must remain uptodate as and when the excel sheet changes, but will also be different for every single database record. I've got the file reference...

I've got a small problem with a calculation on an ASP form, and I've tied it down to the date field in the db. Basically, because this certain field records date & time, the calculations are off slightly. Is there any way that I can strip out/delete the TIME data from the date/time field? eg...

I'm attempting to create a query that will append multiple records to a second table based on the selection from a subform (datasheet view). However, when I run the query, it only appends the first record in the selection, ie lots are greyed/selected but only one record seems to be...

I'm trying to calculate the number of holidays a person is entitled to based on their leaving date. For every 18.25 days, the employee is entitled to 1 holiday, then deduct those already taken and your left with the balance of entitlement. Eg StartDate : 01/01/2004 LeavingDate : 01/10/2004...

Is there any way that I can create a record in another table based on the ID of another, when a new record is created. Eg Create a new employee record Insert this new records ID into tblTraining. I could use a button. Is it possible to say "show button only if form is DataEntry/New Record"...

Is there a way that I can say... If Course_Expires? = Yes then Course_Expiry=IsRequired. I've managed to get the DateExpiry field to enable/disable based on the Expires question? If Me!Course_Expires.Value = True Then Me!Course_Expiry.Enabled = True

Is it possible/good practice to have relationships from 2 seperate fields within one table to a single field within another? Eg TableUsers UserId / UserName / User Type data... 1 / TheCompanyLtd / Developer 2 / TheOtherLtd / Client 3 / Company215Ltd / Client TableSites SiteId / SiteName /...

I'm trying to create a query that will look at 2 tables to calculate remaining holiday. EmployeeTable has a field HolidayEnt (entitlement) AbsenceTable can have many types of absence, of which one is holiday. I want to calculate remaining holiday based on "HolidayEnt-sum(AbsenceTable.DaysOff)...

Can I modify this statement to so that 1. If enabled, data is required. 2. If disabled, value is nulled Why? 1. If paid in advance, a DatePaid is required. 2. If paid in advance=Yes and date is entered, then user for some reason changes back to PiA=No, DatePaid field should be nulled out -...

As we all know, autonumber generates despite a record being saved. I have a small script which does generate the next job number but I need it to be a bit cleverer. Set rst = CurrentDb.OpenRecordset("SELECT Max([JobNumber]+1) AS NextJob FROM Jobs") If Not rst.EOF Then...

After I save form data, how can I force the cursor to go back to the first field on the form - ready for a new record? Thanks.

When I launch certain pages, reports from the db the properties box sometimes appears as if by magic - WHY? Can I stop this from happening? Thanks.

Is there such a thing as "OnPrint" action. So when a report is printed, that I can code in other DoCmd functions, such as RunQuery etc. Thanks.

I'm looking to requery a Company listing after entering a new record, but am have difficulty. From my CompanyListing form, I click on NewCompany which takes me to a blank form to complete. On saving the form, it closes and takes me back to the listing. However, the new company is not shown...

I'm looking for the best method to mark an invoice as paid. What I've come up with is as follows - comments? 1. Query invoices between dates 2. Form produces list of invoices with DatePaid = Null 3. Question - Are you sure you want to pay? 4. Yes - Query - Update DatePaid=Now() where InvDate =...

I need to run a query/report which contains 3 unrelated ledger tables related to a single contract table. However, if I simply enter these fields, I get what I can only describe as "cascading duplication" where there are no records IS there any way to do this without running 3 seperate...

I have a sales invoice form which populates from a query which performs certain calculations - pretty simple stuff. However, i want to make it a bit clever so that I can maintain a "My Company" section which has things like VAT rate etc. So when the invoice is raised for Joe Bloggs Ltd, the...