Tables
in [Access]
|
Deleting duplicate parents and grouping children to single par Allen, Thanks for the response. I figured the building would be complex; by simple I meant I want to keep the steps and decisions for the user as clear as possible. And while I think I'm capable of the encoding (at least by using macros and calculations and so forth, VB is beyond me) all the necessary steps ... 11 Jun 2008 22:03
Deleting duplicate parents and grouping children to single parent So here is my question. I'm building a rather simple db consisting of a parent child and child table in a one-to-many relationship (based on the Parent's ID and the Child's "ParentID" field). For the intended workflow,data will be regularly entered by importing or cutting and pasting records from an Excel works... 11 Jun 2008 11:17
how can I make footnote appear at the bottom of the relevant page I am in the process of writing a report but for some reason my footnotes are appearing on a preceeding page as opposed to the bottom of the page where the reference is, how do I get the footnote on the bottom of the relevant page? ... 11 Jun 2008 11:17
Linked Table Manager Problem On this one computer, running Windows XP Pro SP2 and Office 2002, when I want to use the Linked Table Manager, and get to the point of selecting the new location, if I try to use the drop-down menu, Access hangs, and has to be closed using Task Manager. If, instead of using the drop-down, I just use button for ba... 10 Jun 2008 13:03
Linking a ComboBox with a text box? I have a table with several fields set up. The first field is Product # (AutoNum) and the last field is Unit Price. I want to create a form with a combo box where the Product # can be selected from a list, and once selected the Unit Price (corresponding with the Product #) is automatically displayed in a separa... 10 Jun 2008 08:56
Protecting some data from some users I've got an existing customer database on which I need to add some private fields to my form which are only accessable to some users while still allowing all users permissions to edit every other field. I've only got limited experience with Access, so I'm not clear on the best way to do this while still maint... 11 Jun 2008 13:20
Subdatasheets, Multiple Linked tables I will admit I new to designing databases, but I am not a computer novice by any means. I am trying to design a simple database about ocean currents at various locations throughout the Gulf. Initially, I was going to use 3 tables within a single database to store the data, but I would have easily surpassed the ... 11 Jun 2008 08:12
MS Access 2007 I really screwed up I bought 2007 and put it in my PC without removing 2003 and now nothing works. Any command developed with Event Procedures is not working. My calenders, Forms with date read by queries and buttons to open or close reports or form are not working, I tried using 2003 and the same problem exist.... 10 Jun 2008 00:12
Need a way to track changes made to an existing table I am responsible for an already existing database that will have infrequent updates/changes to the existing records. I would like to be able to keep track of the dates when these changes occur. Is there anyway to make a field that will automatically record the date each time a record is updated? Any suggesti... 10 Jun 2008 13:03
replace table without damaging the data after split Hello, I have distributed my database to be used. I have split it to the FE and BE. I found it later that I need additional field in the table and I want to modify it. My question is how can I replace the table after modification without loosing the data. Users already having data. in the BE. Thanks in... 19 Jun 2008 12:41 |