Recent content by Rothron

Success! It works perfectly. Thanks very much for your helpful advice. Rothron

Thanks very much - I will give it a go when I come back in tomorrow. Thanks for your help. Rothron

I have a database which has a main form and a subform. When a record has been chosen on the main form the user then opens the subform which all records pertaining to the main form record. What I would like to be able to do is a field to be automatically entered when the user adds a record to...

Thanks for replying. I have managed to apply an index to the relevant field which means I now have the one-to-many relationship needed to make the form run. Fingers crossed it keeps going! Many thanks for taking the time to answer.

I have a database in which I am trying to set up a form and a subform (the forms are already created). I am trying to create a one-to-many link between the tables but all I get is a one-to-one. I have read the "help " but I am still stuck at square one. Can anyone help me? Thanks for any input.

Thanks very much. That seems to work fine. Rothron

I have a database which has a main form and a subform. Each record on the main form can have several subform records attached to it. Is it possible to have a command button which will allow copying and pasting of the subform record, as all the information could be the same bar one field? I...

I am designing a new database which will have a form and a subform (I am already having enough trouble trying to cope with subforms!). There is a field on the main form called "Date of last data change". Is there any way that the date something is changed on the subform can automatically be...

Thanks for the advice. I am going to give the filter a go tomorrow (bad idea at the end of a horrible day!) and hopefully all will be well. Point taken about the message, though! Thanks

I have just discovered parameter queries and it appears they are just what I need. However, when opening the relevant report the dialog box asks for the paramater TWICE and then produces a report with no records in it. I suspect it may be a problem with the way the query is set up. Any help...

Thanks for your suggestions. If the DBF opens in Exclusive mode does this mean that only one person can be in the database at a time? Or have I misunderstood? Thanks for your help.

I have a memo field which seems to work well apart from the following problem. Occasionally, for no readily apparent reason, it allows you to enter text in the memo box and then gives the report of #Error thereby wiping out all your entries. Once it has done this you cannot delete the error...

Can you have more than one input mask for a field? I have a field which either requires a number in the format ####-##-###-#### or a date in the form (##/##/##) (including the brackets. Is there any way this can be done? Any suggestions gratefully received.

I keep getting the Microsoft Jet Database Engine stopping use of the database with Error 3197 - saying that "you and another user are attempting to change the same data at the same time". I have no record locks on and as there are only 6 of us in the office (not all of whom use the d/base) we...

Not only is one record having problems with its memo field, it is now spreading to others. I have had no other problems previously with this field. Does anyone know of anything the user might be doing that could cause the field to put up the message #Error# when trying to enter data in the...