Recent content by Benny1973

Thank you Hi Thank you for this. I have tried this out on my testing database but it doesn't work. But over the weekend I will try it on the real database and see if it does, fingers crossed. Thanks again

Hi, I wondered if anyone can help me. I can create a button to duplicate data from a form into a subform as below Private Sub Command159_Click() 'To duplicate work address into preferred address between different forms Me.Preferred_Address = Form_sfWorkDetails.Company_Name...

Thank you very much - that's great Thanks for your help, very much appreciated

Hello thanks for your reply. The users have full access to all databases involved and they are all on the same shared drive (server). The tables have been linked by right mouse clicking in the background and tehn looking for that database and then for the particular table to link to I got it...

Hi, I wonder if anyone can help me. I'm very frustrated I have a database that I didn't create and the links aren't working on other users pc's but they are on mine. There are 9 links to various databases. 8 out of 9 work on my laptop. The 2 important ones don't work for other users. If I...

Hi I wonder if anyone can help. I attach a table that is a material list (27000 records). When I add a new material I want to be able to see the last part code I created for a particular supplier. For example C001, C002 and C003 are for a supplier company called Chapters so I would scroll...

Hi I wonder if anyone can help. I attach a table that is a material list (27000 records). When I add a new material I want to be able to see the last part code I created for a particular supplier. For example C001, C002 and C003 are for a supplier company called Chapters so I would scroll...

Hi Many thanks that's the cascading combo boxes complete and working great, I've spent mroe than a week on this problem day and night and even in my sleep!! I may sleep well tonight now, many thanks Debbie

Hello there, I have spent a few days still searching for my amswer and found some help based upon searching the forum for cascading lists. There is a database there posted by Scouser called Car Sales Database. This is exactly what I need. So I have spent 2 days working on this and am nearly...

I'm not sure if this is going to give me exactly what I want. I will explain the whole database in more detail. Vehicle Reg No X333 JJJ arrives at the workshop and is allocated job no 888. A paper form is completed by the workshop staff - this is the workshop job sheet where they manually tick...

Uncle Gizmo I'm not expecting somebody to do it for me I'm hoping to find a database with tables and forms there for me to work from. I have spent hours and hours on this and it's only one part of the database. As I said I'm not a programmer so need to actually see the workings of the...

Stuck Uncle Gizmo Many thanks for pointing me in the right direction, it is great that there is an example of exactly what I need. BUT I can't manipulate this, if you look at the design of the database the tables aren't there and like i said I can't do the programming bit. I don't have a...

Hi I have trawled this forum searching for help with cascading combo boxes, it was very helpful but alas I need that bit more. I have 2 combo boxes and the result is displayed in a subform. The problem is that it will only display one selection made from the Combo boxes and I need multiple...

I have a similar problem If you look at the demo database it show 2 combo boxes. I need a sub report form to show the selection made but then to show lots of these selections in the sub report based on that record, are there any examples of this because the ones I've looked at on here only...

Multiple Combo Boxes - can't find the answer in the forums I am wanting a Combo Box to display Work Type Work Type has 18 types in the drop down list. When the Work Type is chosen I want to go to the next Combo Box that lists Work Codes relating to the Work Type. EG Work Type AIR is chosen...