Tables
in [Access]
|
Cross References Help I'm sure this question has an easy answer. Just can't figure it out on my own. How do I design a situation where I can have multiple cross-references created for my records? My current setup: tblResources -ResourceID -ResourceText tblCrossReferences -ParentResourceID -ChildResourceID I have a many to... 13 May 2010 10:29
Custom groups moving from assigned to unassigned. Every now and then, some or all of the database objects that i have assigned to "custom groups" get unassigned and appear in the "unasgined objects" group. I've even had database objects get mixed up and appear in the wrong "custom groups" When this error happens I have to reassign all of the database objects... 11 May 2010 19:03
"free" ip number when I remove device from database, not delete? There is an active thread on this same topic in the Forms group. Sandroid wrote: Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it is also deleted from IP table. This should work such as the IP addr... 11 May 2010 15:41
"Free" ip address in asset database, not remove? Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it is also deleted from IP table. This should work such as the IP address remains to be used in other device . How to resolve this? If I change the relation t... 11 May 2010 15:41
"free" ip number when I remove device from database, not delete? Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it is also deleted from IP table. This should work such as the IP address remains to be used in other device . How to resolve this? If I change the relation t... 11 May 2010 14:33
To index or not to index I have a table of stuff stored in a repository and an attached table of inventory dates, linked one-to-many by an Autonumber ID field. I regularly need to find the oldest or newest inventory dates (or all, in order by date) for each item record in the inventory table, which is normally an automatic case for ind... 12 May 2010 06:58
Search Form runtime error 2448 I am attempting to make a filter by form search for a issues/comment database that I created. I copied a form and VB template, switching out the names for what are being used in my database, but keep receiving a runtime error. It seems common from what I've read looking for answers, but everything that I've found... 11 May 2010 23:25
Update - Microsoft Responds to the Evolution of Community What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sev... 18 May 2010 09:16
Text wrap in column headings Can you tell me how to wrap text in column headings? I also need to know how to wrap text in a cell. Thank you. ... 9 May 2010 19:49 |