Search results

OK Tech, I knocked this example together to help explain my method - I have not created queries and I've used a Combo for the person selection for ease. But it will show you one way to do what you are after. Look at the RowSource and afterupdate for the combo, and look at the Master/Child...

So the job no. is the Primary Key and is a 1 to many relationship with the other table? I would have thought that in the main table you would have had a primary key of PersonID which would be the 1 to many with the other table. Then, each Job would have two identifying fields - 1. PersonID...

Try this Module - It creates a new function called IsNothing() It's a better function than IsNull() Function IsNothing(varToTest As Variant) As Integer ' Tests for a "logical" nothing based on data type ' Empty and Null = Nothing ' Number = 0 is Nothing ' Zero length string is Nothing '...

How does the subform know which person's jobs to find? Is there a field on the main form?

Can you set the field(s) to " " (SPACE)? Dave E

Have you set the subforms property to either Continuous Forms or Datasheet? If not, the form can only show one record at a time. HTH Dave E

From what you say I would assume that you want the date field on the form to take the value from the user and save it in the new date format described. Yes? Dave E

You would define which record you would want to print using Criteria like - DoCmd.OpenReport "MyReport",acViewNormal,,"[MyField]=Forms!MyForm!MyField" The last bit is the Criteria and is basically - [MyField] is the name on the unique fieldname of the record that identifies the record you...

Start a new Query using the QueryBuilder. Add the table(s) to the query that hold the person's name and the jobs they've done. Drag the person fieldname and jobsdone fieldname to the query grid. Save the query and use it for the source of the subform. Create the main form and subform and on...

It would depend on you as the designer to where the code goes. If you wanted to save the date in this format it would have to be formatted elsewhere e.g. from an afterupdate on the control. You might want to have a visible control on the form where the user inputs the normal date and then the...

Hi lipin Why not have an additional field, perhaps a checkbox in the main table. The Auditor finds the error, fills in the error report and checks the box. The checkbox indicates that the error has not been signed off. When the employee arrives they run a search to find all the records with...

Hi Jon, It's easy to go off on the wrong track when reading these forum messages and to blindly speil off solutions to misunderstood problems. But I think I'm with you on this one. On the main form, could you have the combo where you select ther 'Other' option and if the Other option is picked...

I've seen this when a field gets its value from elsewhere e.g. a calculated field from some other field(s) and then something else comes along and tries to input something else. The field, being already bound to some other source, rejects other attempts. Have a good look at your control sources...

Hi Jon, I would consider another table called say, 'OtherInfo', which would be linked via a 1 to Many to the primarykey of the table holding the main data. That way a record for extra data would only be created when the 'Other' option is selected. The form text field would only appear when...

Hi Fuga, How big is big? Dave E

Dave, I don't know about nested subforms. I wouldn't want to design anything like that. But I would have a main form showing the Job and a subform showing the Batches. Then have pop-up forms, selected by Command Buttons on the Mainform, to show the treatment and Observations. The user would...

JustMaybe I can, But first - How much do you know about using code in Access databases? I tend to do most of my stuff in code because it's quick. Further to my earlier 'waffle' - Have you got access to the Northwinds demo database as supplied by Microsoft. It is packaged on the CD with...

Do I gather from your 'waffle' that you have a table containing orders, some of which may have one or more associated invoices? If this is the case and no 2 invoices may have the same serial no, then have the invoices in a separate table linked by the orderID, but having a separate field called...

If you have used the unbound controls to create a filter for the recordsource on the subform, you could have a dummy filter which applies itself to the subform when the mainform opens. The filter would be valid but no records could exist, so the subform would remain blank until the real filter...

AutoEng, You'll have to change your Login name, cause I wouldn't believe anyone called Autoeng could be a female in desperate need of one-to-one help, Therapy perhaps?:D Dave E