Threads Replies Last Post 99 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Save Data I need to save my data to a disk I am using Access 2000 What is the best way to do it I also need to save it 3 or 4 times a day Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200609/1 ... 10 30.09.2006 19:05:43 How do I select several records and save them as a new record I need to create visit records that track who visited what work site. The visitors' information already exists as records in my databse. I need to select several existing records (names, numbers, etc) from tblpersonnel, add the visit specific information and save it all as a new record. I have created a form based on tblvisits that contains the visit fields and put in a subforms that con... 3 30.09.2006 18:59:49 Auto fillin of field I have a table called 'client'. In it is a field called dateclosed. There's also another one called 'casestatus'. When someone enters a date into the 'dateclosed' field I would like the 'casestatus' field to automatically be filled in with the 'closed' option which is already in that field (closed and open are the two options in the 'casestatus' field). Any advice with step by step inst... 6 30.09.2006 18:28:18 "Deconstruct" a large financial report table I got an Access DB from our State Controller's Office (SCO) they use to produce their "Annual Special Districts Report". SCO simply provides the data in their annual report with very little analysis. I want to analyze districts comparatively but the SCO table design makes it very difficult. There are 16 tables in the SCO DB each of which contain data from one of their specifics reports ... 7 30.09.2006 18:15:01 Working on a DB I hope This won't be to long or a string to many. I'm using ACCESS 2000 on a lap top with windows 2003. I go to about 20 different new subdivisions a day I track the building progress of each new house (slab, walls, roof, shingled, Ect) on the data base I'm working on frmMain has County, City, Subdiv. name, house address, lot#, date, Ect. I have the DB it to the point of data for all this is... 9 30.09.2006 17:59:48 Table design In my DB i currently have a junction table: ModelsXREFSuppliers. It has FKs to the Models table (Model_ID), SupplyParts table (SupplyPart_ID), and the Suppliers table (Supplier_ID). I have just created a new junction table called temporarily called Windows. This table contains the same 3 FKs, but it also has three additional attributes that apply for only the windows. Is good databas... 9 30.09.2006 04:35:42 Date Calculation Challenge I am working with a Microsoft Access Database helping a non profit organization try to figure out how many nights in a month people are staying in there shelter. I have two fields a Check In Date and Check Out Date Field. Therefore to figure out the nights a person stayed, I minus the Check Out by the Check In Date. The problem is if they check in the prior month, let’s say Febru... 2 30.09.2006 04:31:39 Multiple entries in a text box Hello, I have a table in a database, with a text field called "parties-appellant". The user may enter one name in the field or they may enter several names, each separated by a comma. I've asked the user to use a comma because I use a Split function in the VBA code that is part of a form for which the table is a source. When the user enters a single name into the parties appellant fi... 13 30.09.2006 00:35:25 combo box fills in two feilds I have 4 fields on a form that are as follows: [Callers name],[town],[software], and [comments]. I have two tables involved in my problem: [Call log] and [town]. What I’m look to accomplish is that when I select a town in the combo box of the form, it will update the software field. Now the town table has two columns: [Towns] and [Software]. For an example, when I select a Concord for ... 8 29.09.2006 19:02:02 Access Table Datasheet Name To None I am runing in Access 2003 I am seting the table datasheet name to none when I come back to the table its falls back to Auto Y dose it fall back to Auto when I just changed it to None? Thak You Zev ... 11 29.09.2006 18:42:01 List box in table design While creating my database I put a list box in a field, following directions, however, when I enter records in the database, the only item selectable is the first field. What did I do wrong? I see all the choices but cannot select them.... 2 29.09.2006 18:00:58 DB Normalization Issue I have a problem trying to normalize data that has been imported from an Excel spreadsheet. I am hoping someone can point me in the right direction. The sheet has a fuel type column, and a corresponding price per gallon(PPG) column. There are 10 sets of these columns (Type 1-10 & PPG 1-10) Each fuel "type" indicates a fuel quanity to be purchased to receive the corresponding PPG. Each... 4 29.09.2006 16:28:02 Field colors How do you tell a field that if the date is 21 days past it needs to be "a color" -- Thomas... 6 29.09.2006 13:30:01 How do you consolidate a menu bar into one row across? I made a custom menu bar. However with the number of different functions it runs across the screen and then hides under an arrow. How do you consolidate a menu bar into one row across? Thanks! Bill... 1 29.09.2006 11:11:02 Help out your US Air Force Im a command post controller for the US Air Force and I am trying to figure out a way to use Access to automate a large number of our quick reaction and emergency notification checklists. Right now our checklists are in word document format, but I would like them to be in an interactive form based in Access. The checklist are basically printed out and sit in a book with a document protec... 6 28.09.2006 23:22:53 Removing Sort Order? Hello, Hope I'm using my database design terms correctly, and that this make sense. In a secondary table, I'm using the Lookup Wizard to look up a values in a primary table. In the primary table, there is only one field, and that field is the primary key (i.e, I'm not using AutoNum to create a numerical primary key, I'm using the text itself as the key). I entered my records in the... 17 28.09.2006 23:19:25 Annoying Autonumber bug There's a bug in Access where the Autonumber reuses old numbers as the primary key. According to Microsoft, this bug was supposed to be fixed in the latest Jet version...Not! Apparently, every time you compact your database, some tables may reuse old numbers as the value in your Autonumber field. Now, my users get "Duplicate values" error when they add records in a table. Help! ... 3 28.09.2006 23:09:01 Can you set Autonumber to start with zero? All, I was wondering if it is possible to set an autonumber field to start with zero instead of one or for that matter any other number other than one? Thanks in advance. - CES... 8 28.09.2006 20:45:02 Find which user has record locked. I have pessimistic locking/edited record. How do I find out which user has locked a record in a form? -- Regards Tom... 5 28.09.2006 20:29:09 How do I add a search functionality to a DAP? I am having trouble following the instructions I found regarding this question. In the instructions, it tells me to basically add a command button, and then enter in an "OnClick" event procedure to make it a find button. However, after I place the button on my page in design view, I do not have the option of adding an event procedure for anything, let alone for the "OnClick" field when I... 3 28.09.2006 18:37:46 Date value I want an Age of a person on the particular date when I acess the database. I want age to appear automatically on entering Birth Date of person only.... 7 28.09.2006 16:48:17 ADDMENU MACRO AND TOOLBAR NEED FIRST, THE 200741VERSION REMOVES THE TOOLBAR AND REPLACES IT WITH A QUICK ACCESS BAR AND CUMBERSOME RIBBON. THEN AN UPDATE B2TR COMES OUT AND ONLY IMPROVEMENT IS THAT I CAN NOW SEE THE SCREEN BY MINIMZING THE RIBBON,,, BUT,,, IF YOU GOT RID OF THE TOOLBARS AND ONLY CREATED A MACRO FOR SUPPOSEDLY SUBSTITUTE TOOLBAR MENU CREATION,,, WHERE IS THE DETAILED HELP ON THIS NEW PROCEDURE AND WHE... 1 28.09.2006 14:01:03 CategoryID, name in combo box.. why does it "work"? Newbie, but not finding the answer _how_ this works.. Just can't seem to get it. given tables Object(*ID, Name, Desc) and widget(*wID, f1.. Object, ...fn) such that records in Object show up in widget as a drop-down box.. So each record in widget references a single record in Object. I have something that seems to work at the table level, and I don't know why. I had to reference 2 colu... 6 28.09.2006 00:43:02 Import Table Structure from Excel I have been a long time user of Borland Visual Dbase (because of its convenience and simplicity of use) and would like to migrate to Access but have found it unwieldy. I frequently receive data from surveys with a few hundred fields. The data arrives as a .dat (text) file plus a data map (Excel). It has always been an easy task to convert the data map into a table specification, which I... 18 28.09.2006 00:34:02 Access 2002 Table Structure Primary Key I'm having a problem with a table in Access 2002. For some reason the primary key gets removed, don't know how, when, where. But all of a sudden the forms don't work and the users get weird error messages. When it happens, I put the primary key back on the table, compact and repair the database, and everything is Ok. But then it happens again. It is always the same table in the database.... 7 27.09.2006 15:42:58 99 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>