Search results

You could change the 'date' field's properties in the table. Set the field's 'Indexed' property to (Yes-no duplicates). I haven't tried this so I am just guessing.

You should find something in help under 'conditional' coding: If IsNull ([DataCode]) Then With Assistant.NewBalloon .Heading = "Wait !" .Text = "Is it OK to leave Data Code Blank?" .Show End If End Sub -this should execute the code in the If statement only if the text box is null. If it...

To change the colour of a text box you use the conditional formatting in the format menu. You can only have three different conditions maximum. I'm no programmer but you should not have an else before the 'end sub' as it will only end the sub if a condition is met. You do not need the second...

in the On Close property of the form you type: Docmd.RunMacro "YourMacroName"

There are a few ways that I am aware of. The one I use is to create a combo box with two columns, one with the product name and one with the price. you the set the column width of the price column to 0cm so it doesn't show up. To refer to it in a calculation, and store the number...

You've confused me (not hard to do). Maybe some more info on your problem would help. There is some info on the operators such as Like, <>, and Not in the visual basic help if you look in the contents: Language Reference: Indexes/Lists: Operators Keyword Summary.

<> y

I use If (KeyAscii = vbKeyEscape) Then MsgBox "ESC pressed" End If in On KeyPress. Key Preview is set to yes as well. [This message has been edited by naygl (edited 02-11-2002).]

When I press the escape key I want it to do it's noramal thing then set focus on a control. How would I do this?

I have a subform on my main form which is in datasheet view. It is not linked to my main form but whenever I filter the datasheet another subform which is linked mainform (which is data entry), displays the first record of each customer when I select the customer number. The main form is set...

Use OpenForm action and choose Data Mode: read only. Then use ShowToolBar action, choose a tool bar, set Show to 'no'. If you want to get rid of all toolbars that appear on your form you probably have to use the ShowToolBar action for each tool bar [This message has been edited by naygl...

My help has something on the ColumnHidden property. example: Forms!Products!ProductID.ColumnHidden = -1 I'm using Access 2000 by the way. [This message has been edited by naygl (edited 01-22-2002).]

type in "hide column" in Microsoft Access Help's Answer Wizard

Have you tried using a macro? Choose OpenForm as the first action, type in the form name in the action arguments. In the next row choose GoToControl and type in whatever the page is called. You have to put DoCmd.RunMacro "MacroName" in the code builder in the OnClick event. I have no idea...

I think I understand. Do you use a combo boxes at all? The wizard will create a combo box for you which will find information on your form based on what the user choooses from the combobox. You could have a combo box for employee key and Date-worked.

create five different forms based on your tables. Then add subforms (based on your five forms) onto the tab control's pages.

Don't know about you first problem but you can use SetFocus for problem 2. e.g. On Open (form with tab control) Me.PageName.SetFocus (PageName being the name of the page on your tab control) It can be done from the switchboard as well (On Click) [This message has been edited by naygl...

I'm no expert but you could have subforms on your main form which could be based on different tables. The subforms could be invisible until the combo box is updated. When the user chooses from the combo box you make visible whichever subform you need.