Search results

  1. O

    Find duplicate records and alter the second?

    Yes, only ever one duplicate of a record, but multiple records duplicated. So multiple pairs of duplicated records
  2. O

    Find duplicate records and alter the second?

    Hi Gasman, thanks for your reply. No there are potentially any number of duplicate records but they only are ever in pairs. I have a duplicate query, could I create this as a recordset, move last, move first, then move next, update, move next, move next, then amend, etc etc, I.e to amend every...
  3. O

    Find duplicate records and alter the second?

    Hi everyone, I regularly import data into my DB and when it comes in there are always odd pairs of duplicate records. The import process is automated using SQL statements in VBA. At the moment I discard these duplicate records using indexes. However I would now like to accept them which I have...
  4. O

    Convert SQL to VBA

    Hi, I have the following SQL append query which works fine: [CODE]INSERT INTO
  5. O

    VBA Loop to Requery Combo Field with Lookup

    Worked perfectly, thanks so much!
  6. O

    VBA Loop to Requery Combo Field with Lookup

    Hi, I have a main form "Quotes" I have a subform "Quotes Subform" The quotes subform is in datasheet mode and allows users to select all the different products required to build that particular quote. One of the fields is a Combo box "ProductID" that has a lookup from the products table and...
  7. O

    Refer to calculated field on Subform from Main form

    Thanks for all your help on things so far. Do you have any experience with stock inventories? You have seen the purchase order form/table I use. I was wondering the best way to implement some form of stock control. Its not totally straight forward as only about 1 in 5 of our orders are actually...
  8. O

    Refer to calculated field on Subform from Main form

    PS, thanks for your wider comments on other issues, I was aware of a couple but ignoring them in favour of solving this issue first. I'll take a look and take on board your comments re primary key. Thanks
  9. O

    Refer to calculated field on Subform from Main form

    Problem Solved! Thanks to everyone for their input, much appreciated. After Gasman and Zeroaccess last few comments I tried the following: 1) Moved the code to the subform on current event - This had same results and did NOT work 2) Added the code to a cmd button on the main form - This DID...
  10. O

    Refer to calculated field on Subform from Main form

    I agree with GK in the UK and was just about to post my suspicion that the calculated field was actually Null at the point the on current code is triggered and only populated just after. This would explain everything right? That’s why it works under debug but not live. Is there an event that...
  11. O

    Refer to calculated field on Subform from Main form

    Thanks. Yes just got the same results as you now but only with the break in. It still strikes me that this problem only occurs when using a form field with calculated control source. If you use a control that derived from the query it works fine??? Just annoying I cant use that option......
  12. O

    Refer to calculated field on Subform from Main form

    Yes, I'm a bit behinds you guys but just sussed that, thanks Thanks for all your help btw, much appreciated
  13. O

    Refer to calculated field on Subform from Main form

    Thanks, I'll persevere, just a quickie, where exactly are you putting the break point as I I put at the start of the IF the code stop prevents me from moving records on the form?
  14. O

    Refer to calculated field on Subform from Main form

    OK, so getting the hang of the debug tool I added an extra line in to see what value access thinks the control field is and even though it displays as 0 it thinks its NULL??
  15. O

    Refer to calculated field on Subform from Main form

    I can get the disabling of the button to work easily as I have proved this using another control on the form with a control source from the form query, its only when I use the calculated field as the control that neither the test text field nor the button disable work
  16. O

    Refer to calculated field on Subform from Main form

    Sorry, misleading maybe. Received is just the Caption, field name is as previously lissted:
  17. O

    Refer to calculated field on Subform from Main form

    Thanks for your input. To test this I have just deleted all other code from this form apart form this one IF statement and still getting the same results.....!!! losing more hair by the hour!!
  18. O

    Refer to calculated field on Subform from Main form

    I just don't understand how you have got that text box to show NO!! Whatever data I have 0 or >0 it still says YES, see following screenshots just taken: >0 =0
  19. O

    Refer to calculated field on Subform from Main form

    Not exactly. As you have seen the button works exactly as required Not exactly. As you noted the button works exactly as required and has been in use for a while, however the users have requested that this button becomes inactive if the Not exactly. The button as you noted works fine and has...
  20. O

    Refer to calculated field on Subform from Main form

    Sorry, didn't consider that, is this version any good?
Back
Top Bottom