Search results

I would have a master tbl for the Child, with ChildID, Autonumber, PK. As each questionnaire can be filled out more than once per child then you will need 10 questionnaire tbls, each of them with ChildID, Long, FK and a fld "DateEntered" or similar name for each of the 10 questionnaires. All...

If I'm right in assuming that Orders involve Customers, Products and Drivers, then all the ID's you have at present will be PK's and the Orders tbl will need CustomerID, change Stockcode in Orders to ProductID and change Driver in Orders to DriverID. These 3 flds will all become FK's. All the...

What is the Data Type for both those flds.

How interesting - we both arrived at a very similar method. I've just looked at your db. Meanwhile, "Access09", has your problem been solved?

I have attached db1 for you to look at. It is very simple to do - I used an update qry. But you must have the following done: 1. Go to Windows Control Panel -> International and set the date as "dd/mm/yyyy". 2. In my db you'll see the Date fld formatted as "dd/mm/yyyy". Do the same in any...

If you create another qry using "qryDFAT" and "qryDFByEmployee" and join using "EmployeeID", then you have the recordsource for a rpt. As you can see, qrys can get quite complicated; tbls and qrys joined and qrys cascading ie 1 qry built using other qry(s). Alternatively, you might have to...

A few comments on the above: The LimitToList property must be set to Yes for this to work. Have you done that. Why do you need the "Else" and the "Response" line after that. If you "Exit Sub" it can't get to the "Resume" line.

Could you give a brief rundown of what the critical flds, in particular the join flds, are in the tbls. Have you applied the "hotfix" as yet. Site is http://support.microsoft.com/kb/945674

Attached a new db (db2) with a total (qryDFAT) DateFilteredAbsenceTotal and by Employee for Date Filter.

Why do you subforms and a sub tbl if the 2 tbls are 1:1. Subforms are designed for 1 record in main tbl and several in the sub tbl ie 1 : many.

Use the Dirty method and the BeforeUpdate event of the form. If Me.Dirty Then Me.DateModified = Date End If Before and AfterUpdate events: The recordsource of the form is available to the Form BeforeUpdate event but not to the Form AfterUpdate event. ie BeforeUpdate: The following works If...

I think you need something like the following: AfterUpdate event: Fld1 = me.cboYourName.YourControlname.Column(0) Fld2 = me.cboYourName.YourControlname.Column(1) etc. for the 8 columns(flds) you wish to add.

The junction tbl can't have PK's - it must have FK's. The PK's must be LandID & OwnerID in the other 2 tbls. ie Land to Junction join 1 : many Owner to junction join 1 : many

You might be able to fast track this. Copy the db and its associated mdw to a safe location, then overwrite the existing mdw file with a "vanilla" system.mdw, giving the system.mdw the same name as the "security.mdw" file. I got something like this to work as the site had "crashed" and I tried...

Perhaps it should be in "trainingitems" as that is where the PK for the qry is.

You have a form and a subform. Here are some assumptions and questions: The form "UpdateTrainingRecords" has the "employee" tbl as its recordsource. The tbl "employee" has the PK emp_id. The subform "xxx" is set as a continuous form and has a qry generated from the 2 tbls "trainingitems" and...

Is StoreID in all 3 tbls. "$/Case" means $ divided by Case - use "$_Case" as a fld name. At the moment, what are you using to join the tbls?

Go to the join line between the 2 tbls in the qry and rt click. Select option 2 or 3 (whichever will show all the records in the reqd tbl).

Had a very similar problem with a site. For some weird reason the auditors wanted the recordID and the record number from Access to match. I had put in an Autonumber fld but within a few days was instructed to do what they wanted - the first delete got the nos. out of synch. I tested the...

Does the code execute. I would put a breakpoint in the code and step thru it using the F8 key. Alternatively put a MsgBox "At OnClose Event" in the Event.