Threads Replies Last Post 1410 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  >>   Microsoft has encountered an Error - I have a small application database that takes an extract from an AS-400, massages the data slightly, and then generates two reports; one for matched records and one for non-matched records. The queries that run the reports work fine and the correct data is showing. When I try to run the matched report, I get the infamous Microsoft has encountered an Error and must close. I have tried... 3 12/24/2008 3:06:02 PM not recieving emails the email account my mother is using is only set on her pc in windows mail she has'nt read an email for 4 weeks as any sent log on her inbox and delete or disapear within seconds. i want to put her on windows live but can't verify the email it sends to windows mail because it gets deleted. has anyone any ideas? thanks ... 2 12/24/2008 2:04:30 PM Link Tables Hi, Is it possible to ask access to use as heading a differnt row (Eg.: row number 8) instead of the first row when linking a excel table? Thank you very much. Merry Christmas, Vanessa Simmobds... 2 12/24/2008 1:26:36 PM check date hello; i have date field in a form that update a field in temporary table "tmppayment". with update query i update the payment table and delete the data from tmppayment. i want to check in table payment if the pay date is not valid and if the last pay is for instance 1/08 the field in the form will update to 2/08 and the user get a message about that . additional the pay date required ... 1 12/24/2008 9:41:00 AM Difference between two times Hi, I have a table named 'Shifts', having 3 fields n with this data. ShiftID TimeFrom TimeTo 1 11:00:00 AM 06:59:59 PM 2 07:00:00 PM 01:59:59 AM 3 02:00:00 AM 10:59:59 AM And I have another table named "Complaints", having few fields with a field 'ComplaintTime' I created following function to return ShiftID in a query Function Re... 6 12/24/2008 8:48:03 AM Query - Date - Month Plus One? This should be a simple query formulation. The date is 11/15/2008. I need a query expression to simply show the month and year following that date. Examples: 11/15/2008 should show 12/2008 12/12/2008 should show 1/2009. Thanks!... 3 12/24/2008 7:01:00 AM Problem with Access Discussion Groups Web Site? Hi, Since around noon CST, Tuesday, Dec. 23, 2008 I have not been seeing any new posts in any of the microsoft.public.access discussion groups, using Microsoft's discussion groups forum web interface (http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access&cat=en_us_113bf17c-f8e5-4033-8dce-70f82a7b033a&lang=en&cr=us). I have received noti... 2 12/24/2008 5:55:01 AM Yes/No Fields, a Query, and a Macro I am new to using yes/no fields. I have two tables: My ‘goals’ table has these fields: IDKey, Employee, and Goals My ‘Mapping’ table has these fields: ID, Name, RVP, and Changed (this is the yes/no field). I have a query, named ‘LookupChanges’ and the SQL is as such: SELECT Goals.IDKey, Goals.Employee, Sum(Goals.Goals) AS SumOfGoals, Mapping.RVP FROM Goals LEFT JOIN Mapping... 6 12/24/2008 4:17:00 AM Too mnay records? I have created a database by importing an excel spreadsheet. There are 227,000 records of items and which are in one of the tables. This represents 4 years data. There are about a dozen other tables but they are practically empty. The main table with the high number of records has 21 fields. Each field is specific to that item and I am confident that the data base is normalised, I'm not ... 7 12/24/2008 2:17:02 AM FromAndriy hello! ... 2 12/24/2008 12:50:58 AM Relationships in Split database Hello, I know, from previous experience, that when the Relationships between the table's are characterize in the back database, they are outomaticlly get the same characterization when we add them to the Relationships board in the front database. What can be the reasone that it is not happned ? thank you -- תודה רבה... 4 12/23/2008 11:09:12 PM Access 2007 Runtime Followup 1. You don't need A2K7 installed to be able to run an MDB created with A2K3 with the runtime. You just run it. 2. You *do* need A2K7 installed to use the Developer Extensions. I couldn't figure out how the extensions are actually implemented. All I could see was a DLL and tried registering it in A2K3, in the hope that it would run from there, but it didn't. So, I now know that I can ... 5 12/23/2008 9:49:49 PM language message Have a new Sony laptop...set up windows email...was sending messages ok...now I am getting an error that says "the language is no longer available for spell checking..please select another from the spelling options dialog." Where is this dialog? Also, when I go into my computer and check languages, it is on english!!! ... 3 12/23/2008 9:32:10 PM Date Calculation between Min & Max If there is a Date field in a query is it possible to calculate the #of Days between the latest visit date and the one before that for the same client? Client Attendance #of Days #1 10/5/2008 #2 10/7/2008 #1 11/3/2008 28 #2 11/4/2008 ... 2 12/23/2008 9:31:18 PM Error when canceling I am trying to eliminate an error message when a user hits cancel. For example, in one location, the standard warning displays when the code asks for an sql update command. If the user says no to this, the following is displayed: The RunSQL action was cancelled. with End, Debug and Help buttons. How do I eliminate this? Thanks in advance!... 2 12/23/2008 9:23:47 PM copy and paste from datasheet to excel I am trying to copy data from a datasheet from into excel. All seems to go well (no error messages) but when I paste in excel, I am only getting a portion of my data in one particular field. When I try to just isolate that one field and copy/paste it, its the same thing. I've also tried exporting via OutputTo and TransferSpreadsheet macro commands, with the same result. This field is... 5 12/23/2008 8:01:11 PM Access 2007 - New - Macros - Transfer Spreadsheet Action I just got upgraded to Access 2007. I need to create a new macro. The actions dropdown are very different. I don't see any options that will allow me to transfer a spreadsheet (or any other kind of document) into the database. Is there a setting I need to change? Thanks!... 4 12/23/2008 7:47:03 PM Started trial I have just started the 60 day trial for access and cannot open any of the templates or even the blank one what do i do please... 1 12/23/2008 7:42:21 PM finding pop3 server name How do I find server names to properly set up an e-mail account for windows? ... 3 12/23/2008 7:35:12 PM setup configuration process always runs on startup When I start Access 2007, the "configuring MIcrosoft Access 2007" windows always pops up. Is there a fix for this? Thanks.... 4 12/23/2008 7:12:00 PM IS MySQL BETTER? Hi All, A friend insists that if I really want to write database programs that will sell, I should change to MySQL. I do not know anything about MySQL other than that it is a SQL language. What advantages does it have over Access? Will it be easy to use as a back end or will I have to find a front end for it? -- Glint... 9 12/23/2008 6:25:01 PM Making a database that you want to sell a multi language program? Hello I have been working on a database that i am going to try and sell later on but still have a few things to work out like i would really like to be able to make it abel to show different languges for the people who dont read english and also i would like to make a product key for the program also if anyone can help me with that thanks. Stephen... 5 12/23/2008 6:01:00 PM Toggle forms I am trying to track purchasing/receiving information in an Access 2003 database. On my main form I have a field that I want (when checked) to open another form. The new form needs to have a list of receiving numbers and dates that correspond with the purchase order information on the main form. I want to be able to toggle between the two forms and make changes/updates. Any suggesti... 2 12/24/2008 12:47:04 AM Comparing Records in a Table I am attempting to compare records in a table based upon a particular field (employee field) to see if another field is equal (hours). There is another field that will always be different (hours code). In other words, I want to compare records where the employee is the same, with different hours codes, and see if the hours match. Suggestions are appreciated. Thanks.... 7 12/24/2008 2:55:00 AM Table design I need help in designing a back-end that will be used to score a contest my amateur radio club is having. It will be on the web, accessed using ASP. The goal for the members is to contact another ham station in each of 344 countries. Each country is in a zone (40). I have a table with the countries and associated zone, and each country has a unique ID. For each contact for each member I... 17 12/24/2008 10:26:12 AM 1410 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  >>