Search results for query: *

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...

Rick you probably think I'm quite mad! - its not an autonumber field - but it is part of the key. I think its due to my SQL that the option field is not copying over!! - Its a long integer and I am obviously using the wrong syntax somewhere!! Do I need to change how I reference it? Fran

Hi Rick Works perfectly except for one thing - my table design. The key fiels of the options table is actually comprised of two fields, ra_no and option. Option is an autonumber that counts the options for that assessment. If I remove the key from the table and don't append the field option...

Hi Rick Have done as you have suggested. It copies records into the tables with a new ra_no, it only takes the first record from the options table through- and brings up the couldn't position to new record box. I have asked it to add the record to the table behind the query as well, have...

Do you know – I actually finally got it copying the right records into the right duplicate tables by adding another WHERE argument and using the text box, containing ra_no on the current form. But…. What you have just proposed sounds even better, I like the idea of more intuitive and simpler...

Hi Rick! my daft mistake!! Ra_No is a number that is automatically generated from the category chosen and a number field, which is updated via a routine which operates On Insert. It is not an autonumber. Is that why it doesn't work? I have removed my space, no longer get errors, but it...