Search results for query: *

Dear Judgehopkins, Thanks indeed for that helpful response. I shall go away and follow your advice. Best Wishes Graham

I would like to compare different versions of the same database, to see the outstanding differences. Thus I would like to see whether the lists of tables, forms, queries etc are different. Similarly I would like to be able to compare the code under buttons. To see what differences were present...

Hi I have just created a form and added a bunch of diffent controls to it and then named each control V1 V2 V3 ETC so that every control was simply named. I then added the following VB code to one button Private Sub Val7_Click() Dim ctl As Control For Each ctl In Controls MsgBox "The...

The problem arose from a design error that Access 2002 didn't catch. This is how it came about. I needed to create Parent and Child relationships on a Table listing companies. I therefore created a link table with the appropriate Child an Parent columns. This worked perfectly. I then set it up...

I have set up a form to retrieve a subset of records from a query based on data entered. I would like to be able to identify if no records were retrieved as this will affect the next actions. As this is only one aspect of multiple form interactions I would prefer to do this from within the form...

Well I have learned a huge amount thanks everyone for the stimulating conversation. Graham

Hi Wabeg Thanks for your help. I will be trying it. The information about this area is really poor. I think there is another person having the same problem in this forum. Graham

Dan JR Thanks indeed it worked well. I just cantt see that method listed in any book nor any explanation about the purpose of the DoCmd.Runcommand method. Graham

Hi MoJop and DanJR, It was really great of you to help in this way. I will go away and try this directly. Graham

How do you save the data in a form without closing the form? I find that DoCmd.Save still leaves the data in the buffer. I have also tried DoCmd.Save AcForm, "frmTheFormIWanttoSave" which transiently worked and then stopped. My underlying problem is that I wish to add data to a new...

I have found it to be good much better than Access 97. I have not yet deployed it but intend to do so. I am not however an expert. I would not use an earlier version. The ability to split it and distribute it over a network, and to change it to an SQL server format is also appealing. I have been...