Search results

AfterUpdate event does not work The date needs to be updated when the subtotal control changes, this subtotal field has code in its control source that says =Nz([TotalCapAssCosts],0)+Nz([TotalOtherCosts],0) and this works well. What seems to be happening is that because the subtotal field is...

Re: auto-updating controls Nope - tried both of those (and most of the others), its starting to get frustrated

Does anyone know how I can update a control with the current date when the value of another control is changed? The prblem I'm having is that he control that changes is automatically updated itself (the addition of several other fields), so the on change event doesn't seem to work. I can do it...

autopopulating a totals box? Hi I've managed to base a form on a query and the totals box works - but does this mean I have to a subform for every totals box on my original form as the form is necessarliy based on a table as well? is it more efficient to do in VB and how would that be done...

I works... but only if done in the subform It works if I set it to "current record" - but only if I set it in the main form - I had tried previously but only in the subform - anyway c'est la vie. Thanks for the help Lex

Hi there I have a form (form) and a subform within it (subform) that is sync-ed to it via an tableID. The subform is in datasheet mode as I do not know how many rows will be need. My problem is that when I am in the subform and I'm tabbing through the cells, when I get to the last one on the...

Result! Does exactly what it should do - but why? Thanks Lex

Hi there This is my SQL select line MySQL = "SELECT ProjectDetails.*, TeamMemberInformation.* " & _ "FROM ProjectDetails INNER JOIN TeamMemberInformation ON " & _ "ProjectDetails.ProjectDetailsID = TeamMemberInformation.ProjectDetailsID WHERE " I am using it to perform a search on...

Hi There I'm using a generic search facility and having problems implemeting it. I get the error "Object doesn't support this property or method". The search code is below. Can anybody see the problem? There is a subform (searchresultssubform) in a main form (findrecord). The search in a...

Thanks Mile-O-Phile, Thanks Mile-O-Phile, that looks like just what I need - I'll give it a go after work tonight. Lex

Deactivating fields from response Hi All Can some one tell me how to "grey out" or certain fields of a form inactive depending on the response of a drop down box or tick box? For example: Do you have a bank account? - tick box yes; then allow entry of bank details; else leave the fields in a...

will give it a go! OkaY great, thanks alot - I'll give it a go later to night (after work) - Thanks for everyones help. Lex

Base your form on a query... OK, sounds great, but how do I base a form on a query?

auto populate a 'totals' box - New posting from replies Hi All Can Somebody tell me how I can automatically fill in a value on a form (and table?). I have several fields that record a length of time in hours on seperate forms. The final value is just the sum of all the other values. I'd...

using forms to produce queries Thanks dcx693 - I was dooing just that (using forms)! I've chnaged to what you suggest. Lex

Hi all I hope you can help. I have to write a query that creates statistics based on a drop down box. for example a drop down box that has higest exam level in it, GCSE, A level, degree, Phd., and a tick box for male or female. My query needs to return the number of males with "each" type of...

The openform line should read... Hey There - I worked out what i was after - thanks for looking the above line should have read: DoCmd.OpenForm FormFocus, acNormal, , "TeamMemberID=" & frmCallingForm.TeammemberID & "AND ProjectDetailsID = " & frmCallingForm.ProjectDetailsID, acFormEdit...

Hi all I need to open a form with both two necessary conditions, ie, the project number needs to be a cetain value and the bank number needs to be a certain value. Is is possible to do something like: DoCmd.OpenForm FormFocus, acNormal, , (("TeamMemberID=" & frmCallingForm.TeammemberID) And...

Hi There I have two tables (also forms) project (the primary table) and bank I'm trying to synchronise the two forms by setting the ProjectID field that they both have in common. It is a one-to-one relationship. If the projectID doesn't exist in bank then it should be created. If it does the...

Hi Is it possible to create a one-to-one realtionship between e.g., table_A and table_B, table_A and table_C... Table_A and Table_F. With referential intergrity whilst not all tables will have data in them (and therefore the record will not exist). And finally allow edits to existing data...