Search results

Many thanks for that - I have checked for updates but none there.

Hi, I have recently upgraded to Microsoft Access 2007. I am having the following problem with Combo Boxes. Previous version of Access (2000) I had the Combo Boxes on Got Focus to drop down and then I was able to scroll up or down as required - however since my upgrade - the ComboBoxes still...

Thanks for your reply, It is for speed, also it will assist me with other bits of the project and I would like it. Can this be done in Access? If so I really would appreciate a clue or 2. Thanks BB

Hi, I have a Combo Box with the following choices Sales Resale Overheads For speed (when the combo box has the focus) I want to press 1 on the number pad and sales appear in the combo box - I have no idea how to acheive this:confused: - I can do it if I put the 1 in front of the Sales in the...

Once again - Thank you:)

Hi, I have just reloaded VB6 98 as I want to start to learn VB. However it does not recognise Access 2000 and Access 2000 is not in the database list. Where would I get the necessary updates to bring it up to date.:confused: Thanks

That works fine.:) Thank you very much for your help. BB

I have a Client database with the usual info etc with a checkbox set to true if they are an active client. I print a client list from time to time but only want a list of active clients. How do I code this - I know how to 'not show a single field' but as there are 10 fields per client on the...

Hi BL, Have tried the above - however it works fine on a main form - but this form is a sub form & on loading etc there is code to update etc. The fields change color once the focus is on the form and will not revert back on new record. Many thanks. CW

Many thanks - Will give it a go

Hi, I have a form with 6 field boxes - What I want to do is - on change of any of the fields value will change the background colour of all the fields in that record. When I go to the next record all the fields will be their original colour until I change the value in any of the fields again...

Many thanks

I have checked Microsoft DAO 3.6 I can now open the recordset with no error but it still will not autofill the fields with previous data

Thank you - it would seem that I only have Microsoft DAO 3.5

Not to certain what you mean by your last question about library but I think the answer is no - can you explain a bit further please

I have tried the following but get this error message User defined type not defined And the DAO.Recordset is highlighted in the following module Function AutoFillNewRecord(F As Form) Dim RS As DAO.Recordset, C As Control Dim FillFields As String, FillAllFields As Integer On Error Resume Next...

Many thanks quest4 tried it but it does not work

Hi, I would like to know what code I need to populate a field with the last record information - similar to the Ctrl apostophe. I can upload the database in question if required. Thank you