Recent content by Bru

On After Update property, use Code Builder to set up an Event Procedure. Declare a public varible at the top of the procedure. Then set the varible to the field "CompanyID" (or whatever) When you click the tab, use a macro to set the value of the control to the varible that you set initially...

Are you using insert chart for the control? I had this problem as the chart used all the info in the tables instead of the relevant records for the report. This is the sql text from the statement in select row property in the properties Data section. The tables held test information as a...

Assuming that this subform has linked fields that are StudentID, the linked field will be the same as the main form as a default. It does this because it is waiting for data entry in the subform. If you try to enter a record on the subform when the main form is open, the records will be...

Ellie This is a set of queries I used for finding overdue equipment for calibration. The underlying tables held the equipment info, and the calibration table held the various calibration data for the equipment as it was checked. Query Maxdate is was where the greatest or latest date from the...

The difficulty in supplying info to tables via more than one query is that the records will appear several times, once for every related record in the other query/table. If you want to incorportate several queries as look up references then do it in the underlying table or as unbound controls...

You will find rapid sucess with the addition of a subform for the child table records. The problem with using a single query to enter data into a one to many relationship is the parent record will have to be repeated for every entry in the child table. The add subform command button will fire...

I just made a form that does what you have specified in your question. The time entries have not been added but they are just a matter of adding a subform. I use a similar form for our employees to do time sheets, and another to do expenses. I would be happy to send you something if you...

A simple way I did this was to use two query objects or sources (one table, one query). The sql statement in the query where the record is specific will contain and expression. You can open a dialog box for the user to input the criteria (maybe use a drop down list or whatever) and reference...

Maybe a more detailed explanation of methodology for us. We have a system where we split up the main forms down to questionnaires that leap thru smaller forms and dialog boxes. The smaller forms and sub forms were easier to manage and maintain. It requires extra navigation code but was more...

This is a similar question answered in the Forms forum. I will just paste the answer as I think it is the same problem. You have to be careful replacing text boxes with combo boxes. When you view properties of the form, (View, then Properties) and click the upper left corner of the form (in...

Just an add, too, but I fixed it by splitting off front end and making an MDE file, but save the old one as only over writes will make changes to the objects. Bru.

Try PrivateSub [Field1]AfterUpdate() Me.[Field2]=Me.[Field1] EndSub Bru. [This message has been edited by Bru (edited 11-21-1999).]

The best way to predict the outcome of a sub form is to create it ahead of time as though it were a stand alone. When you do this, you can set the Navigation buttons and Views allowed to what you want before you nest them. Another, and more elegant way to nest forms is not to nest them in...

Sorry, just one more thing, Make sure the display type property of the image control is Content and not Icon, and the update option is set to automatic. The Ole type allowed should be Either or Linked. Bru

I haven't found that problem. I just tried this in 97. I created a simple table, ID, description and OLE object fields. In the table, I right clicked the OLE entry, inserted OLE object from file, and selected a jpeg image. The entry in the table came up as Microsoft Photo Editor 3.0. It may...