Search results

just for completeness: we solved this problem as follows: we changed the table of multipliers to include all possible Severity*Probability*Control permutation values (there's only 36 unique values). That way I was able to link this table in a query to anything with RPN in it and use calculated...

my idea so far was to have a calculated field in the query that drives the risks subform (based on tblRisks) but what i can't figure out is how to access the values in the table of multipliers based on the RPN value. Multipliers table (I call them "bands") looks like this: BandID HighVal...

Actually, given the fact that I took over an already started project (so some of the naming conventions could be better) i think the table structure is correct. Departments and Site can also be assessed individually (separately from workstations). For now, any ideas on rolling-up individual...

ok, i've isolated the 3 tables involved in this. The tblAssessments table (left) stores actual assessments (it's like a transaction table). "Level" means either Site, Department or Workstation "scope" of the assessment. The listRisks table (right) is a fixed list of applicable risks (50 total)...

ehm, i'm not sure my company would allow that :) i realize that makes it harder, i'm sorry! a general concept idea would do fine. Thanks!

Risk Assessment database - "rollup risk scores" from workstation to department... I don't know if it'll make sense out of context like that. I am working on a Risk Assessment database, where a factory can be assessed to see which risks exist at workstations/departments or the whole facility...

Hi, all. An Access 2003 question: I use an OLE control frame in my forms to add pictures of items. It works fine, but I don't like having to right-click and select "Insert Object" - it's not user-friendly. I would like to have a button "Add Attachment", which would open a Browse dialog box and...

Ok, nevermind, I'm sorry. All I needed to do was NOT include the ID field and the AutoNumber just does its thing. It didn't work when I tried it, because I took ID out of the INSERT INTO part, but forgot to remove it from "SELECT" part. So it would tell me that the source and target fields...

I have a database of Assessments, each record having multiple subforms. I am working on a button, which creates a "similar" (same) assessment, copying over all the subform records/selections. So, after I actually insert a new assessment, pasting all the values from the original Assessment...

Could someone suggest how to do the same thing without the .DoMenuItem command, which is unreliable. DoCmd doesn't seem to have a relevant method.

Yes, well, that's pretty obvious. So, does anyone know if there's a built-in way of doing that (like via the DoCmd.)? Thx

Now, how about actually displaying 2-3 line paragrpaphs per item within a Combo Box? Otherwise DropDown part has to be extremely wide in my case. I have a Part Name column (fairly short) but then a requirement description, usually a paragraph describing when the part is required. Thanks!

I had to close and reopen the form, which has the acCmdAppMinimize in its "on open" handler. that does it. how did you change your code to make it work? thx!

what i noticed is that when you open your app from the desktop location, it'll open behind other programs now on screen. if you double-click it directly from an open folder, it'll "popup" over other programs like it should. still searching for the solutionk, though!

That's cool. But I already have Photoshop and used to working with it, removing the background, adding shadows, effects, etc., so for me it's easier to stick with it. Thanks!

Sure enough, a proper icon designed in Photoshop works fine. I had to download a freeware Photoshop ICO plugin.

yes, but first you have to pay a subscription fee :D

actually, i don't know much about batch files. i've observed someone editing old windows 3.11 .bat files years ago, but don't know anything about how they're used now. would the user be clicking on a batch file? thanks.

I ran across this Microsoft article and was wondering if some of you adventurous souls out there might test this, whether or not this applies to maybe viewing Reports without having to actually close a PopUp form (with Access hidden/minimized). This is relevant to Access 2000, which doesn't yet...

Ok, another odd thing about focus. I mentioned that another blank dummy app with only 1 form opens with the form in focus. Not really. What REALLY happens is that when I open the app from any folder, it becomes the active program on top (my actual app as well as the test dummy app). If I open...