Search results

Hi again, just thought I'd tell anyone interested that I've got a solution to this problem. I tries Nz() in the text Box and in the query with no change. actually there was one change, when used in the query the error became #Size! (the result should have been 3 characters long and the box...

Hi there. I have four separate queries each producing a value named "Sum of Price" for a particular category of product. they are embedded into a subform of a booking form for with Master & child fields set accordingly. on the booking form I have a text box I want to show the total of all the...

I have been working with a database where to identify the category the organisation's members fall into they have been adding various characters to the end, some standard, some varying and completely indecipherable and for all intents useless, anyway I want to be able to use the info of what...

Beautiful. It is numeric so I used your Long integer based format. Thanks very much, I had tried something similar to that but without the ampersand. I guess I am writing an SQL argument and should imagine it being printed into a query as message text would be printed into a msgBox. Out of...

Hi there , I have a form opening in datasheet view. When I double click on the ID field of a particular record I want it to open a form in form view on that record so this is what I came up with: Private Sub BookingNo_DblClick(Cancel As Integer) Dim strBookingNo As String strBookingNo =...

Brilliant, that'll save on a a few extra button taps here and there. Thanks again!

I have another subform problem, Simply trying to move to a new record using a button control... but macro won't work and the syntax for doing this with a non-sub-form doesn't either. Hope you can help

Out of interest would that actually SAVE the record, would have thought it would just trick the error away. do you not need a "DoCMD.SaveRecord..." line to actually save? I don't know either way but I'm always keen to save on an extra line of code. Thanks.

Thanks very much, for the advice. got that pegged now.

Thanks for taking the time to get back to me. In answer to your question: a) I originally set it up with a different structure and b)I want to be able to view all events independently of the main form and as I intend to have multiple BookEvents tabs on this form in case of one booking having 3-4...

Hi there, I am building a database which has UI with a main booking form and the sub forms for the fine details, I have the sub forms on tabs and have a check box make the tabs visible when it is checked. I have set the sub form to take the parent form's Ref no through a lookup but when I tab...