Search results

Thank you both. I am hesitate to do away with the listbox - but will come up with another method of making the information clearly visible. Will probably just run with a checkbox on the form to filter the information or something along those lines. Unfortunately, most of the users here are on...

Hi all, Hopefully a simple question. I have a listbox on my form which is based on a query. For each row in the listbox that meets specified criteria, I would like to format the row (make font italic and forecolor red). Dim i As Integer Dim intCount As Integer i = 0 intCount =...

Double check the regional settings date format for your PC in Control Panel. Make sure they are set to your local settings and not U.S format. Regards, Rob

Delete all records from your DB, then perform a compact & repair from the database tools menu. Regards, Rob

Hi all, Both of the above examples will work well. I am now using a command button, which works well. What I originally tried playing around with was a mousedown event on a label - the form remains open as long as the user holds the mouse button down, then closes on the mouseup event. When...

Hi all, On my main form I have a continuous bound subform. The subform contains a small 'View' label next to each record. The intention, is that when the user clicks on the 'View' label, another form is opened that previews some details for the current record. Currently, for this to work...

Hi PBaldy, Thanks for the help. :) Rob

Hi all, I'm not sure if this can be done with the expression builder. I have a query that brings in a value from an open form when run. The query can be called from two seperate forms. In my expression, I would like to check which form is open, and port the corresponding value. In VBA - If...

I hav'nt tested this..but it should work. Dim MyDate As Date MyDate = Me.MyTextbox1.Value MyDate = MyDate + 2 Me.MyTextbox2.Value = MyDate Or something along those lines... :)

Hi, I'm in Western Australia. Our postal codes nationwide are 4 digit numbers...so very easy to work with :) Cheers.

I think your referring to a gradient fill. As far as I know, this can't be done using Access' standard features. Create an image in your paint program - set this as the form background and voila! I do try to avoid using images in access though where possible - as have found it impacts largely...

Well I have had some early success. I have two basic select queries picking SUBURB and POSTCODE from tblPostalValidation (one for each control) Each query has a LIKE expression referring back to the control on the form - Like "*" & Forms!MyControl & "*" I have made a small form, no control...

Hi Fathi, I am assuming you are talking about splitting the form background into two sections, each of different colour? The easy way to achieve this would be with two textboxes - each sitting behind the controls of the form. You can set the textbox background colour's accordingly. eg...

Hi John, Thanks for the suggestion - the cascading combobox would make a lot of sense and may be the sensible way forward if I cannot achieve the desired effect. I have the same function working on both the suburb and postcode - and to make things more difficult I have just realised that each...

Hi all, Just a little advice on how to approach a problem. I have some simple address validation in an unbound form. When the user types in a suburb, I have a DLOOKUP function that returns the appropriate postcode for that suburb. My problem is that most suburbs have more than one postcode...

Success! From what I can see, this works without any bugs or problems with one exception - I still have the 'Mousedown' and 'Doubleclick' event on the listbox. The result for the user is that when they double click to open the record, there is a brief flash as the popup form is opened and...

Ok all...a potential solution... The mousedown and mouseup event have a variable 'Y' which specifies the vertical coordinate of the mouse cursor in twips. I need to do some more work on this, but using the code below I am simulating the 'mouse click' event during mousedown - This succesfully...

Hi all, Hopefully a very quick and easy one. I have a memo field that is updated from time to time and acts a running sheet for customer enquiries. I am using the following code to update using SQL - I was under the impression that the semicolon ";" forced a new line in the record - but this...

Hi all, Thank you both for the response and advice. UncleJoe - I agree with everything you have pointed out. I was questioning it simply because you had said the code did not make sense - when really it was the choice of events/timing that did not make sense. I am still on a very steep...

Hi UncleJoe, Not sure which part does not make sense? On mousedown, the form is opened. When the user releases the mouse button, the form is closed. The form is to preview the decscription of a customer enquiry. So the user does not need to 'do anything' with the form that opens other than...