I believe the easiest way to approach this is to build a query using the two tables with the link between the primary key in table 1 and the foreign key in table 2. Use this query and the report wizard to generate the report. The report wizard will give you the option to creat a summary line...
My experience with this problem came from saving Access2000 files in a Access97 format and then attempting to use it in an Access97 environment. I believe the solution was to add Microsoft DAO 3.6 Object Library rather than the ActiveX Data Objects Library. (This change can be made by clicking...
Thanks for the feedback. I found Like is the better tool. In the criteria row Like "[T-Z]*" returns all values <b>including</b> those that begin with "T" and "Z" and all others in between.
I have been attempting to set up a query to search an alpha-numeric column. All values start with alpha values. I want to retrieve a range of values. For example, in the criteria row I entered Between "T*" And "z*".<br>The values returned do not include...
If you want to use code.......<br>
Create a recordset for the table you want to update (ex rstUpdateRecords)<br>
rstUpdateRecords.AddNew<br>
rstUpdateRecords("UserName") = me!Username!.value<br>
remaining fields and values<br>
rstUpdateRecords.Update<br>
<br>
Both AddNew and Update are...
Build a query to populate your subform.<br>
One of the fields in the subform should contain the value of the profession.<br>
In the criteria line of that field you make reference to the control on the main form containing the profession ID<br>...
Put a cancel button on the subform?<br>
Or<br>
Instead of me.undo use [Forms]![subformname].undo. I have not checked this out but Me provides a way to refer to the specific instance of the class where the code is executing. Me in this case is refering to the main form so try using the actual...
I had a different solution and was about to post when I saw Elizabeth's solution. <br>
I added AllowAdditions = false<br>
I checked out her idea and it works great. Thanks Elizabeth (even though it wasn't my problem)
Oops........I had some time and I tried to implement my strategy on a working form and have had no luck.<br>
Sorry about that<br>
The variable is defined in the example code. I missed it. <br>
When I placed that line of code in the OnCurrent event I generated a loop, stopped, and I was still...
I am not sure exactly what you mean....but if you are interested in displaying the data to a user on a bound form and prevent them from editing that record where the field "Completed" is true (assuming a logical field) you could use the Form_Current event to change the form property...
If the form is bound to the table the data is saved when you close the form, as it is when you navigate to a new record.<br>
In your code for the cancel button before the close command write the following:<br>
Me.Undo<br>
This will revert the fields to their...
I don't know if this will be of assistance but the 'Help' key in the Expression Builder dialog box is context sensitive and will display any help files availabe for items selected (ie functions, events etc)
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.