Recent content by gunslingor

  1. G

    Relationships: Lookup table question

    I was trying to keep it very simple, this is a basic question of maintaining database normalization without imparting functionality limitations or slowing down the process of filling in forms. It would take a lot to describe everything, so all I can really tell you is that this is related to...
  2. G

    Relationships: Lookup table question

    I have a table called "compensating measures" that has a primary key consisting of 3 fields: Patch ID, OS, vulnerability ID. All three fields comprise the key to guarantee logical duplication of data doesn't occur. I also have a table called "cyber assets", which has one field called OS and a...
  3. G

    Access Reports and Evidence

    Hi all, So we have a database used for baselining cyber assets (i.e. securing them with checklists), the database currently spits out 3 reports: device information report, device base-lining report, and regulatory standards reference. External to this, we have two reports that are generated...
  4. G

    Help form and documentation

    THANKS! make use of control tip text Don't like it, too limited. make use of status bar text Same have a button or picture control which when clicked opens a popup form with a recordsource of a help table This is what I have now... but resizing the picture on the form for various help...
  5. G

    Help form and documentation

    Wow, stop all the chit chat fellas, lol. God, no one has a good solutions months and months later?:banghead:
  6. G

    Help form and documentation

    Wow, don't every speak at once... Am I ugly or something? Thought this would be a common issue with common solutions.
  7. G

    Sharepoint Linked Table Uneditable

    Nevermind... under settings you have to disable check-in/check-out.
  8. G

    Sharepoint Linked Table Uneditable

    I'm just starting out to learn SharePoint, which I utterly hate thus far but anyway. So I have successfully linked to the sharepoint list in my DB, but I cannot edit any values for some reason. I can edit them in sharepoint and both systems update, but when I type in ANY box in access I get...
  9. G

    Help form and documentation

    What's the best ways to implement help windows and the like? What I did already was to create a form with just a picture control, then whenever the user clicks and 'info' icon the help form is opened and the "picture" property of the picture control is changed to the relevant Help Picture...
  10. G

    Compact and Repair Concerns!

    No worries buddy... its just totally out of context... I think the code your looking at, as I believe I stated, was removed and replaced with the tiny code snippet referenced later. Within the context of the conversation, That ultra large chunk of inefficient code with the warnings turned off...
  11. G

    Compact and Repair Concerns!

    Not sure why your giving me advice on the warning commands Rainlover. Regarding the "value" auto-complete problem previously discussed, I solved it. De-compile/Re-compile fixed it and now all my Values are capitalized again. Thanks guys.
  12. G

    Compact and Repair Concerns!

    Thanks for all the input guys, I guess I'll just proceed being happy the bloat is gone and assume I fixed some unknown bloating issue. Not much else I can do. True, but I think I've had one or two issues in the past and found it safest to include the value. I can't remember precisely, but I...
  13. G

    Compact and Repair Concerns!

    And the crowd goes silent!
  14. G

    Compact and Repair Concerns!

    -Really, I meant its been growing as I added code and develop it. But I am a computer engineer and for the amount of text and logical data in there, in the general sense, seems to me to be about 5MB or so worth of data and 32MB always seemed way to high. -I use a lot of DAO recordsets in my...
  15. G

    Compact and Repair Concerns!

    Okay, so I've been developing this DB for 6 months now. It has slowly been growing and currently sits at 32MB in size (the front end only). I have been doing the occational compact and repairs, which usually drops the file size by about 5MB any time I do it. However, this morning I did a compact...
Top Bottom