Search results

After some suggestions, I have a form with combo boxes, the combo boxes are set to enabled "no", but become enabled by an after update command on another field. The after update command works perfectly, however once enabled I need to ensure data is selected, as opposed to leaving blank. Any...

Is this what you are after? I did the first two...you might want to fix up your spelling, it is supposed to be details not detials isnt it? I adjusted Falts to faults... Anyway if this is what you are after, add the code rv stated except the code is actually 1 to enable the text box If...

Did you change the enable property for the case details to No? Can you zip your db and attach?

I would set the enabled property of the textbox to "no" and place an after update code on the yes tick box: Private Sub 'NAMEOFTICKBOX'_AfterUpdate() If 'NAMEOFTICKBOX' = -1 Then 'Nameoftextbox'.Enabled = True 'Nameoftextbox'.SetFocus Else 'Nameoftextbox'.Enabled = False End If End Sub

Use text boxes I assume you have a total incidents field somewhere in the report...if so On the actual report add text boxes, in the control source type: =[Name of the field containing number of incidents per ward]/[name of the field containing total incidents]

Found it myself incase anyone needs to know Private Sub Command??_Click() OpenExcelFile ("FileLocation.xls") Dim objXL As Object On Error Resume Next Set objXL = GetObject(, "Excel.Application") Set objXL = GetObject(strPathToFile) objXL.Application.Visible = True...

I know how to create a command button to open excel, but is there a way to create a command button to open a specific excel file?

I am using a networked database built by somebody else. I have added a networked DYMO labeller which runs via a simple report in Access 2003. The probelm I am having is that the default label type I specified in the report (30321) keeps changing, it will change intermitantly and to any...

I am using a networked database built by somebody else. I have added a networked DYMO labeller which runs via a simple report in Access 2003. The probelm I am having is that the default label type I specified in the report (30321) keeps changing, it will change intermitantly and to any...

How do I build the warning box? Ta...reading the dcount stuff now... How do I build the warning box into it so it will appear if there is a multiple record in response to the dcount()???:confused:

I have a database called "Main" containing customer details and interactions. One of the fields is the "Customer Number", whilst I know I can index the field to stop duplicates, is there a way to check for duplicates when entering the customer numbers into the form and display a warning message...