Threads Replies Last Post 153 Pages: <<  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  >>   Relational Data Bases I am a new User of Access and am wondering where is a good starting point for understanding designing a relational data base,eg: when to use 1 to 1, 1 to many. many to many etc. Thanks ... 2 21.07.2006 12:12:49 Product Key I keep being asked for a 25 digit product key code.I downloaded the beta trial from PC Advisorwith no mention of any code. It started off with 45 logs on allowed, I am already down to 19 and starting to worry that it will all freeze or worse... 1 21.07.2006 12:05:01 Duplicate Data Can Someone please help I creating a database to help a friend with his courier business. I have three tables: tblcustomers, tblServiceType, tblCustomerRates. Most Customers use all the services provided by the courier and each customer has unique pricing for the services offered. This is what i want to do: When I enter a new record in tblCustomers using a form I want the tblCust... 4 21.07.2006 09:00:01 microsoft office 97 and trial version Microsoft Office 2003 I purchased a new computer that included the trial version of Office 2003. I did not install the 97 version but installed the backed up folders that included several word documents. I tried to email a document but the receiving end could not open the file. I had no problem with the previous version when I included word files in my emails. My question is, if I decide to uninstall the tr... 2 21.07.2006 05:48:22 my email my email... 2 21.07.2006 05:45:17 access where to find Access training dvd's... 2 21.07.2006 03:10:15 How do I add a trendline to a chart? I need to add a basic trendline to a chart. I know I have seen it before but I can't find it now that I need it. Go figure...... 7 20.07.2006 23:12:01 Exporting to word for envelope My read-only users need to have the capability to print envelopes from the contact form I set up for them. I would like to set up a command button "Envelopes" and have the data export to word so they can then print an envelope. I don't know how to do this or if this is the best way of doing this. It was suggested that I have them use the mail merge in word pulling the info from acce... 3 20.07.2006 21:40:28 Unwanted prompt Every time I try and open my form, I get prompted to Enter Parameter Value. I don't know how to turn this off! ... 2 20.07.2006 20:44:33 how do i set up access for training I am trying to built a database that can generate reports telling me when training is needed, what training, and who should be trained. In this same database I am also trying to put in info for tracking program discrepencies, recommendations, and corrective actions but I keep hitting a wall. Noone in my office is proficient in using access and I am lost and confused. ... 3 20.07.2006 20:07:09 how deep does Access file search go? I work at a library, and we're planning to use Access to index our campus newspaper. I can create all the fields, I need, and we're going to attach e-copies of the article. Is the text of these files searchable in any way, or does Access only search its own fields, acknowledge that the record has a file attached, and stop there? Because we're a library, the retrievability of those fil... 3 20.07.2006 19:25:10 Looking up table value & displaying in a form I seem to have lost my correspondent from previously so I’ll try my question again. I’m trying to find the right function, or query procedure to look up a registration fee in a table, based on pricing factors a registrar will identify at sign-in time. A table called tblScheduleRetreatFees holds 100 individual fees. It has four fields in it - FeeID, RegistrantTypeID, DurationTypeI... 8 20.07.2006 19:04:02 saving data from a calculation in the control source I have set up a field to calculate the "calibration due date" with the =DateSerial(Year([LastCal]),Month([LastCal])+[CalFreq],Day([LastCal])) in the control source field of CalDue. The due date calculates but the problem is that it does not save in the table. How can I get the data to save in the CalDue field of the table?... 4 20.07.2006 18:05:59 Could some one please Help! Sorry no one answered my question. Hello Experts, I need help. First question: I have a main form (Clients) which allows user to select from a list of client ID's. A number of textboxes or fields get filled up. Now one of these textboxes is called Condition or the condition field. I now press a command buttopn which opens the orientation form. In the orientation form, I want to display records based on the text in... 4 20.07.2006 18:05:20 updatable linked xls can a linked spreadsheet be updatable? ... 7 20.07.2006 16:55:50 Creating Labels How can I create a label using input from a form. The label wizard only accepts data from a qry or table. I have created report with the fields from the report on it but need to convert it to continious label to print on the Dymo Label printer.... 3 20.07.2006 16:03:02 Network drive has changed A new network drive has been created with copies of all ACCESS dbs. When opening a db on the new drive which is linked to another db, an error message is received that the path is no longer valid. The db on initial opening displays MAIN:form (menu) only. Pressing the F11 button displays all the related objects. Clicking on any object produces the path error message. How do I change t... 4 20.07.2006 15:28:02 how to put them together Is it possible if l create hyperlink to combined all my 8 forms to be 1 form,13 queries to be 1 query and 11 reports to be 1 report. After that l create button to open my system... 7 20.07.2006 13:34:02 How do I display db when only form shows at open? When opening the database, only the form is displayed. Minimize the form and no db info is displayed. It is linked to another db.... 2 20.07.2006 12:21:35 User Unable to Open File Access 2003 One of our software developers just asked me a question regarding a problem opening an Access file. He has the file stored in a shared folder on his local machine. Another user was trying to open the file and was unable to do so. He was able to open the file without a problem, so he thought that the issue might be with the lock file. He deleted the lock file, but the o... 2 20.07.2006 12:04:45 Grouping query date by work week I SQL below is what i kinda want just slightly changed. How do i get [date by week] column to group the date by work week. Our work week is Wed - Tues. Also how can i get it to display the week ending date i.e Week ending Employee Sum of Units 18/07/06 Bob 150 25/07/06 Bob 300 SELECT DISTINCTROW Format$(TimeSheet.Date,'ww y... 2 20.07.2006 05:52:26 Doing stuff by Date hi. In my startup form i have a textbox withthe control source =Date() [text27]. I have another textbox(unbound) [text29] where i want to put another date. What i want to do is when [text27] = [text29] then 'do some stuff' [text29] = [text27]. How do i put the a value in [text29] and keep it there?. i put in 21/07/06 in the default value and when i reload the form it comes up 30/12/1889. i... 5 20.07.2006 05:29:23 How do I run a Query from a form? Can anyone point me to a simple tutorial or description of how an Access query can be ran from a form and the results displayed in the form? (I know how to build the basics of the form and lay down controls but to make them function and reference the query is the part I am stuck on) Thank you! Quin... 12 20.07.2006 05:16:02 using forms for data collection Hi, could someone check my logic. I think I'm doing the right thing, but sometimes I get these scary doubts. I'm building a form to collect data and send it to a table (VS. having data in a table and seeing it on a form.0 Is this a legitimate use of Access? The term "source field" keeps throwing me off, because my table is blank, and so it's not really acting as a "source" to my f... 3 20.07.2006 02:43:11 will power point presentation run automatically on dvd? I have a photo Power Point presentation that I am going to copy to DVD. When I play as DVD will it start playing automatically, or does it have to be manually started? This will be used in a waiting room where the DVD player is part of the TV with no evident controls.... 2 20.07.2006 00:17:02 153 Pages: <<  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  >>