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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.