Search results

Hi Michael: Sorry, I am still not being clear enough. The form is bound to a table and the user will be editing certain fields in the table. On the form I have several unbound fields, some to display calculated data and some for user input. I also have a combo box bound to a different table to...

Hi John: Now that is an eye opening thought. Yes I could count the records before applying the filter and then I would know if the filter would work. I'll combine this thought with some code sample from the "Code Repository " to have an sql count the records. If count < 1 then take evasive...

Hi Michael: The unbound control displays yesterdays date. It is a simple =Now()-1 for control source. With the form properties set to allow Edit/Addition/Deletion of records the date display properly and I can use the date in my code to control what the users see. With the forms set to Allow...

Hi: Yes that would work to tell me that the filter has zero records displayed. But then, testing with on err to trap the error that occurs on setfocus also works. I just thought there would be a more elegant way to display the count of records available on a filtered table. Thanks for the...

Hi: I do not understand why on edit only forms the unbound fields do not calculate. So I have changed my forms to allow additions of records and then on BeforeUpdate I test if fields (which the user cannot change) are zero. I can then Undo the addition. Not a very elegant way to handle the...

Hi: Thanks for the reply. My error, I did not express myself correctly. The form is attached to TableA and will list records showing sales for different departments. The ListBox is populated from TableB which list the available departments. The filter applies to the detail records from TableA...

Hi: I have created several forms to allow users to edit existing records from different tables. The user is not allowed to delete existing records nor are they allow to add records. I handle that with the form property Allow Edit/Addition/Deletion set to yes, no, no. On the form I have an...

Hi: I have designed a from which populates a list box for the user to select and item from. After selecting and testing that an item is selected I set a filter to restrict the listed records and then set the focus to the first field which the user can modify. The problem I have is when the...

Hi lagbolt: Thanks for the reply. For the query that I have set up the select statement returns information from the table such as RegId, SaleDate, SaleAmt, etc. The records are restricted with a where clause to a specific date. To the retrieved records I would like to add the field...

Hi: I have a select query to display record from a table. I would like to lookup the closing value for the corresponding record for yesterday. I have coded the following DLookup to get that data and it works if I hard code the date. Now I need to change it to be current date of current...

Hi Paul: You are so right. I do not know where my mind was at but I see the problem now. I just wanted the "Where" part of the SQL statement without the Where word. Works like a charm now.

Hi Paul: I am not following you on the sample nor why the syntax is incorrect. The Query that I am using is not using any variables from the form. The field "process" is part of the table and was set previously in code to either be true (include for report) of false. All the button is now doing...

Hi: I have a form with a command button and some VBA code. After checking that the user has done all that needs to be done then they can click on the command button to print a report. I am having a problem with the report. The error message I get says I have "Written a subquery that can...

Hi: Yes that does give me what I want. Thanks

Hi Bob: The ComboBox is populated by a query for the record source. The LimitToList property is set to yes so the user can only select from the list. The query returns 3 values and the ComboBox displays the second value for the user to select and then I can use the combo box name to get the...

Hi Bob: If I understand you correctly, ItemsSelected, does not apply in my case because the control box is populated by a query. As such, I must use the value of the control box to run a query to retrieve the record the user selected and then I can extract data from that query. If my...

Hi: I have a Combo Box on a form populated with a query from which the user selects a value. In my code I would like to get the item selected. It is my understanding that ItemsSelected and ItemData would work for this purpose but when coded I get a "compile error Method or Data Member not...

Hi Dave & Bob: Since I deleted the form in question I cannot debug it further. Also my backup copy did not have the error and after I put my changes back in the error never returned. After reading several responses on the net I came to the conclusion that this error seems to be a general...

Hi: I decided to delete the form (since it was only this form causing the problem) and recreated it. So far error message is gone. Thanks for looking

Hi: Just to add more information. The problem seems to be with just one form and seems to be related to a permanent error code. The command button in question has an On Err statement in it. If I comment out the error then the code executes until the first DoCmd Dmax statement. If I comment...