Search results

Hi, Does anyone know how to reset a unbound field? Situation: I have a unbound field (default value "0") - when the user enter some invalid I will trap by using: Private Sub Text73_BeforeUpdate(Cancel As Integer) If Me.Text73 > Me.Text69 Then Me.Text73 = 0 Cancel = True Exit Sub...

Why didn't I think of that before?? Hi Jack, DCount solved my problem. The funny this is - Why didn't I think of that before. You're a whiz!!! Thanks.

Not quite Jack, I haven't got it working yet. The problem is that [sfmHireReturn].Form![HireTotBooks] gives me a "run time error 2427 you have entered an expression that has no value". Basically, [sfmHireReturn].Form![HireTotBooks] holds the number of books by totally the quantity in the...

I get "#error" in a field with control source .. =[sfmHireReturn].Form![HireTotBooks]. sfmHireReturn is a subform and the "#error" message is produced if I don't have anything in the subform. I have tried trapping for ISNull ([sfmHireReturn].Form![HireTotBooks]) but it doen't get rid of the...

Thanks Pat, You've solved the problem again. Many thanks.

Anyone! How does the date criteria work for the DSum function?? I can't get it to Sum using the following methods. Thanks in advance. First Method: sSQL1 = "[ReturnDate] = #" & Format(Text31, "dd/mm/yyyy") & "#" nRevenue = DSum("[LateCharge]", "tblHireTransaction", sSQL1) Second Method...

Thanks llkhoutx. I think your solution is very elegant. Thanks a bunch.

Thank you!!

I have a combo box with the following properties: Row Source Type: Value List Row Source: Item A;Item B;Item C Can I program a button on the form so that the user can add "item D" without switching to design mode. Thanks.

You absolutely right David R. I've used the technique before but somehow had forgotten it. Problem solve - thanks for the help.

Hi All, I have a form that allows the user to select various criteria for report. With this I will set the recordsource for the report. My question is: Can I pass some parameters to a report because I have some field's calculation that rely on this?

Is there a limit to the number of Text box or labels you can have in the Report Footer section? I found that I can only display about 60. I am doing a customer profile report i.e that show age group distribution, Marital status and etc. One solution would be to split up the report - not nice.

Thank you for your help!!

Hi All, How can I reprogram the action of the return key in a subform datasheet? When I press the return key it move to the next key. I would like it to move down and set focus on the new record. Thanks in advance.

Hi DBL, In Hong Kong we use the same date format as the UK. I may have the same problem too. Would love to see you post your fix here!! Thanks.

Thanks. That way my query is tied to the report. I want to make the query more flexible.

Hi All, I am using a query form to get the criteria to run my report. I want the report for a certain date. My syntax is : DoCmd.OpenReport "rptIssue", acViewPreview, , "[Date_ Raised] = " & Forms![IssueReportSearch]![Text5] where [Text5] is the unbounded field to hold the date. I find that...

Is it possible to have wordwrap for a cell if it being displayed as a datasheet on the screen?? This would be the same functionality as Excel. Thanks in advance.

I am using a subform for data entry. After I enter book number the due date is calculated (see below)- this works fine. However the due date also depends on the total number of books. As this increases, the due date should be recalculated for the whole subform. This means that a person...

I have a subform that displays a book list. I want to allow the user to key in a book id through a dialog box and the application to highlight it in the book list.