Recent content by CraigBFG

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

That worked perfectly - cheers!

Thanks for that. That's great for the future, but I really need to remove the time element from the existing data. Is there anyway that I can achieve this, maybe with an update query or something fancy? Thanks

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

So, even though all users are maintained in a single table, the PK can be referenced to twice in another? Then in relationships, you have to enter the same table twice : t_Users --- T_Sites ---t_Users_1 A developer is responsible for a site. A client owns the site. Both developer & client are...

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

Hi That's how I managed to sort it in the end, a 2 query-query. Shame it can't be a single query. Thanks for your help.

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