Recent content by Ernie Taylor

Try using a subform. This gives you a scroll bar and allows you to have as many records as you need.

I got round this by creating a form called startup (which just includes the name of the database), making this run on startup using tools/startup/display form "startup" , including a timer event in the startup form ontimer = startup (macro below)Timer Interval 500. Create the startup macro three...

Sorry having reread your question I missed the point.1) Rather then test for null make new entries set a value using the default property such as * in each field. Then test for this known value(null could be space could be empty string etc they all look the same).It does not guarantee correct...

This problem is difficult to overcome as access writes directly to the table before validation occurs. If your shortcut method does not work try creating an intermediate table which is used to collect the entries. Then put a button on your form to accept the record (eliminate all navigation...

Your problem is still not clear to me. I suggest two possible routes 1.If you want to display a simple list of names based on a status control in a form why not make your command button open a form created to view the results of the query suggested in my initial answer or 2. Use a subform within...

One way is to build a criteria in your query so that it picks up the selection criteria from your form. This is easier if you leave your form open (use minimise). Right click in the criteria section of your query where you want to select. Build. Select Forms, Loaded forms, double click on your...

Why not make the button invisible if your answer is true. Doing it this way seems easier. The code below checks if a record has been updated (flag control set to true) and then prevents further updates by making the update button (called readonly) invisible. If flag Then Me.Form.AllowEdits =...

It's a workaround.By using the code or a variant you can filter the form using text boxes and vb Me.filter =.... In other words don't try to use the standard filter by form work on a filter which is selectable by the user under your control. Alternatively create a list of text boxes and a...

Matt I don't think that will work. You need to use visual basic to update a field on another table not related to the form otherwise you get a #Name# result. The only other way I can think of is by including the second table as a subform (note must be linked by common field with the main table...

It is much easier to use a combo box on your form providing a drop down box of your films rather than using a + sign to jump to an order table. My suggestion is set up a number of forms: firstly a simple order form containing a combo box of all films.Secondly a form for films which has a combo...

Although what you need is not totally clear. You could consider on your main form using a combobox for the orders and a subform linked to the parts list rather than using a separate form. My understanding is that you wish to look up an order and if it exists get a list of parts else create new...

I would suggest that you keep it simple. Jump to a new form on the third selection (by including an open form button)and run a query based on that using a subform.

An even simpler method is create a macro with only requery selected and call this using the properties event for the control. It is not as selective but it will work in most instances and it has the benefit that it can be used for other forms with no change.

This is one I have used on a report to identify user's filter by selection choices. On the form I created a text box called totfilter and one called subfilter (this is populated by =[Filter]. The totfilter is unbound and populated by this code within the subform: Me![totfilter] = Me![subfilter]...