Threads Replies Last Post 901 Pages: <<  11  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  >>   how to add multiple colums in a querie? I have tried to add multiple colums in a but when i set the expression, it just adds the numbers in each colum. Example: Colum a (2) + Colum b (4). instead of it add 2+4 which = 6 it shows it as 24. What am i doing wrong?... 4 21.09.2006 18:57:01 How do I insert multiple columns in a table? I need to insert mulitple columns into a table that I created with a make table query. Rather than opening the table in the design view and adding the columns there, I was wondering is there a macro or a module that will do this for me? Thank you.... 5 21.09.2006 18:56:55 How do I change the path name of a linked access table? I have a database that I transfered it from one computer and now I need to change the path name of the linked access tables. I don't know how to change this.... 3 21.09.2006 18:52:38 Export to Excel - Losing Data Hello, I have a quick question. I have a table with three memo columns. In these columns, people can enter in the database as much as they want to. When trying to export to excel, I can only grab up to 255 characters on these memo columns. Is there any way that when I export to excel, I can keep all the data without cutting some of it off? Thanks.... 4 21.09.2006 18:43:45 Please help! Hi... I'm new to MS Access and need some advice. We are a small business and currently have a database of all our clients. We mostly do correspondence using Word, of which I have merged with the database. We tend to use approximately 100 standard letters that need tweeking in order to apply to the individual client. So for instance, I'll pull up the client from the database and the l... 2 21.09.2006 18:43:02 One user gets "not a valid path"... Hi I have an Access app in production, which is uaed by about 10 different people. Now a newcomer tried to use the app (which is stored on a shared drive), but when the first form, triggered by a simple button click, does a DoCmd to open the next form, she gets a "not a valid path" error !? She is the only one having that problem, and I have no idea what it can be due to. All users a... 7 21.09.2006 18:31:03 Formating individual words in a label frame? Can it be done, and if so, how? Thank you.... 3 21.09.2006 18:29:02 Automatically Send Email from Access in the next version? I’ve been reading some of the older threads about sending Outlook email from Access and it’s obvious this is very confusing to most people, including me. I use a database program called "Alpha Five" that allows you to send email from the database without writing a single line of code. It’s very easy and even incorporates the ability to send HTML messages without any programming. I... 16 21.09.2006 18:10:35 HELP, HELP, HELP!!! I have a SQL database backend with an Access database frontend. I have a table in Access that is a linked table from SQL. I have a webform via FrontPage. Users are suppose to input information into this webform and press send/submit button. When they do that, the information is suppose to go into the Access database and send a person an email letting them know that someone has just subm... 9 21.09.2006 18:01:02 Need To Delete a set of Personal Folders I'm running Windows XP-Home and Office 2003. In Outlook I have three sets of Personal Folders that are identical. How do I get rid of two sets? Right clicking doesn't give me an option to delete the folders. I've been looking in Local settings/Application Data/Microsoft/Outlook and see the following: extend.dat, outcmd.dat, outlook.NK2, outlook.pst, outlook.srs, outlook.xml, and outlook... 2 21.09.2006 17:52:02 print off a web page When print off a web page the right protion of the page does not print. How can I print the full page?... 2 21.09.2006 17:35:52 Hyperlinks in Excel Is it possible to assign a hyperlink to just a single portion of a cell versus the whole cell ? Example text in a cell: This is a test of the broadcast system. I want 1 hyperlink under the word test (http://test.com) and another under system (http://system.com). ... 2 21.09.2006 17:34:22 conversion of pictures from word perfect are distorted Has anyone tried to convert Word Perfect text and found the embedded pictures distorted?... 1 21.09.2006 17:06:01 Rank & Group Tournament I have a large list of people that have ranks and are grouped by location. From this information, I need to make a tournament schedule. Each player needs to compete against another player from a different location and play a different rank. For example, I would like a #1 seeded rank to play a #2 seeded rank and a #3 seeded rank, etc. Any thoughts where to start? I am baffled. Thank... 7 21.09.2006 17:00:02 Table Purge Hello, I would like to know if anyone knows of a great utility that can be used to purge tables of duplicate data? This function also needs to be highly configurable to allow me to set the fields used for determining this etc. If there is no tool, does anyone have a code example that does this for a Access 97 database? Thank you, Tracy... 6 21.09.2006 16:33:06 ACCESS²éѯÖеÄÁ÷Ë®×ܼÆÎÊÌ⣿ ACCESS²éѯÖеÄÁ÷Ë®×ܼÆÎÊÌ⣿ ÔÚ²éѯÖÐÏë×öµ½ÈçÏÂЧ¹û£º ÁÐ1 ÁÐ2 1 1 2 3 3 6 4 10 ÎÒÓÃDSUM("ÁÐ1","±íÃû","")£¬µ«µÃµ½ÊÇ£º ÁÐ1 ÁÐ2 1 10 2 10 3 10 4 10 ÎÒ²ÂÏëÊǵÚÈý¸ö²ÎÊýÓÐÎÊÌ⣬²»Öªµ½¸ÃÔõôÉèÖÃΪͳ¼Æµ±Ç°ÐÐ ÒÔÇ°ËùÓеļǼºÍ¡£»òÕßÓÐÆäËûµÄ·½·¨ÊµÏÖ£¿ Ïò¸ßÊÖÇë½Ì£¬Íò·Ö¸Ðл£¡(SORRY My Englishi is pool ) ... 2 21.09.2006 16:26:41 My Last Post about List box solution didn't work..Try to exp bette Try to post the question more efficient this time. I have a listbox on a form that has for example the following dates: Jan 1 jan 3 jan 5 jan 7 When I select one of these days for example Jan 3. another listbox opens and lists all appointments for that day. Question: If today was january ,6 (I have no Jan 6 in the above example) I want to be able to open the form and set the fo... 5 21.09.2006 15:43:02 MASTER Adds Subform ID 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 ... 1 21.09.2006 15:41:02 Citrix Access DB Cursor Flutters for up to 30 seconds We have a strange problem throughout our organization. We are running Citrix Presentation Server 4 (farm) with Access 97 installed, ($) preventing us from upgrading. Almost all our Access DBs experience 10-30 second cursor delays (fluttering) when our users click on form fields. every other (and random) field is click on this happens. It is driving us nuts. It does not show up using RDP ... 1 21.09.2006 15:38:45 Access Databases & websites I've just recently gotten into website design. I've got a website useing .asp pages, and currently one page is pulling in information from a database to display on the page. However I run into a problem where, if I have Access open, to say add more data to a table, or add new tables/forms/etc. then the page won't load saying that the file is already in use. Anyone know how to fix this?... 1 21.09.2006 15:16:02 Unbound Cascading Combo Boxes Hi. How do I go about coding 2 unbound combo boxes with the 2nd items being based on the first selection? I have a cboInstrument and a cboSpecificInstrument - cboSpecificInstrument should be based on the selection from cboInstrument? Thanks, Cathy ... 4 21.09.2006 15:02:07 Lose ability to add records after refreshing linked tables I am building a database in access that has the backend on a Sql 2000 server. Whenever I refresh the tables in Access I lose the ability to add a record to any table. I have to delete the link and manually reconnect using my ODBC DSN. Once I recreate the link I can add records to the tables. I have never seen this before. Any suggestions on how I can stop this? Thank you!... 3 21.09.2006 14:59:02 BCC Field filled in on every e-mail Besides typingi it in everytime, and Besides creating a form, is there a way that my user can have her name in the BCC field on every message she sends out?... 2 21.09.2006 14:58:44 VBA code to add n-records to a subform, Help! Hi all, Im creating an accounting application to keep track of payments deadlines. In particular, I need to add a specific number of records to a subform on the basis on the value of a combo box in the main form. As in my form I select "30/60 days" from the combo "payment", I need a bottom-click procedure that will go look in the table "payments" the value "30/60 days" from "pmt_description"... 1 21.09.2006 14:38:43 Need to create HTML files from Forms I just upgraded from 97 to 2003. In 97 I could export 6 forms at once as an html page and the wizard would create an index page for them. I seem to be able to export only 1 page at a time with 2003, and obviously no index. Is there a trick to do this?... 1 21.09.2006 14:33:03 901 Pages: <<  11  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  >>