Search results

I concure, but this does present the problem that the field UNID may not be unique unless its check in programming. I have made an autonumber key for the IP and cyber assets table, I've changed the existing UNID to a calculated field... so it can never really be edited. All those child fields...

I suspect the right thing to do is to just make the UNID a calculated field, then use an autonumber for the primary key to link other tables... the only problem with this now is that the UNIDs may not be unique and there is no way to ensure that they are without searching everytime someone makes...

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

SHMEG HEAD! Nice to see another Red Dwarf fan out there, on the information super highway. Anyway, That sucks. Access has zero flexibility.

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

I was afraid of that. I had thought of your solution, to use a separate table and reference by key, but this would still require me to go through the entire table and assign number keys to each of the 10,000 records which would not really accomplish anything since I could just as easy put the...

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

Thanks, but I can't seem to view anything in design view. I have almost completed this part of the project. In case anyone needs assistance over the next, say, 10 years: (windows XP, access 2003, VBA, Printing, Batch plotting) 1. Add something like this to the form_open event to populate...

I found this and it works great!: http://word.mvps.org/faqs/MacrosVBA/AvailablePrinters.htm However, Now I need a similar method to tell me what papper sizes are available for a printer selected. Any ideas?

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