Recent content by chrismcbride

  1. C

    Some questions- database splitting

    [No message]
  2. C

    Some questions- database splitting

    Mansoor I think that the split route is the way to go... I'll answer # 3 first. While you could have a single shared FE on the server, but better to have a separate local FE for each user. You would then have a separate development FE that you use to make your changes. At some point when you...
  3. C

    check box

    ON the Open of the form, set the control's Locked property to True. Then on the update of the check box, re-set Locked to False.... Chris
  4. C

    Sum column of calculated data on sub form in a module?

    If you have a sub form that has, say, a Price field and a Units Ordered field. Then you have a calculated control for the value which has a controlsource = [unit_price]*[units_ordered]. Then you put another control in the footer of the sub form and set its controlsource to =...
  5. C

    Confirm Edit? Confirm Delete?

    The NewRecord property of the form might work for you... Chris
  6. C

    Add Textboxes together to create long address?

    Try =[Customer_Address] & " " & [Customer_Address1] etc etc Chris
  7. C

    A-97 and A-XP

    I am looking to migrate my split A97 db to AXP. However not all the computers on my network are up to running XP. Does anyone know if it is possible and/or advisable to access the new XP back end from the old A97 front end??? Any issues I need to take into account? TIA Chris
  8. C

    Heeeelp!!!

    Things like this are sometimes solved by opening a new blank database and importing all of the objects from the old one. Chris
  9. C

    Changing the Record Number

    Pretty sure you can't customise the look of the navigation bar, the number displayed there is simply a count of the records that have been returned to the form. You could replace the navigation bar with one of your own design. Once that was done you could put whatever number that you wanted in...
  10. C

    Autonumbers

    1. Since the Autonumber can be viewed as soley the database's way of uniquely identifing each record, you can often get away with not showing it at all. After all, if the user can't manipulate it, why does he need to see it. Alternatively you could hide the control that displays the Autonumber...
  11. C

    Is this a trappable error?

    Boy this is frustrating! I am pretty sure that the Design changes it thinks it is finding are me programmatically hiding, enabling, showing and changing text in various bound and unbound controls. This is done based on if each record has it's 'approved' field set to true or false. I have tried...
  12. C

    Is this a trappable error?

    I have a form on my distributed database that has it's format changed based on certain record characteristics and I am getting a message or error (I am not even sure which it is). The message is ---------------------------------------------------------------------------------- <frmWhatever>...
  13. C

    right click to bring up form

    Just a thought, but what if you tried to close the pop-up form on another event. Perhaps the Activate of GotFocus of the destination form? Like you are on form1, you right click to get the pop-up. ON the pop-up you make a selection that indicates to open form3. In form3 put the code to check to...
  14. C

    Adding Info from Two Forms to One Table

    The only reason I can think of to have two forms is that all the controls will not fit onto one. If this is not the case, then put all the controls on the one and hide the ones you don't need until the control that defines if they are needed is updated. If you do need two forms, then make them...
  15. C

    .Index

    I would guess that the .Index property is Read Only. Check the help file.
See more
Top Bottom