Search results for query: *

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.

Place your code in the 'current event'. That is the event that fires for 'each record' of the master form.

If the Emply_ID is Long data type then, Try this syntax under the command button for the report: Docmd.OpenReport &quot;Report_Name&quot;, acViewPreview, , &quot;[Data - Basic.Emply_ID]=&quot; & Me![Data - Basic.Emply_ID] If the Emply_ID is string data type then, Docmd.OpenReport...

Try, Me![TableName.EmplyID] I have run into this before, were there were multiple field names in the underlying query. Using the syntax of the tablename.fieldname has worked for me several times. Use the syntax in the docmd.openform statement. Just a thought, is the field Emply_ID a string...

annsolomon is correct on the report button, use that and it will operate the way you want. On the query form, there are a number of ways to accomplish your search. I think the first thing is to have an idea of what kind of form you want to see. Some opt of the 1 form with 4 combo boxes. The...

Hi! I HIGHLY recommend Ken's statement concerning the Names, I have cried those tears myself!!! Excellent! Rick.