Search results

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...

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...

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...

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...

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

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

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

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...

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...

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...

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.

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...

And the crowd goes silent!

-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...

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...

I don't believe anything is based on crosstab queries. Basically the parent form would be a list of cyber devices, and the child form would be a list of all patches relevant to that device. i.e. The relationships are like Devices (primary_key)-->link table(devices.primary_key &...

PR2 understands my frustration... yeah, I know I can edit the subform outside the main form, but when you have 3-4 layers of forms, it sure would be nice to edit them all in the master. CJ made some interesting points, but note that I am talking about design view here. But his points are...

Hey guys, this is a problem I've been facing for many years and its really slowing down my development in this instance. I'm wondering if anyone else has or "has never" had this problem and what work arounds they know of. The problem is simple, create a form, plop a subform in it... all works...

This is such a cool solution I found that solved problems I've been having for years with listboxes, I had to share: scenario: You have a form with a bunch of stuff on it, one item is a primary key of the source table. You also have a listbox that is based on values in a different table and the...

I had a similar problem and found the ideal solution and wanted to share. I had a form with a key textbox and a list box with IP addresses. I wanted the list box IP addresses to be filtered based on what key is displayed in the textbox (basically, so the list box only shows the IP addresses for...