Search results

Using an unbound combo box will enable you to search and open the record at the correct one that you wish to edit. You can then edit any information in that record (Excluding the Primary Key) and this will save to your tables. HTH

You will not be able to type in a Catalogue # as this field is your Primary Key and Access is telling you that you cannot enter this number as it will create duplicate records. What you will need to do is create an unbound combo box control for example (you can use the combo box wizard to do...

In reply to checkbox query only... Adrianna This should work for the checkbox query, not sure on the second query as you are testing different conditions and applying a value to only one option. Hopefully one of the experts will point you in the right direction with that one !! ' Placed in...

In Access 2000 you can select the Detail section and from the property sheet for this choose > Format: Force New Page: After Section HTH

Carolyn Should be: =Sum(IIf([Your Field Name]=Yes,1,0)) Hope this helps Graham

Hi Cosmos You wrote >> Same deal for TaskID, although right now there are no duplicate Task Numbers, in the future there could be so I just created a Primary Key and named it TaskID. ************************** Each task should be a unique task, and your database should never contain...

Cosmos You wrote >> I am not using the Task number OR the Sub-Task number the Primary Keys in the respective tables. In tblTask, I have TaskID - Primary Key TaskNumber TaskName In tblSubTask, I have SubTaskID - Primary Key SubTaskNumber SubTaskName Why are you storing a TaskID (PK)...

This May Help You.... Hi Cosmos On the subform create a command button named cmdNewSubTaskID On the On Click event of this add the following: Private Sub cmdNewSubTaskID_Click() Me![lngSubTaskID] = NewSubTaskID() Me![strSubTaskName].SetFocus End Sub Then create a function...

Hayley Can you not set your combo box value to an empty string on click of the button by including the following within the On Click event: YourComboName = "" HTH

Thanks for the reply Harry. Something to consider....

Colin Thanks for the reply. I may not have explained properly: The reason for using the IN operator was due to the fact that at present she is having to enter something along the line of the following: Like "NG*" Or Like "MM*" Or Like "LL*" Or Like "JJ*" Or Like "DD*" etc. etc. This creates...

Just a quick question: When using the In operator, can the list of values contain the wildcard (*). A colleague is using an OR operator that is creating a very long criteria and I thought of using the In operator. However the values she is entering contain * as she is searching on postcodes...

Colin Use an option group rather than checkboxes to prevent more than one choice. The option group will only allow one value to be selected at any time. Post back if you have further queries with this. HTH

Echo_3 Try with: SELECT [Beach Contracts with Name].[Contract#], [Beach Contracts with Name].[Add-On], [Contract#] & [Add-On] AS ContractGuide FROM [Beach Contracts with Name]; HTH [This message has been edited by Graham T (edited 05-24-2002).]

Sorry, not sure if my above answer works. Below counts check boxes. =Sum(Abs([Spouse Attending])) It's been a long day! 8-)

Mechele The following should work: =Count(IIf([Spouse Attending]=Yes,1,0)) HTH

Select the command button from the list of controls placed on the form and choose Format > Bring To Front. Or select the rectangle and choose Format > Send To Back. HTH

Yaronh You should be able to use a simple If, Then, Else statement in VB to solve this problem. If [YourFieldName] meets some condition Then Me.[YourTextBoxName].Visible = True Else Me.[YourTextBoxName].Visible = False End If Post further information as to what exactly you are trying to do...

Colin Don't know whether this will help ACC: Not Enough Stack Memory When Opening Form http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q96988&LN=EN-US&rnk=4&SD=tech&FR=0&qry=stack%20memory&src=DHCS_MSPSS_tech_SRCH&SPR=ACC& Graham

dcasado You could try the following code, which is attached to the On Current event of your form and the After Update event of your combo box. The example is using a combo box called cboFormat and 2 text boxes (txtCD and txtMiniDisc) with their properties set to Visible (No). The combo box...