Search results

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

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

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

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 have one database called asset management. It consists of one main table called cyber assets. Most fields in this table are linked to a manually created lookup table inorder to restrict user input. There are also two additional, none lookup, tables used to list a) the IP addresses (there can...

Here's a link to a post I made a while back which can provide you with more background (see the relationships image at the top): http://www.access-programmers.co.uk/forums/showthread.php?t=239883 So I got everything to work exactly as I wanted it to.. the listbox has its rowsrc manually...

The form has numerous buttons on it, all function correctly on all computers except that one button does not function on ONE computer but works on every other computer. When you click the form load button on this faulty computer, it just hangs as "not responding" on occation and other times...

Here are the three linked tables, the big one is the control source of the main form: Here is the control I am trying to get to work on the main form, a 2 column listbox: Here is the non-functional query: SELECT CYBER_ASSET_TFEs.TFE_NUM, TFEs.TFE_Name FROM TFEs INNER JOIN CYBER_ASSET_TFEs...

My DB has a front end and a back end. There are currently about 10 tables and 5 forms and roughly 1000 lines of code. All my table names are like this, for example: CYBER_ASSETS, MFR_MODELS, IP_ADDRESSES All my form names are like this, for example: VIEW_CYBER_ASSETS, EDIT_CYBER_ASSETS...

Ok, I have one main table called cyber assets with fields like OS, MFR, Model, device type, etc, etc... I have a bunch of lookup tables for selecting the values associated with some fields, and I have a few other tables for multivalue things like multiple IP addresses associated with the same...

Okay!~ My main form just has a couple of buttons off to the left and a subform/subreport window filling up the rest of the screen. When you click a button, it changes the subform/report record source (i.e. my main form acks like a shortcut bar or, in html, a frame window). Everything works...

Problem: I have one table with 10,000 records. The table lists a hostname (i.e. computer name) and all the associated "windows services" running on that machine along with fields related to description of service and setting of service. So the relevant fields in the table looks like this...

:cool:Okay, I have a form with a subform. The main form will have things like "Print Selection" Button, "Printer" combo box, "Copies" text box, and similar things one might expect in a print dialog box. The subform is datasheet view only and pulls it's information from a table that lists...