Threads Replies Last Post 153 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  >>   Starting Defaults Greetings all, I have looked under the Tools>Options for starting defaults. I am trying to get the forms defaults to change so when I select create a Form in design view it is basically ready to go. Example: When I go to properties on a form Some choices are: Scroll Bars - Default is BOTH, I would like it to be NONE Record Selector - Default is YES, I would like it to be NO ... 3 13.09.2006 14:41:02 Requery data in a form Hi, I've scoured this discussion group for hours and am frustrated that I cannot 'see' the answer to my question. I have created a query that displays records where it finds a matching text string within a text field qryCheckName. I have created a form that displays the query data frmNameUnique. In the header to the form is an unbound text field where the user enters the text string the... 5 13.09.2006 13:42:01 I am trying to create a contact list without typing the info twic I am trying to create a contact list of the people I write contracts to without having to type the information twice. Really dont need the complete contract just the contact information. Can anyone answer this question?... 2 13.09.2006 13:40:30 Why are Junction Tables necessary? I have been reading about databases for just a few hours, so think of me as a complete muppet for the purpose of explanation... I don't understand why many-to-many relationships are not possible, and why we need two tables, each with a one-to-many relationship with a third table. Thanks for your help.... 4 13.09.2006 13:33:02 Access 2003 - No fields listed in Form Wizard When a colleague (an Access novice) attempts to create a new form based on a table or query, no fields appear in the 'Available Fields' list box of the wizard. New forms can be created in design mode where the fields are availble, but as I say, my colleague is a novice and prefers to use the wizards. SP2 has not solved the problem. Any sugesstions? Regards, Finli... 3 13.09.2006 13:04:01 Two Pages Instead of One Hi, I am creating a form and I want it to be one page long when I print it. A line is showing up on the bottom of the page. When I try to pull down the form to the 11 in. point I get two pages, one with only the line on it. How can i get rid of the line and/or extra page? Thanks... 6 13.09.2006 12:04:07 sending and receiving e-mails I'm having trouble sending and receiving e-mails. Do I need to do something before I can send or receive?... 2 13.09.2006 06:16:15 Out of memory Hi I've got a problem thats been bugging me for a while. I'm the administrator with full rights of a database created in Access97 There are various forms and tables etc - all pretty standard stuff, there's nothing fancy. It's in a multiuser environment where the database is stored on a network drive but the problem only affects me. If I'm in a form (any form) and apply a filter,... 15 12.09.2006 23:41:28 How do I retrieve addresses saved on a CD Rom with .pab and.pst fi My hard drive crashed and I need to reload my address book from a CD rom that was created some time ago. I am using Microsoft Office 2002. how do I go about doing this?... 2 12.09.2006 23:33:01 Rec a good getting started book for 2000 ? Hi all :) Can anyone recommend a good 'Getting Started' guide for beginners to Access 2000? It needs to explain the basics, starting at why you'd want to use Access in the first place. It must be very hands on, with the learner learning by doing rather than by reading and memorising, have clear objectives as to what the learner will be able to do on completion of each topic, and b... 1 12.09.2006 22:17:45 Form start point I am new to Access, is there a way to set the forms to open (when first openting the form) on the first open (empty) row of the database. Rather than displaying information from the first entry.... 2 12.09.2006 17:57:01 Can I make Linked Table Read-Only My db has a link to another's db which is only used to display a combo box list that I choose a name from. When I'm in my db choosing my name, apparently, that locks my co-worker out of his db that I'm linked to. Can I set my db link to be a read-only so that my co-worker will always have full access to his db even if I'm currently linking it? Thx, Dj... 10 12.09.2006 17:44:00 Command Button VB Coding I have a form linked to a table. I have designed the form to accept entries, edits and deletions. I have several questions in relation to command buttons. Table fields are: IDNo - Autonumber - primary key RegisterNumber - Text - uses Me.NewRecord to create new number - primary key DeptCode - Text - Table lookup using combo box Designation - Text - Table lookup using combo box DateSent -... 4 12.09.2006 13:43:34 Lookup for two columns? I have a table with Nos & Names. In another table, I lookup for Nos in the previous table, and want that the Names to be there also alongwith. Is it possible? Thanks ... 2 12.09.2006 12:57:31 Record Locking Rules When you choose record locking rules (I happen to be using Access 97 for this one...), do those rules you just set apply to the database, no matter who uses it, or to the user, perhaps on this database alone? How does that work? -- Jim... 2 12.09.2006 12:22:02 Problem with relations.... Hi all, I have the following situation: People ---------- People_id PeopleName PeopleLast ...... and Group ------------- Group_id GroupName ....... Every person can be a member of only one group. However, the number of people on one group is not known. One group may be empty, while other group may have many members. Do I need third table between this two tables to store t... 2 12.09.2006 11:09:31 Importing a .csv file I have my address book saved on a CD as as .csv file because I had to reformat my hard drive. I have now reinstalled MS Office 2003 and it will not let me import the address book back to my Outlook address book.... 2 12.09.2006 04:11:40 Problems with a select query I have thousands of records with donors history. I need to be able to pull a lst(query) of LYBNT's (Gave last year but not this year). I want to be able to do this from any selected fiscal year (2003, 2004, 2005, 2006) The query would need to show all who gave in 2003, but did not give in 2004 and so fourth for each year. If any one can give suggestions or help I would appreciate it.... 3 11.09.2006 21:48:19 set a parameter How can a set a parameter so that when I open a certain report it asks basically where to start. ie: I want to see all work orders beginning with "1 - 4500" ... 2 11.09.2006 20:20:02 Access 2003 - column for adding numbers In a form, I want to create and imbed a blank column to input a list of numbers that when added will automatically total in a separate and designated field in the same form, either as part of the same table or another table and that list and total remain as a permanent record within a specific record ID. ... 9 11.09.2006 19:59:01 Access 2003: Forms View and Reports I have created a small database - very simple - and view it presently in datasheet view. I would to be able to: 1 - view it in a laid out form style 2 - create a report of the data How do I do both of these... 7 11.09.2006 18:05:02 PLEASE HELP!!!! License information for this component not found. Please help me. I am an access newbie and cannot figure this one out. I have stumped the IT folks and others that know access well. I have been trying to install a program and get the following error: License information for this component not found. You do not have an appropriate license to use this functionality in the design environment. I am using WinXP and Office 2003. Other... 10 11.09.2006 17:26:01 Access 2003 - column for adding numbers In a form, I want to create and imbed a blank column to input a list of numbers that when added will automatically total in a separate and designated field in the same form, either as part of the same table or another table and that list and total remain as a permanent record within a specific record ID. ... 1 11.09.2006 15:38:54 Access 2003: Viewing Table I just set up a small table with a bout 8 fields. I am viewing the finished table in row/column format. Each column appears the same length. I need to be able to view the "Comments" field (which I set up as a memo field) in a column that is a bit wider. How do i change the width of the column? ... 3 11.09.2006 14:50:03 deletion trail for QMS system I have a table HYInReg which uses entry and edit forms to store records. My requirement for our QMS (Quality Management System) is for a form to be completed requesting a deletion from the records in the above table. I would like the user (using the form) to select the record and confirm it is the correct one and then to add additional information such as ‘request date’ ‘person m... 2 11.09.2006 13:44:18 153 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  >>