Recent content by rickgrimes

Hi to all, I have been working on upgrading an XP db to ACC2007 in which I want to use the RibbonUI. I have all the code and such completed, and it works fine except...... I have 2 LabelControls that I need to change dynamically from time to time. The Callbacks are working correct when the...

Think about on the 'Dirty' event to create a recordset clone of the subform data. Then .AddNew to it with the info you want and where you want it. Then requery the subform. Use the .NewRecord property to make sure a record is only added when the main form is creating a new record. Just a...

Kenneth, Maybe a block if: If Dcount(...)<1 then Myfield=0 End if Rick

Kenntha, Try the DCount function. i.e., Dcount(&quot;[Anyfield]&quot;,&quot;[QueryName_forSubform]&quot;,&quot;AnyCriteria&quot;) The AnyCriteria is optional. It will return the number of &quot;Anyfield&quot; within a table or query. I have used this many times in a textfield. Hope this...

quest4, Ok, My solution to your problem revoles around 2 functions. I assume that the itemnumber field in the subform is a string. With that, I wrote the functions to increase either the left number or right number. Public Function IncreaseRightNumber(Optional itemnumber As String) Dim...

Tony: Thanks so MUCH! After much problems, thank you for SHARING your knowledge. Not much hair left! Maybe I can keep the rest. Rick

Nate: Check and compare the references. Maybe they have an outdated library file, or even corrupt. The fact that it is a connection error, I suspect ado? Just a thought... Good Luck

gazz, The most common way is: 1. On the subform, put a unbound textbox in the footer. Have the textbox.control source: =sum(Total). 2. On the main form, add an unbound textbox, have it's control source: =[SubFormName].[Form]![FooterTextbox] This will update everytime the subform's 'total'...

1318: Try, DoCmd.OpenReport &quot;rptProd_Data&quot;, acViewPreview, , &quot;[Item_Number]=&quot; & Forms!Add/Edit Product!Item_Number Couple of things: If the item_Number is a number type, then you OK. If the item_number is text, then use: DoCmd.OpenReport &quot;rptProd_Data&quot...

Since [Date]is a date field, try: If not isnull(Dlookup(&quot;[Date]&quot;,&quot;[GasFigures]&quot;,&quot;[Date]=#&quot; & Me![Text235].Value & &quot;#&quot;)) Then my .02 Good Luck.

Jessica, If you are using an earlier version of Access, change the Err.Number to Error, and the Err.Description to Error$. The Err object is part of DAO 3.6 Thanks for the star....now if only my boss could see me now! LOL. Thanks.

Hi, I don't think so, but just thinking about your problem, as a possible work around... What about 2 subforms? One above the other, both based on the same data, except, the top one properties are set to 'data entry' only. When the data is entered, the bottom subform get requeried! Just a...

Jessica, Sorry about not getting back to you sooner. OK, the beforeupdate event only runs when the data of the record is changed. Therefore, if a user just views that data, the event will not happen. But, if the user changes any data on the record, the event runs. I think the code would...

You are looking for the BeforeUpdate event for the form. When the user changes any data on the record, this event occurs before the changes are updated to the table. Place your code there.

Of course, Send the file to gher_rick@symet.net I would be happy to look at it for you. Regards, Rick.