Recent content by Turbojohn

Hi, I have a form which is based on a table. I was wondering if it is possible that when the form is opened a blank record could be displayed rather than the first entry in the table. In other words, it would be like opening a form and clicking the "Add Record" button, a blank record would be...

Thanks for your reply, I tried the first approach with one of my forms and it appears to work perfectly! Thank you! :D I'll make sure it works fine for everything else and repost if i'm having any more difficulties. Thanks again, much appreciated Turbojohn

Yes, that is correct Turbojohn

Thanks for your reply, The limit to list property is set to 'No' and users are allowed to type in a new value or select from the list. This works, but only if the user exits the form and then opens it again. This approach does not allow the list to be updated dynamically. I need a way of...

Thanks for your reply, I am refreshing the form so that when a new entry is made by the user in a combo box, this value will be updated and stored by the combo box so that next time round, when a new record is entered, this new value will be available to be selected. I gave Lost_Focus a go but...

The error is: Run-time error '2001': You cancelled the previous operation I use the Got_Focus event on the Narrative field to update the combo box if a new entry is made: Private Sub Narrative_GotFocus() Me.Refresh End Sub

Hi, I have a form with various fields, some of which are normal data entry fields, others dynamically updating combo boxes. My first field is a date field which defaults to today's date, the field following this is a growing combo box which requires some narrative to be entered. I have set up...

Cheers Len, Used the Me.Refresh on the combo box and it now updates properly. Thanks for the help Turbojohn

Hi, I am using a combo box in my form. It is a growing combo box allowing new entries to be entered to create a growing list. When new entries are made to the combo box list they are only displayed when I quit the form and then return to it. Is there any way I could allow the combo box list to...

Hi, I am using a form with 3 combo boxes name, weight and grade. The combo boxes are cascading: A name is selected in the first combo box, since each name has different weights attached to it only the weights associated with that name are selected when the weight combo box is clicked. In a...

Legend! Cheers Rich, I used the On Close event and it worked fine! Thanks Again Turbojohn

Hi, I am wondering whether it is possible to trigger the run of a macro when a form window is closed using the close button in the top right of a standard window? If not, then is it possible to display a form in a window without the minimize, restore and close buttons? I am currently using a...

Hi, I want to insert breaks (either whitespace or a filled line) between certain data in my reports. Is this possible? Any solution needs to be flexible enough to allow me to control where the breaks are to be inserted. Does anyone know how to do this as I can't seem to find anything on this...

Hi, I am currently implementing a stock control database in access. I have various forms for entering stock in and taking it out etc. It all works fine except I need a way of sorting my data to produce very specific reports. The company wants reports to be listed in a very specific order. I...

Thanks for the link! It worked well for the stock weight but I am having slight difficulty with the stock grade. It gives me the values I want, but duplicates these twice. This is understandable since I have 2 entries. I have tried using DISTINCT, however, an error message is given of a...