Search results

  1. G

    Diagnostic help

    Hello, I have a 32bit access application that ties to an external db on our server. Been using this for years on several computers. We just got a new computer, and it has 64bit office. I run it as a .accde, with access 2013 runtime. I'm still getting an ODBC call fail error. Which...
  2. G

    Access Front-end Auto-Updating Utility ?

    Trying to find and download Bob Larsons Access Front-end Auto-Updating Utility. I can't seem to find the actual link anywhere. Including BTAB's website. Is it still available? Thanks.
  3. G

    Navigation form vs switchboard vs anything else

    I'm creating a new database. To be honest, I've never worked through the best approach to create a great user interface before. I'm looking for ideas on how to best approach it. What you've come to value for end-users when they first open the app, etc. For sake of brevity, let's say I will...
  4. G

    Unbound List box .Selected property not working correctly.

    Gentlemen, After being off this project for a while, I was able to get back to it today and with your help, fix this task. Thanks again for your expertise.
  5. G

    Unbound List box .Selected property not working correctly.

    DB Guy, Thanks a bunch for taking a look at this. Can you explain step 3 above? How are you grabbing all of those selected, to remove, if after the first one in that group is removed, it is resetting? I also tried this code to remove them, but It runs from front to back of the loop, and...
  6. G

    Unbound List box .Selected property not working correctly.

    I have two unbound list boxes. The first one is populated with File names from a given folder. I want to be able to push them to the other list box, using the multi-select, selected property. Then, remove the selected items from the first listbox. The .selected only seems to work on the last...
  7. G

    docmd.SendObject but with filter

    Haha! I wrote that?!? Seems like a lifetime ago. LOL The funny thing with VBA in the past few years is I always seem to be re-learning it. I'll have to dig in real deep for a few months, then not touch it again for a year or more. Glad it helped you out!!
  8. G

    Deployment- Storing Application Settings

    NauticalGent, Thank you for your feedback. So, I'm guessing that your table for this is in the BE, and you have a record for each user? (So it can hold user-specific settings as well?) This seems like a good option.
  9. G

    Deployment- Storing Application Settings

    What is your preferred method of storing application settings for access? Things like Back end location (so an updated FE knows where to look), User Preferences, and other "global" settings. I'd prefer not to hard code them in VBA, because they may need to change at some point. But that is...
  10. G

    Run vba code or routine stored into field

    If allowed, please let me take a theoretical spin-off of this. We've already admitted that the proposed idea was a poor one, and other solutions have been given. I use an off the shelf estimating software. Within it, it allows the user to create their own formulas that derive values for the...
  11. G

    Fresh Start :) Best way to handle Note fields

    Pat, Thank you for your response. I've played around with this some more over the past few days, and I really like the concept you showed in the example. I also see now that adding the ParentRecordID in the Entity table is unnecessary and wasteful. I believe this will be my path forward...
  12. G

    Fresh Start :) Best way to handle Note fields

    Pat, Thank you again for your efforts. I'm getting closer, but I'm still wrapping my head around it. Right off the bat, you taught me of a new VBA event I've had plenty of opportunities to use, but never knew it existed. The Form_BeforeInsert event. To expand on your idea, would it be...
  13. G

    Fresh Start :) Best way to handle Note fields

    Hi Mike, Thank you for your help with this. When I say "multi-parent". I meant that I will want the notes table to store "notes" records for the company table, and the contact table, and others as needed.
  14. G

    Fresh Start :) Best way to handle Note fields

    All, Thank you for your advice so far. Pat, I'm still struggling with the concept of the entity table. I've created a new, simple test db and attached it. It includes two "parent" tables, tblCompany, and tblContact. Then a Junction table, and the child tblNotes table. It has a form...
  15. G

    Fresh Start :) Best way to handle Note fields

    Thanks Pat. In my case, I'm expecting more than one note per record with the "parent" tables. Is it safe to say that the Entity table you proposed will not work with a 1 to many relationship? as the FK is being held in the record of the parent table? Or am I not understanding its use case.
  16. G

    Fresh Start :) Best way to handle Note fields

    Thank you! This is why I come and post my work from time to time. To learn something from the experts. I'll need to read that article a few times before it sinks in. But I'm working on it.
  17. G

    Fresh Start :) Best way to handle Note fields

    I like Gasman's approach. Does anyone see anything wrong with it? I'm thinking I could use something like: tblNotes ID TableNameID TableRecID Other needed Fields Then I could pull the Table ID out of here: Using something like Select Id where Type = '1'; What do you...
  18. G

    Fresh Start :) Best way to handle Note fields

    All, Thank you for your responses. I'm about to carefully consider each one in the meantime, to ensure we're all on the same page, here is a visual representation attached. I admit, I'm starting to think it's not a great idea, but I'm having trouble coming up with a solution.
  19. G

    Fresh Start :) Best way to handle Note fields

    Doc Man, I'm not sure what you're asking. Please ask me a question if needed to clarify. The path I'm suggesting would be to have a column for each foreign key to link each table. So, tblA, tblB, tblC, etc. would each have their own foreign key column. As already pointed out, this would...
  20. G

    Fresh Start :) Best way to handle Note fields

    Ok, at the early stages of designing a new database for a client. The application will have a few areas (let's say 5 as an example) that will have note fields. There may be notes for a Company, for a Contact, for a project, for an Invoice, for a Purchase Order, etc. I've been taught that...
Top Bottom