Recent content by harrisharris

Thanks for your help. Found the problem. Button on my form was close only and not save. added the save code and now the duplicate msg comes up.

Stop Press I have just tried entering the duplicate part number directly into the table - the duplicate warning message displayed. Obviously something wrong in my form.

The DB was desined by myself (amateur). At one time I did switch off messages - Tools - Options - Edit/Find - Confirm box all three were switched off but I have since switched them on again and still no warning about attempting to add a duplicate part number.

What I mean by "nothing happens" - To add a new product I have a form. i enter the duplicate part number and different details (e.g description etc). when i close the form, there is no indication of anything untoward i.e just the same as when I add a genuine new part number. when i look at...

I have an Inventory Control database. One of the tables (Products) has a field (PartNo) as primary key and is indexed "Yes". When I attempt to add a part number that already exists, I was hoping that I would get a warning message to the effect that I was trying to enter a duplicate...

I am using XP Pro with Excel 2002. I have just downloaded Calendar Control 10.0 and when I try to use it, Excel shuts down with messaage "Severe problem encountered", the details refer to dodgy ocx file. Any ideas on how I can fix this please?

Thanks a lot Simon, - on shift last night, My son helped me out as well. Your help and patience appreciated. Laurence

Simon, Thanks, but I seem to be getting into a bit of a mess. The code I already have for my combo box after update event is quote Private Sub Combo30_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst...

Morning Mute101, I have done the Query, but need an explanation of how to reset the control source/filter. I am capable of getting into the code of the after update event, but need to know what additional code to put in. Many thanks Laurence

Thanks Andy, I will hang on a bit and see if anything else comes up, if not will let you know what happens. Laurence

I have a form based on one table called products. The form is used to display product details based on a part number selected from a combo box. Whenever I open the form, all the fields other than the combo box display data. I would like to be able to open the form and have all the fields...

Thanks a lot combo, I have tried the add-in suggestion and it works like a dream. This has given me ideas to build on.

P.S.S I have removed all code from the workbooks and re-installed as a module of the project. This seems to have done the trick. I think this is what you have both been trying to tell me what to do! Very many thanks for you assistance. Regards Laurence

P.S. My code is stored in the appropriate sheet of the VBA Project. Should I have stored it in a module?

Morning Combo, I think I get the drift, but, would appreciate some advice in laymans language. My situation is that I have about ten workbooks. In each workbook there is a particular sheet for which I have designed the macro. The sheets are all the same in design but cover different areas...