Search results

Make a custom menu for your database If you made a custom menu, you could set this as the menu bar in the Tools, Startup... box. For how to create a custom menu, see http://www.jamiessoftware.tk/articles/menubars.html. It's seems quite good and has pictures too.

Clear the selection before requerying? I haven't tried this but it might work. On the event that will requery the list box, run code to clear all selection before the requery. I can't remember the code exactly but it goes something like this: 'Remove selection before resetting rowSource...

Maybe someone else will explain this properly I've run across this problem too. I don't know why, but a form's BeforeUpdate event doesn't seem to let you do anything that changes the value of any of the controls on the form. Maybe this is because in order to run, BeforeUpdate needs to...

Something like this: [Forms]![frm_Training]![Name_of_SF_Control].[Form]![ID] This should work if you replace Name_of_SF_Control with the name of control on your training form that your subForm is showing up in. By default this will be something like Child8.

A Couple of Workarounds? To force uniqueness you could try setting an Index on your hyperlink field. In table design view, display the Indexes popup (menu choice: View, Indexes), on the first blank line on the Index grid, type a name for your index (h_Link, say), then in the next cell along...

This might work: 'Pass the SQL to the subform Me.subfrmCompanyResult.Form.RecordSource = strSQL & " " & strWhere & " " & strOrder You used interesting code which makes it look as if a requery action can be set to something, though I don't know how that might be useful.

Maybe this might work Suppose frmProject is based on a query that pulls in some additional details from the customer table such as address, telephone number, email… All you have to do to get this extra customer info onto frmProject is to change the customerID. This is done via a combo...

Bit of a tricky one It can be quite tricky to do what you’re wanting do. When you use the Access filter tools to set up a filter, Access applies it only to the form you're working on. If the form is a subform, Access won't knock the filter up to the parent form too, and so far as I know...

Cycle? I'm not sure about this, but, in Design view, you could try calling up the Form's property box, clicking on the "Other" tab, and setting the "Cycle" option to "Current Record". When the "Cycle" option is "Current Record", tabbing from the last field on the form moves to the first field...

Tricky one I think the problem you've run up against can be solved, though it's quite tricky. In outline, you'll need to set up a custom right-click pop-up menu for your subforms (View, Toolbars, Customize, Shortcut Menus...) The custom menu will be the same as the standard pop-up menu...

What you've done should work I think Sounds like what you've set up should work. Maybe the problem lies with [FieldValue] rather than with onCurrent, which runs, as far as I know, directly after the form first arrives at what is now going to be the current record. If, for some reason...

Requery on AfterUpdate? You could try putting Me.Requery in the AfterUpdate event of the field you're using to sort your form. In design view, right click on the field and choose Properties from the pop-up menu. The Properties box should appear. Click on the Events tab and look for After...

I ran up against a problem not too far removed from ArvInd’s not so long ago. The idea of using Eval is neat, but Eval seems to have a couple of limitations. It looks as if Eval will evaluate user-defined functions only if these are defined in an ordinary module rather than in a form’s class...

You could try something like this: The code below works in Access 2000. 'Access 2000 'Code needs reference to DAO 3.6 selected and 'references to ADO 2.x deselected. Public Function make_rel() Dim rel_New As Relation Dim rel_name As String, i As Integer 'Not very sound attempt...

Expandable sub-datasheets in subforms You've probably sussed this already, but in case you haven't here's how: You've got a main form with several subforms on it. You want one of these (subform_1) to show a sub-datasheet when the [+] at the left end of a record is clicked. What to do is...

Here's a slightly fudgy way of getting the arrows Using the [Aa] tool, create a label on your form (call it lbl_Arrows, say) and use the Windows character map to paste Arial’s Up and Down arrows into this label. The label now contains the two characters you want for your command button...

Freeze Columns? If you were to show your form as a datasheet (though this might not give you some of the extra things you need) then you could select the columns you want to pin, and use Format, Freeze Columns to make them stick. Save the form, and the freeze will be saved too. If showing the...

Lock up mdemarte, Corruption started about 2 years ago after the install of a management accounting system. The system backend ran on its own server, but the front end install required a heap of Windows patches. The patches may have had nothing to do with it, but we had a corruption storm...

Waiting for a return value If you open a form as a dialog DoCmd.OpenForm "pop_Name", , , , , acDialog, str_Args code execution will wait until the dialog is closed. Getting hold of the return value? There are probably a few ways of doing this, and the way I tend to do it is probably...

another monster I maintain and am partly responsible for the design of a mission critical front-end/back-end monster with a puzzling quirk. The backend (data only) is ~570MG, but compacts down to ~50MG. The front-end .mde (linked tables, forms etc) is about 3MG. 80 people will be using the...