Search results

This is usually an indication that there is a Missing or Broken Library Reference in the application ... I would check the references to confirm this ... R.

You can easily control this at Form level .. but not at Table level. R.

The relationships will are in the BE file with the tables ... They do not show in the FE file ... but this does not mean that there is a problem. R.

No problem .. you are welcome .. ;) R.

I suggest the you use a combobox to select the student ... This would stop any possible typos by the user. You simply need to use a query as the Row Source for the combobox that includes the desired fields to be displayed for the user to see in the dropdown ... I advise you to store the...

That makes no sense to me ... The query would only alter the sorting .. as it seems that you are asking here. Also .. the form could just as easily be bound to a query as it would be to a table ... In most cases .. it's preferred that a query be used for the Recordsource ... R.

I assume that the list box uses a query for the row source .. If you are using a table for the row source .. then create a query for this instead ... Then you can sort the query any way you wish. R.

Have you seen the info at the link below ??? http://ezinearticles.com/?How-to-Resolve-Error-3197-in-MS-Access-Due-to-Database-Engine-Corruption&id=5827456 R.

Your table structure is not properly normalized ... You have repeating groups in your table the the literal day fields ... Each daily entry should be a seperate record in table ... RDH

Make sure that you have installed all service pack updates for Access 97 and also the latest Jet 3 update on the machine give the problem ... RDH

To add to what Pat has posted ... If you have multiple addresses .. such as Home Address, Business Address, Shipping Address .. ect ... you should have an additional child table for these entries with a field to indentify the address type .. RDH

Let me add my Congratulation Pat ... I did not see this thread and made a post in the WaterCooler Forum. You are very deserving of this award and will be an asset the the existing MVP group. RDH

Hmmm ... I would simply disable the txtbox for the "reason" until the "time on" has a valid entry ... RDH

I really wish I could have made that MS meeting and met you and the other Access Insiders ... I had a sponsor that would have paid for most of it ... I have been, and still am, up to my neck in alligators with a large corporate project ... .... I need a break .. ;) RDH

How is that you know so much about this Pat ??? LOL .. <just joking> RDH

If the default value for the field is set to 0 .. the value can be 12:00 AM if no entry is made during record entry ... The default value "should not" be set to a 0 value for this reason ... There should be no default value ... then the value stored will either be a valid date/time value or a...

You need a Mainform/Subform configuration for the One to Many setup ... The many side table needs to be a subform. RDH

I would think this task would be better handled using a form .. As you can not execute the needed code from within the report ... RDH

If you mean the SQL string for the query ... it's around 64,000 characters. RDH

I assume this value to display would contain a fraction value such as 3.75 ... You could use the following in the Format property of the control where the value is to be displayed ... Try this: 0.0#####;;"" Then make sure you set the Decimal Places property to the actual number of decimal...