Search results

  1. theDBguy

    Form as Form? or String?

    Just curious, do you get an error if you requery a hidden (invisible) listbox? Or, is this a problem of speed? ie. Is requerying two listboxes too slow compared to requerying only one of them?
  2. theDBguy

    Solved Difficulty sorting an alphanumerical text field

    Just thinking out loud; but instead of leading zeroes, perhaps you could use decimal numbers below 1. eg. .01, .02, etc
  3. theDBguy

    Introduction

    Hi. Welcome to AWF!
  4. theDBguy

    Using SQLServer

    If you're totally starting from scratch, then you probably already avoided half of them.
  5. theDBguy

    Solved Password the DB how to:

    That's a little hard to believe because two files with the same name cannot be in the same folder together; but if you managed to do that, then you're good to go.
  6. theDBguy

    Solved Password the DB how to:

    Well, that depends on two things: Do both BEs have the same name? And will both BEs have the same filepath as when you created the new linked tables to the one with a password?
  7. theDBguy

    Solved Password the DB how to:

    Here are the typical steps when developing a secured BE with an FE. Create the BE file Add the tables in the BE Apply a password to the BE file Create the FE file Link the BE tables to the FE Access will prompt you (the developer) the password to the BE If you enter the correct password, then...
  8. theDBguy

    Solved Password the DB how to:

    If you did put a password in the BE and someone double-clicks on it, they would get an "enter password" prompt by design, without you having to use any VBA at all - if that's what you were after.
  9. theDBguy

    Solved How to set up unique customer codes based on customer types

    Here's a link to the new thread. https://www.access-programmers.co.uk/forums/threads/making-the-primary-key-as-the-client-code-from-the-client-name.335065/
  10. theDBguy

    Solved How to set up unique customer codes based on customer types

    You might consider starting a new thread and just include a reference to this one, since it's an old thread. Just a thought...
  11. theDBguy

    Solved Password the DB how to:

    Did both of them work?
  12. theDBguy

    Shaffy's Introduction

    Hi. Welcome to AWF!
  13. theDBguy

    Hi Fellow Access Users

    Hi. Welcome to AWF!
  14. theDBguy

    Merry Christmas and Happy New Year!

    I see snow now... Merry Christmas to all!!!
  15. theDBguy

    Solved Raised command buttons

    Hi Neil, Welcome to AWF! Maybe the first step is to check your Form Properties and see if you have Use Theme set to Yes or Enabled.
  16. theDBguy

    Error: The command or action 'SendObject' isn't available now.

    Just thinking out loud... Does Thunderbird open when you use Application.FollowHyperlink?
  17. theDBguy

    If a queryvfinds no records

    There's a couple of approaches here. https://www.theaccessweb.com/forms/frm0043.htm
  18. theDBguy

    MaxHeadroomdecided against

    Hi. Welcome to AWF!
  19. theDBguy

    OutputTo Excel error

    One way to export data into Excel without a stored query is to use the CopyFromRecordset method.
  20. theDBguy

    I'm sure there is a simple solution asset tracking MY NEW PROJECT.

    If I understand that correctly, a normalized structure might be something like this: tblPartTypes TypeID, pk TypeDesc tblParts PartID, pk TypeID, fk tblEquipment EquipID, pk Desc etc. tblEquipParts EquipPartID, pk EquipID, fk PartID, fk
Back
Top Bottom