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  >>   linked table problem and need advice Hello, I had a problem with a linked table. The program is access 97 sr-2 and jet 3.51, on a dell pent4 with 1 gig ram, running on widows server 2000 sp4. I have a fe and be, and the be tables are on the same pc I was working on, today. I was editing some forms, coding, running queries, etc. for about two hours, and then clicked on one of the linked tables (I had opened and closed th... 5 28.08.2006 01:15:54 How do I create combo box composed of previous data entries? Hi, I just want to have a combo box where the options are all the previous entries not unlike the drop down box for website addresses in the IE address bar. Ideally, it would be good if these values were from another table so that the other table automatically updates if a new value is entered in the table with the combo box. Any ideas? Josh... 2 28.08.2006 00:33:14 Populate a text box value based on another text box value I want to populate a text box value based on the input from another text box. Can I do this?... 2 27.08.2006 22:16:02 How do I Install spellcheck for Spanish? Can anyone tell me how do spellcheck and grammercheck in Spanish?... 2 27.08.2006 17:47:01 How can I make MANUAL CALCULATIONS permanent I constantly check "Manual Calculations" in my excel, but every time I close the program, it reverts to automatic calculations. ... 3 27.08.2006 02:39:17 SENDING EMAIL I AM DONE COMPOSEING MY EMAIL BUT CAN'T SEEM TO FIND THE SEND BUTTON? I KNOW IT SOUNDS SILLY BUT I CAN'T FIGURE OUT HOW TO SEND IT?... 2 26.08.2006 00:37:00 Switchboard & Forms I have a couple forms that when opened, I have them display in Datasheet form view. I added a switchboard and now when I open the forms through the switchboard, they open in the columnar view. What do I need to do to make the forms open up in the view I want (datasheet)?... 6 25.08.2006 23:07:02 how do i change the junk mail filter settings how do i change the level of accepting junk mail. ... 2 25.08.2006 20:13:34 Lost Data during Compressing and Restoration of DATABASE HELP, HELP!! I lost data during Compressing database ... Do you know how I can restore original datas? After compressing a can't open database. ... 2 25.08.2006 19:03:03 graphing in access Hello, I have some knowledge of Microsoft Access but am unaware if the program can create graphs. Can anyone answer as to whether or not Access allows you to graph data? Thanks! -- LLB... 3 25.08.2006 18:55:44 how do i set up a query that typing first three letters give me t. I am a new user of of ms access. I am working on only one table with 5 fields and would like to know how can i view two fields (one text and one number)in query mode by typing first three letters in a prompt box to get the whole word in one field.... 2 25.08.2006 12:34:10 records in subform Hi there I have a mainform which the user enters records into the tblevents and a subform which enters records into tblinvoice. Although the relationship between the tables is one to one, multiple rows appear in the tabular subform for a user to enter more than one record. Then of course should they attempt to an error message displays saying the changes will not be succesful as it ... 7 25.08.2006 08:47:02 Adding images to a DAP I'm trying to add images to my data access page. I used a table to input the information, used a text field to store the location of the images, and used the image function in "Design View" for that field on the DAP. When I go to view the record, I see the dreaded red "x" instead of my picture. When I right click for "Properties", some of the information is not available. Any ideas... 2 25.08.2006 07:03:02 Why is my system Lagging since I Installed the Office 2003 update. Ever since I had D/L the U/D's for Profesional Office 2003, My system is running VERY SLOW!!! the way that I know that it is that, is that I uninstalled it and everything whent back too norm. The only problem is, is that I had reinstalled it because it was within the U/D's for Access. My system specs are as fallows; CPU 2.4Gig, 512 Ram, P4 Pentium MB, intergrated sound, (sorry but I am ... 1 25.08.2006 05:49:01 Access Trying to use old report, but how to update to new table?... 7 25.08.2006 03:21:50 Invoice/Reports How Many Copies Printed? How do I instruct my database to tell me if an Invoice has been printed already, and that if someone has printed it already the next copy will indicate it's a reprint? And if I really had my way it would tell me something like reprint-1 or reprint-2. Thank You.... 4 25.08.2006 03:06:56 How do I find a record in Access if I only know 1 piece of info? Using Access 2003, I want instant access to individual client records when I only have one piece of information. How can I achieve this using access?... 4 25.08.2006 01:41:42 Linking two tables via a third table Hi guys! I have a problem. Basically, I have two tables of two different kinds of customer (a direct applicant, and an applicant from a third party). These need to be kept separate, and can not be merged into the same table. Each kind of customer can make a payment, which is stored in the payment table. This table is linked to the two customer tables via an Applicant ID, with Payment ... 5 24.08.2006 20:38:59 send an excel sheet by internet ? i want to send an excel sheet,,,once I press send by email as attachment sheet there is no availability button to send this sheet.. where do I press to send out the sheet. ? the toolbars are probably not viewed properly? I used to do it with Windows 98 now with Windows 2000 I am unable to work the same method.. thank you for your help..... 3 24.08.2006 19:52:17 hOW CAN YOU MAKE FLASHCARDS ? i NEED TO MAKE A WHOLE BUNCH OF DIFFERENT CARDS , EACH W/INFO i WILL BE TYPING IN AND THEN i WOULD JUST LIKE TO PRINT AND CUT OUT. ... 3 24.08.2006 19:50:58 report based query Thanks for taking the time to read the following: I have a query and report based on that query which requires 2 parameters to be filled, a start date and an end date. To confuse matters, I have a pie chart as a subreport based on the same query and parameters. My problem arises when the user opens the report they would have to enter the range date parameters 5 times. Is there a way to ... 8 24.08.2006 19:41:18 FoxPro and Access I am trying to take a foxpro 7 table and copy it to access to make a access mdb. I have included the code I am using. The code posted works as far as making my MDB and new table and so far it copys some records to the new access table. I have 27 fields I need to get copied but I cant seem to get passed 11 fields I keep getting a " Command contains unrecognized phase\ keyword" error. Any help... 9 24.08.2006 16:35:37 Multiple Databases?? When would I want to set up separate databases instead of one overall database? My initial intention was to set up a marketing database to keep track of our mailing list and what mail pieces were sent, to whom, when, etc. But then I thought I should expand the database to track JOB information when someone responds to our marketing. Now I'm wondering whether they should just be 2 d... 4 24.08.2006 13:34:03 How do I format a field in a table to default to email (mailto:)? I'm putting a form together to log email addresses. It keeps defaulting to the http format, not the mailto format. How do you set this automatically in the table that stores them? thanks.... 4 24.08.2006 13:10:02 Table off the Relationship window In Access 2003. I set up my tables in the relationship window and saved them. When I opened next day. One of the tables is not shown on the screen although I can see the relationship line to it. I have tried the scrollbar and resizing a number of ways. I just cannot get it on screen Any suggestions welcomed. If it is not fixable, can I delete the whole relationship table and start ... 3 24.08.2006 13:01:14 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  >>