Threads Replies Last Post 901 Pages: <<  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  31  32  33  >>   I can't open documents and tech support is useless I was running Word 2000 with no problems. I decided to get Word 2003. I cannot open/view any of my documents. I get an error message "The file whatever.doc is not available." Then, when I attempt to exit out of Word, it says that there have been changes made to Normal.dot and then to the Global Template. I have spent over 2 hours talking to tech support in India, but they have no id... 4 25.09.2006 15:41:49 Access 2003 pivot table limits I have a data table of 100,000 rows and I decided to play around with Access 2003's pivot table feature. In the middle of creating the pivot table, I got the following error message: "The query could not be processed: Error while processing a partition: 'Processing error [More than the maximum of 64,000 dimension member children for a single parent]' " Using a 3.2ghz dual core proce... 1 25.09.2006 15:34:02 size form 100% I am using a form as a switchboard. When I open the database, the form opens reduced in size. How do I get it to open 100% to fill the screen?... 4 25.09.2006 15:26:37 Link tables I have two tables, one with product name, lot number, quantity, disposition and another table with product ID number and product name. I need to link the two tables into one table... 5 25.09.2006 15:21:49 Data Type Mismatch...Syntax? I have an SQL statement that returns a 'data type mismatch' in the criteria of a DoCmd.RunSQL statement: DoCmd.RunSQL ("DELETE FROM Hardware WHERE Hardware.[record key] = ' " Forms![Hardware Form]![hardware list].Column(0) " ' ") (I've included spaces in the single and double quotes for clarity in this post) [record key] has an AutoNumber property setting, and [hardware list] list is ... 4 25.09.2006 15:06:36 Emails alerts from back end Hi to all! I've built a front end/back end batabase for our small company (10 users). It handles goods in out, works orders, etc. I'm now looking to set up an alerts system that emails users when eg: a works order is due. The only way i can think to do this is to have the back end open all the time on the server and running loops to check for the dates and times of certain entrys, then s... 6 25.09.2006 14:41:02 User rights in Access Database I have a database that is used for time and attendence (Login and logouts). When you open the database the "Security Warning" pops up (The prompt that warns you about unsafe expressions). When the user clicks "OPEN" it takes them to the appropriate splash screen, but when they hold shift as they click "OPEN", they can get to the tables/reports/etc. How can I password protect this database ... 5 25.09.2006 14:21:27 Lost Menu bar Hello, I've lost the menu bar in MS Access. When I right click on the tool bar and click "customize", "menu bar" is not one of the options for me to re-check. Can you tell me how to get it back? I'm in Access 2003. Thanks, -- Marc... 5 25.09.2006 14:16:02 SQL Delete of a single record Is there a way to code an SQL DELETE statement so that it deletes ONLY the first record it encounters (that matches the criteria)? Thanks, Dale ... 3 25.09.2006 13:42:48 Replication Conflict When one particular user replicates his database to the master, he gets a conflict with a field called "Gen_Tempfield*0. I don't understand what this is. I did not create a field called "Gen_Tempfield*0 in the database. An example of the data it gives is: Existing Database "Gen_Tempfield*0 = 642 Conflicting Database "Gen_Tempfield*0 = 602 Does anyone know what this means and how t... 8 25.09.2006 13:14:56 2006 West Coast Excel / Access User Conference 2006 West Coast Excel / Access User Conference - October 25-27, 2006 http://www.exceluserconference.com/WCEUC.html#Tentative_Schedule Mike Alexander Alison Balter Dick Kusleika Simon Murphy Jon Peltier Bob Umlas The regular registration period is coming to a close on September 30th. Be sure to register this week if you would like to get in before the late registration period begin... 1 25.09.2006 12:09:00 how come my file is working Why is my .doc file not working it is coming up with a jiberish code and no text example... i¶ž^Tm®z™Ø« ›;*Ëœ „dbÚ7<¨åíî -bcaRªÀ<]֯E8ê÷ ±bÀx?uþ´‚rÙÓGfXO¬M©wÈ 5½heέ.„Nüú+~„• M ¿žÙŸ šž?vÜåCÂ)ê]UKÅ  þ ‘Xe÷\ 7 íc$h´™Ñ 8Zûž ŒÓÕ ÈÓrâLë&‘ y2öžÕIHvQBa[z «© îÌtìßÖi'ßcañžA†ß... 3 25.09.2006 11:44:14 Changing Form Size! I have developed a db in Display setting 800 by 600, but now I have a new screen and change the setting to 1024 by 768. Is there a simple way to re size my formatting on forms because now they are to small, or is it bite the bullet and manually change everything bigger !! Thanks Bob ..........Jenny Vance ... 2 25.09.2006 11:37:16 CHECK constraint usage And the case against: 1) CHECK constraints cannot be created, edited or deleted using the Access graphical user interface. They can only be created via Jet SQL DDL statements. Once created, they do not show at all in the table Design View. 2) CHECK constraints are at odds with standard Access behaviour. While CHECK constraints provide a means of allowing multiple field- and record-level... 11 25.09.2006 11:28:17 ¸ê·½¦^¦¬µ©¸ê·½¦^¦¬µ©¸ê·½¦^¦¬µ©¸ê·½¦^¦¬µ© ¸ê·½¦^¦¬µ©¸ê·½¦^¦¬µ©¸ê·½¦^¦¬µ©¸ê·½¦^¦¬µ© ... 1 25.09.2006 09:48:41 test title test title... 1 25.09.2006 09:16:41 make query Hi all, Im trying to make a dinamic query(basing on several of other querys),is there a way to make a query the same as to make a table so if its needed it will be destroyes? ... 5 25.09.2006 08:16:00 Auto Populate Is there a way that you can auto populate a text box when you choose something in a drop down box?... 4 25.09.2006 07:44:44 Avg!!! I have a form that's used to disply the search citeria,the form looks like this : Name Job description phone Mobile Language Marks John employee 00 00 Italian 60 Tony Account manager 00 00 French 90 Peter Supervisor 00 00 Spanish 100 What should i write... 8 25.09.2006 07:07:41 Filter by Form Command Button When I filter by form using the tools the filter clears the fields and I can enter what field I want to filter by and it works fine. So I added a command button 'Filter by Form' using the wizard and it doesn't work. The event proceedure on click is: Option Compare Database Private Sub Command150_Click() On Error GoTo Err_Command150_Click DoCmd.GoToRecord , , acNewRec Exit_Comman... 1 25.09.2006 06:44:01 How to update graph every last day in a month! Hi all I have this sheet where I put data on how many units of this and that I make a day. But every last day of the month I need to graph to auto update...how to? This is part of the code: --------------------------------------------------------------------------------------------------------------------- Jan: With Target If .Column <> 1 Then GoTo Jan2 ... 5 25.09.2006 05:19:46 Combo Box font color Hi to all, I have a problem changing font colour in a combo box when Column 1 in the box is not the first field in the query on which the box is bases on. Example: Table: Currencies Fields: Currency_ID (Auto-Key) Currency (text - eg "Australian Dollar") ISO Code (Text - eg "AUD") etc Query: q Currencies List SELECT Currencies.Currency, Currencies.[ISO Code], Currencies.Currenc... 1 25.09.2006 04:55:47 Primary Key in Sub form problem I have a form frmProjects and 4 subforms (these are linked master child by ProjID) When I have popup form to make a new record I need the new ProjId which is 4 letters based on the project (ie:BGSO) to update the other 4 tables a new ID. Format for the subform ID is: BGSO_FI for the frmFinancial BGSO_DE for the frmDecor BGSO_PL for the frmPlans BGSO_PE for the frmPermits I read a po... 1 25.09.2006 03:18:01 Tab Indexes on a Data Entry Form Hi, I have a form that is used mostly for data entry, but also has a few other command buttons on it. I have assigned the tab indexes how I would like it no problems. What I want to do is when I click btnNew_Company (tab index of 10) I would like the form to load a new record (which it does) and position the user in txtCompany_Name which has a tab index of 1. Below is the code attache... 3 25.09.2006 01:56:01 Outlook email from Access I am fairly new to Access & have set up a DB at work to log & track customer enquiries. However, I'd like to automate the sending of emails to staff about the enquiries. So, I have a table containing relevant fields: customer, enquiryID, staff name, email address etc. The emails will all have the same text other than the fields above. Can Access automate the emails so that the ema... 2 25.09.2006 01:32:44 901 Pages: <<  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  31  32  33  >>