Recent content by P Zero

Following on from this topic; When I open the form 'frmClients', the first record is displayed, however the combo box 'comboClientName' is empty. How can I get the combo box to display the Client Name in this situation?

Thats got it. Thanks very much, it works great :)

Thanks, my combo box has the two columns, ClientID and ClientName. My code is as follows; Private Sub comboClientName_AfterUpdate() On Error GoTo Err_comboClientName_AfterUpdate DoCmd.FindRecord comboClientName.Value Exit_comboClientName_AfterUpdate: Exit Sub...

I'm putting together a database to store my client and billing details and for generating invoices. I have a form for viewing clients called 'frmClients' and on the form I have a combo box called 'comboClientName'. This is how it should work; The form is opened and it displays the first...

Thanks both of you for all your help. It works great once I specify the column that the data in the listbox is coming from, ie; Me.ItemList.Column(1) Although I realise that 'ID' is generally used for numerical fields, in this case the user's data is actually called Building ID, and although...

Thanks, there is now no syntax error, but nothing happens when I press my delete button. I'm really confused as this works perfectly when only one field is listed in the list box. When I have 2 fields showing, it just wont work.

It says there is a syntax error with the code below; strSQL = "DELETE * FROM [tblBuilding] WHERE " & _ "[fldBuildingId] = '" & Me.ItemList & "'";"

Thanks Kiwiman, although still no luck I'm afraid. strSQL = "DELETE * FROM [tblBuilding] WHERE " & _ "[fldBuildingId] = '" & Me.ItemList & "'";"

Hi namliam, thanks for your help, that certainly helps me understand whats going on a bit better, but... :) fldBuildingID is a user defined field and as such is a text string, so I think the syntax is correct. Any other ideas?

I have an unbound list box with two columns. It lists the records in a table called tblBuilding. I use this list box in a form to add or delete records from the table. The problem I am having is with deleteing records. I can get it to work fine if I only have one column in my list box, but with...

Hi. Its been a while since I've been on here, but I'm back! I have a button on a form and I need it to do the following - Check if AutoCAD is running If AutoCAD is running, maximise it and move the focus to it If AutoCAD is not running, start it and move the focus to it I'm thinking this...

I cant get it to work. Could there be something else in my code for that form preventing it from working? I'm off home just now anyway. Its just pi**ing me off. Thanks for all your help though.

Thanks. My code now looks like this; Private Sub M_VentType_AfterUpdate() If Me.M_VentType = "Natural" Me.M_VentSupply = 0 Me.M_VentSupply.Enabled = False Else Me.M_VentSupply.Enabled = True End Sub but it is highlighting the 'If' line and saying it expects a Then or GoTo.

Then the check boxes are enabled, but will be fine set to false. The user can then tick them again if needed.

I dont need to remember their values to reinstate later on. I just need to disable them and change their values to false when a certain value is selected from the combo box.