Threads Replies Last Post 153 Pages: <<  12  13  14  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  >>   conditional form background colour hi, I've got an access 2000 form with a tick box on it. I want the forms background colour to change if this box is ticked. How can i do this ? Many thanks. Nigel ... 3 28.07.2006 11:37:12 explain how to delete this trial program I wish to delete the trial offer of office 2003.I do not have an office,am retired,and do not want it. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft ... 2 28.07.2006 04:08:36 dumb question There is a pretty elaborate access database i'm working in. Where can i see where the information i'm seeing in access is being pulled from? does that make sense? -- rhbm... 2 28.07.2006 03:25:21 How can I make maps for weddings? I am trying to make a map for driving directions from the church to the reception. I can't find a template in anything so if anyone can help me out that would be great. ... 6 28.07.2006 03:10:45 ACCESS is it possible to use word wrap in an access table (2003)... 2 28.07.2006 02:33:01 2 primary keys? or wildcard searches I have set up a pretty simple db. One table with a list of people as a primary key (lastname,firstname) and then connected it to a table of expenses connected to those people, rental cars and hotel rooms mostly. I wanted to make the connection between the two the names which is why I made it one field instead of a last name field and a first name field. I created a search using a query t... 2 27.07.2006 22:51:55 document allowing my wife travel abroad with child I need an affidavit to give permission to my wife to tavel to her country with our child...DO YOU HAVE ONE?... 3 27.07.2006 22:45:11 Query total has minus number I'm Brand new to access. I have one field called Stroke with yes/no check boxes. I have done a total query using the sum feature but my result is -3 when it should actually be a positive number 3. Why am I getting a negative number for my query? Thank you so much. SELECT Sum([Code category totals].Stroke) AS SumOfStroke FROM [Code category totals] HAVING (((Sum([Code categor... 4 27.07.2006 18:29:01 NEED HELP UGRENTLY!!!! PLS HELP Hi everyone, I would like to use access to make a search engine. I have created 3 different topics of database. e.g. database1 - Speakers All 3 database were contained product's information e.g Factory Tel. no Fax no Contact person e-mail Product Product No. XXXXXX XXXXX XXXXX XXXXXXXXXXX XXXXX XXXXXX XXXXXXXXX ok, now ... 2 27.07.2006 17:49:39 Trying to open database in 2007 beta I work for a large company - they provided me with a access database tool that is used to link me to the many other tools that I use on a daily basis. For the most part - all of my other programs and files work great after downloading the beta version of Office 2007 however I am having problems with this access file. I have both the .ldb and .mde files (I used the .ldb to extract the ... 2 27.07.2006 14:25:35 MS Access - Move to a Specific Record in a Form. Right now I have a form that loads a recordset of employees and their information. I want to be able to choose an employee from a combo box on another form and then load that employee and their information on the main form. BUT... I also want to be able to move through rest of the recordset as well. I guess I just want to move to the specific record chosen. I have tried the recordset clon... 2 27.07.2006 12:54:12 New Database. Need Help! Hi. I'm running into quite a mess with my database here. I had to create one to track payment plans for accounts that have been delinquent. It has to show the base amount, total amount with penalties and interests, payments made, etc. What I did was I created multiple date & payment fields to track the payments, i.e., date1, payment1, date2, payment2, etc. Now, what they want me to... 2 26.07.2006 23:41:35 creating mailing labels from an access data base customer mailing I'm trying to help my computer illiterate friend update his customer mailing list and create mailing labels from his access (2000)data base. I seem to remember doing this with no problem with access 97, but can't do it here. Help!... 8 26.07.2006 21:39:01 Import Horizontal Text Data, Change to Vertical I need to import a monthly expense text file into Access with the following layout: Field1 - SSN Field2 - Name Field3 - Month Ending Starting at Field4 are 20 sets of expense data that requires 4 fields each (80 fields total). One row per employee. FieldXX(1st) - Expense Date FieldXX(2nd) - Expense Description FieldXX(3rd) - Expense Code FieldXX(4th) - Expense Amount The next s... 9 26.07.2006 21:08:50 Newbie, need help setting up Hello there, I work for a large real estate office and i handle the billing. I need to be able to look up a last name. And from there be able to create an invoice (so it needs to pull info from multiple tables) that will have the advertisng they have used for multiple properties, and Copier usage. So of course i'll need prices programmed in. I've never used Access. Is this a good program ... 2 26.07.2006 20:39:30 creating expressions to calculate multiple date differences on sam I have created a list of 65,000 duplicate Client Identification Numbers (CINs) out of an original list of 500,000. The duplicate CINs indicate that a client has applied for enrollment to my program more than once. I have a Date Of Birth (DOB) field, and an Application Date field for every CIN. (FYI: most of the clients are under the age of 2 years). Out of those 65,000 duplicate ID... 2 26.07.2006 20:33:13 2007 I downloaded 2007, in response to an email from Microsoft, but now my "Favoutites" are not on the screen when I bring up Windows Internet Explorer.... 2 26.07.2006 19:36:04 publisher 2000 and 2003 should be made compatable i have tried to use publisher on my pc for the first time and dicoveered that it is not compatible with publisher 2003 is this another way of microsoft trying to rip off the general public. I have only just started using microsoft product and overall have found them to be of a really shoddy quality. i suppose though if you have the monoppoly on the market you can continually spew out any... 3 26.07.2006 18:07:02 Refreshing Indexes I'm using Access 2002 and I'm wondering if there isn't a way to refresh all the indexes to a table? -- Harry E Vermillion IT2 Division of Wildlife State of Colorado... 6 26.07.2006 18:06:02 AUTOMATICALLY RESTARTING AUTONUMBER FOR NEW CUSTOMER- TOUGH! Dear Highly Esteemed Access Gurus, Thanks for reading my post. Ok, the situation is that I have a database with a one-many relationship. So one customer, with one customer reference can have many items of different types such as: CUSTOMER 1 4 pots 2 plates 9 cups What I want to achieve is that for customer 2, the numbering starts all over again so for customer 2 the numbering ... 3 26.07.2006 17:59:30 Tabular data with mixed dates - how to handle? I need a "nudge" in the right direction with this. I don't often use Access but do need to use it here. I have an Excel spreadsheet that lists customers, consumption, etc. and there is an entry for some months for each customer. Some are every month, others are every other month. I have separate rate tables that I can link so that I can generate bills from usage and the applicable rate ... 1 26.07.2006 17:11:49 Hyperlinks for Internet Pages with Frames I'm trying to use command buttons on a form in Access 2002 to launch Internet pages. The pages are different chapters in an online manual. The manual uses frames, with a left frame showing the table of contents and a right (main) frame showing the chapters of the manual. When I paste the URL for a specific chapter into a hyperlink in a Word document and then test it, it launches the p... 1 26.07.2006 15:03:01 Adding an average column to a PivotTable report I have a PivotTable report that breaks out hours worked (data) by project worked on (row) and month hours were worked (column). I can easily add a grand total column to the end of the pivottable by selecting the month field and clicking the subtotal button on the toolbar. How can I change/edit this subtotal column or add a new column that calculates a total average hours worked for all... 1 26.07.2006 14:15:02 how to edit and customize a template I am the office manager for a non-profit organization which runs a campground, and I have downloaded an access template that I believe can be modified to work as a reservation program for our campground, but I am clueless as to how to begin. Can anyone help?... 2 26.07.2006 04:55:57 Grade keeping for report card. I am a new user to Access. I am building a data base for an adult Bible School. Classes are twice a week for 5 weeks with the 6th week being test. They can earn 10 bonus points to be added to final grade. If there is a book to read, and they do not read it, then 10 points is deducted from their final grade. All five worksheets for each class are to be totaled . The test is to be 75% of the fi... 3 26.07.2006 04:54:47 153 Pages: <<  12  13  14  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  >>