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  >>   How do I match cells in different columns with words in them? I u. This is an Excel Question. I use the Lookup formula to match columns but when there is a word is doesn't work and I don't know why. R A B C D 1 AAAAAA This Works1 AAAAAA This Works1 2 ABCDEFG This Works2 ABCDEFG This Works2 3 PEOPLE This Works3 PEOPLE ... 2 08.09.2006 13:48:38 how to set up .tiff files reader I cannot read my sent files in my windows fax Program ... 2 08.09.2006 11:48:39 Trying to change bitmap photos to jpg. I have been trying to saving my jpg photos to my computer and they convert to bitmap. Does anyone know how I can undo this since I am not able to have them printed this large? -- latinleeza... 2 08.09.2006 09:30:31 Table RelationShips Each Employee can have many jobs Each Dept can have many jobs So....I have this tblEmp EmployeeID EmployeeName tblJobs JobID JobName tblDepts DeptID DeptName tblEmpJob EmployeeID JobID So I connect tblEmp to tblEmpJob tblEmpJob to tblJobs and tblJobs to tblDepts What I need is a One on One relationship between Depts and Jobs but Access says that this isn't correct... 5 08.09.2006 05:46:49 Planning a Database, Help Please Greetings all, I am planning a Database that will track different computers in different buildings at different sites. I was thinking, I need to set it up with Three Tables. tblSITE SiteID - Autonumber (PK) SiteName - Text tblBuilding BldgID - Autonumber (PK) SiteID - Number (FK) (Many side of a 1 - M with the tblSite) Subnet - Text (will be a place to put the specific subnet nu... 3 08.09.2006 00:17:59 Option button default; Parent/Child relationships; Creating new re I have a couple of questions that I hope will be as simple to solve as my mind is... 1. Set default for check boxes and option buttons to "unselected". Mine are gray dotted. 2. When I try to create a new record in JobID form, old data in unbound text boxes does not clear. Can I set something to accomplish this? 3. I can't add new items to Combo Lists? Can you help me fix this? I wou... 1 07.09.2006 23:29:02 How reset autonum back to 1 ? I have emptied my table and want the autonumber key to recommence at 1. This column is a part of many relationships so I cannot delete the column. Is there an easy way? Thanks.... 9 07.09.2006 23:05:02 Can't save record. The Microsoft Jet database engine cannot find a I have an autolook up query that automatically fills data in on a form. The primary key is the phone number. It works fine when I it finds a matching key. If it doesn't find a matching key and I try to save the record I get the following message. The Microsoft Jet database engine cannot find a record in the table <name> with key matching field(s) <name>. (Error 3101). I understand... 1 07.09.2006 21:46:01 missing numbers Hi, Is there a way to find out what numbers are missing? Example Field: MyNumbers, Type: Integer 1,2,4,6,7,8,9,10 the missing numbers are 3 and 5 Regards, Bre-x ... 3 07.09.2006 21:35:53 Switchboard usage preventing my form loading data form my database Hey, I have a form set up that is working perfectly (it consists of a selection of combo boxes for selecting records from a linked in excel sheet.) I have now completed a switchboard which opens the form. One problem though -when the form opens the form fails to populate my records that should be there. I get 0 records back. If I simply enter and exit the design mode of the form the p... 5 07.09.2006 20:46:02 creating a common page to access all data Hi, I have created some reports which I want to access using a single page. I am thinking of creating buttons on that page, where each button invokes a report and displays it. How can I do it? Thanks for your time ... 7 07.09.2006 20:33:02 my data disappears I set up this database several months ago and it worked fine. I recently added data to a form (which already contained data) but when I reopened it today, all data was gone from the one form. Although the AutoNumber continued at the point I left off, I can not find the entered data. I tried entering datat again, and after closing and reopening, again it was blank. Also, when I try to pre... 6 07.09.2006 19:50:02 Split Database Some while ago, I split my database into a Front End (Forms etc) and a Back End (Tables only). I have since added some further tables and all works well. However, when I check through the Table Manager to update everyihimg, i find that my new Tables are not listed. When I check back in the Datasheet and select the Tables tab, I see that the old Tables have a little arrow at the side of t... 5 07.09.2006 17:33:02 Linked Table - no access when "can't lock file" My db has appx 20 users. My db links to a table in another departments folder. The link is only used for a combo box drop menu which allows my user to select a name form their db to store in my db. There are times (I'm guessing when the other department is in their own db) that my users get "can't lock file". However, at those same times, I DON'T get "can't lock file". So, apparentl... 1 07.09.2006 17:15:02 3 tables with up to 2 fields the same for each I have 3 tables created the common fields are contnum and tpname1 with most important listed first. Third table has tpname repeated for different circumstances. Access would not let me save or close this table. Tpname is one of the links to the original table. What can I do?... 3 07.09.2006 16:08:02 Filter by Last Name and First Name Hello, I'm creating my first database and one of the issues I'm having deals with a form I have created. The form is simple, it has a combo box for last name, a combo box for first name and a date field. This form should give someone the ability to enter the information and then view a report based off of the criteria entered. I have it working to where it displays the report with th... 3 07.09.2006 15:00:02 Function with optional parameter How do I code a function with an optional parameter. Also, in the function's code how do I test for the presence or absence of the parameter? Thanks.... 4 07.09.2006 11:26:17 mixed zone in IE during posting I have Access Monster (www.accessmonster.com) set as a Trusted Site, but when I am posting the zone shows as "Unknown Zone (Mixed)", which implies that the web page is referencing another domain. Does anyone know why that might so, and what domain(s) are referenced? Does anyone know just what privileges must be given to which sites in order for all the features of Access Monster to work cor... 2 07.09.2006 11:00:51 Compare data I have a database and need to compare data from within this based on Serial ID Serial ID is not a primary key as users can have information more than once and hence then the Serial ID is replicated. When a quote is given the user checks the box to confirm this! However, to ensure that the user has not just clicked this without sending a quote, I need to compare the data against the actual ... 1 07.09.2006 10:10:02 Filter Bday list by month I have a form where the persons name and birthday and the spouse name and birthday and anniversary are entered. I want to be able to run a report and print all birthdays and anniversaries for the month of [Enter month] how would i set up the query / report to show this information? thanks in advance!!... 2 07.09.2006 01:56:53 English to Tables I have this scenario worked out that I need to make into tables. Any suggestions Welcome. Each Table (Restaurant Table, not Access Table) Can have several Checks Each Check has One Server Each Check has Several Items Each Check has One Refund Each Check has One Gratuity Each Check has One Service Charge Each Check has One Discount Each Check has One Tip Each Check has One Void Each... 5 07.09.2006 00:54:04 Outlook Auto Signature I am trying to edit an Auto Signature and when I go to advanced edit, it pulls me into Notepad instead of Word. I have my Mail Formatting set to use Word as my mail editor, how can I get Outlook to use Word as the Auto Signature editor?... 3 06.09.2006 23:48:02 Corruption or design flaw? Hi all I have a database in Access 2003 (2002-2003 file format). There is a form that updates a query table. On certain records, updating the entry for one particular field on the form does NOT reflect in the relevant field being updated in the query table. On those records where this effect is observed, it happens every time however many times I attempt to alter the field via ... 8 06.09.2006 22:13:47 Set focus - the basics I've been trying to 'set focus' to a field on one of my forms. Formname = frm_Test Field name = gamma How do I set it so the field gamma is the field with focus ? Please keep it simple - I've looked in these groups and on the web and I can't seem to get it to work. All I get is invalid macro name Thank You ... 7 06.09.2006 21:40:16 My Outlook Inbox will not open. How do I access the Inbox Repair . When I try to access the Inbox Folder in Outlook, I get the message that errors have been detected and the folder cannot be opened. It states to repair the problem, go to Inbox Repair Tool. I have been uable to access the tool even after following all instructions I can find on how to do it and to make repairs. What am I doing wrong and how do you access the Inbox Repair Tool?... 2 06.09.2006 20:11:39 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  >>