Recent content by frantik

Thank you very much for your help guys the problem was the bound field from the Cb_category box Much appreciated

Thank you DRahme Unfortunately still no joy. What is strange is that if I substitute a text box for the first combo box and typein the category it works. Is there something special I need to do with the combo box?

I should also add - that the row source is a table consisting of colums: Category and subcategory and relevant records are present

Hi I have a form that contains two combo boxes: Cb_Category CB_Subcategory The contects of Cb_subcateogry are dependant on the value selected in Cb_Category. Or rather it should be! It is not working. I have placed the following in the critera for row source of Cb_subcategory...

'Hi Ray I am clicking on the mde front end icon on my desk top - and directly on the mdb icon on the network drive. Although I have just copied a further database and a spreadsheet into the same directory and it is not allowing me read access to any of them - though I can delete them - so I...

Hi Ken They do - it is myself who is trying to access the back end - I have created and deleted from that folder - have just checked. However - what is odd is that I cannot see the ldb in the back end folder - have refreshed many times. Am very confused! Thanks Fran

I have also noticed that the ldb file appears in the location as the front end - not the back end. Could this be the problem? If it is how do I solve it please? Thanks a lot fran

Hi I have a multi user database - it is a split database - the back end is located on a network drive. Each user has an .mde icon on their desktops. When trying to access the application I get the message: "Cannot open G:/Database/database.ldb It is already opened exclusively by another...

Hi I have a form holding a few subforms. On one of these subforms is a drop down box which is populated via a query - its contents are dependant on - for that particular record. When I browse through the records - the query is not updating - so the drop down box gives me the same choices...

Thanks Guys Its working perfectly now!

Hi I have a form containing a subform. There are certain fields I want to check are completed before the record is saved. If they are not complete the user is taken back to that field. I have used the following code behind the save and Exit Button: If IsNull(Me!Combo116) Then MsgBox...

Hi I have two related tables table 1 projectno, workstage, description key is composite consisting of projectno and workstage table 2 project no, workstage, location, category, assignmentno key is assignmentno I have just added the workstage field - after finding that projectno was not...

Brill Thanks Me.refresh didn't work after the code - but did in the On Delete event of the main form! Thanks loads F.

Hi I have a delete button on my main form -which will delete a record from the main and subforms. However when I try and add an additional record I get the error message: You cannot add or change a record because a related record is required in table <name>. (Error 3201) The record I have...

Oh my goodness - Have finally got it working - thank you so much - I have learnt so much - not least that my sql is appalling - It never worked with option at all - but when I created a new field of a different name (called test for now!) to do the same as option it worked!! how is that!! but...