Threads Replies Last Post 92 Pages: <<  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  34  35  36  37  38  >>   Populate To: field in Outlook from Access query. Hi, I have a contacts database built, I filter my contacts through a search feature. At the moment I am exporting their email addresses through a query to a word file, and then copy and paste into the To: field in Outlook Express. This seems an extraordinarily inelegant solution. Would anyone have a handy piece of code to populate Outlooks To: field? Thanks all.. Ps. VB nooooob... :... 3 27.06.2006 20:18:21 How do I get the "get external data" function on my file menu I'm trying to import data from an Excel file to Access. The help instructions discuss using the "get external data" function from the "File" menu in Access but this is not an option I have available. I've downloaded all the updates, etc. but have been able to correct the problem. Any suggestions?... 4 27.06.2006 15:51:55 Sort on nummeric field There is a problem when access have to sort a table wich contains 100.000 or more data fields. How can I fix it..? Ziva Denmark... 2 27.06.2006 14:59:02 can't attach files to e-mails I can't attach any of our files from microsoft, to my e-mails. It keeps saying invalid file, this says it to every file we have.... 1 27.06.2006 10:56:01 Need Vbscript help with parsing a file My boss has asked me to write a vbscript to parse data from a text file, but the fun thing is I have 0 experience with doing anything like this. But here's the situation: I have a batch file that downloads 3 files from an ftp site and then stores the output of the transfer statistics to a textfile. Anothe batchfile uses regular expression to remove extraneous lines so that I now only hav... 4 27.06.2006 04:50:45 export access query to excel report i need tio know if there is any way to do this easier. i have a large list of part numbers and quantity by month that i run a query for in Access to create a cross reference spreadsheet in excel to total by month and by part number. currently with my limited knowlege of Access i have to print the many pages long query and type the data into the spreadsheet. i find it hard to transpo... 2 27.06.2006 00:30:30 Excel Linking - Primary Keys Hi all, I have a Excel spreasheet containing names and adresses (Column1) FirstName (Column2) LastName (Column 3) Address. This list of names and addresses is updated weekly from another external application. The names on the list can be added to and some names can also be used to change the current address. I can link into Access with ease. Any changes in the new weekly updates in ... 1 26.06.2006 22:33:23 Copy Records from one excel spreadsheet to another excel spreadsheet I am trying to create a macro that will append records from one excel spreadsheet to another excel spreadsheet with access 2003. Later I am going to populate some cells with an existing table in my access program, but this is my problem for right now. I want to leave all records in excel because of my conditional formatting and formulas. Is this possible? Any help would be greatly apprici... 2 26.06.2006 20:20:24 Data Export Wizard I have installed all critical windows updates but when I attempt to export to Text file I receive this error...Too Few Parameters Expected 1. I have tried to install Jet 40SP8 but it says my system is already past that version. I have verified the vers of MSJet40.dll as 4.0.8618.0. Anyone know what the problem might be?... 2 26.06.2006 20:15:41 ODBC Link Tables to Two Databases... Okay - so I have two databases with the same file structure. Each of our clients has a seperate DB. (Don't need the bad archetecture lecture, I didn't set it up). One of the tables inside the db is 'tbl.invoices'. Basically, I want to pull the invoice table for each client. To test - I went into Access and set the ODBC connections for three db's for this invoice table (and save connection... 2 26.06.2006 18:11:14 Exporting to Excel In a database with 8000 records, there are 1000 unique values for one field, userid. I want to export, for each userid, a separate table with all field values but don't want to do this manually. Is there a way of doing this? Ken... 9 26.06.2006 16:40:02 How do I ad clip art to picture I would like to add Clip art to a picture before I e-mail the picture. Can you help. Judit... 1 26.06.2006 15:40:02 Import table error decimal field precision too small Hi there, I want to use MyAccess as front end and MySQL as back end. and import tables from MySQL. When I try importing them, the system issues "Error 3761: Decimal field's precision is too small to accept the numeric you attempted to add." I guess this is related to conversion issues of data type, but I don't know where to look for the solutions or walk around. I am using Access 2003, ... 1 26.06.2006 09:43:01 altering and then importing data from excel to access automatically Hi I'm a teacher and have created a reporting database using Access. Uptil now i have been responsible for preparing the data but now need to put it in the hands of someone with less computing experience and so need to make the process as user-friendly as possible. I am given the data as an Excel file. However the structure is wrong and so i have created an VB module to kind of pivot the da... 3 25.06.2006 07:44:43 Link Access to a Web Site Is it possible to link an access database to a web site, so i customer can order an item and it be updated automatically on access database. This is for an A2 level project not a real thing. I would like a website with a tutorial if nyone knows of any. Cheers.... 1 24.06.2006 14:09:01 How can a multiple-tab excel workbook be converted to access? Is there a way to use the power of Access to convert an Excel workbook with 12 spreadsheets? Thanks for help!... 2 23.06.2006 20:36:03 Best way to import 50,000+ records? Hi All, Our office is currently running a dinosaur of a character based ERP. We are, however, able to dump our data into Excel. What we’re looking to do, on a weekly basis, is import the ERP’s Products table into Access from Excel (50,000+ records). Should we import our data into a new table every week, and then run a duplicates query to eliminate the duplicates before appending ... 3 23.06.2006 20:35:02 opening an exported excel file after export Hi, I know how to export files from access but want to give the users the option of going into that file via msg box after the export. Anyone know the command to open a file. Below is what I'm using for txt files (soon to be excel) thanks exportTimeStamp = exDay & exMonth & exYear exportPathName = "Z:\alm\ALM\TWS\TWSCOREFILES\Financing LLC\pipe_exports" exportPathName = e... 4 23.06.2006 20:29:02 Can I export a linked file to a specific excel worksheet? I use access to export linked files from Lotus Notes. I need to be able to export files to excel that are linked back to access, so that I can perform calculations in excel and that drive reports in access. Is there any way to not only export a linked file from access to excel, but to also have several tables appear as different worksheets in the same excel workbook? I know I can hand... 4 23.06.2006 18:21:01 Excel to Access problem Hi all, I have an Excel sheet linked to my Access database. Within the Excel sheet I have the headers and the data below. E. g.: A B C D 1 P1 P2 P3 <= name e.g. Produkt 2 31.01.06 10 24 16 <= data 3 28.02.06 15 87 65 <= data Within Access I would like to separate the name row and the dat... 2 23.06.2006 16:19:32 Same Database, Same Spreadsheet, different results for 02 vs 03 Ok.. I have a database and a spreadsheet on a network drive. The spreadhseet has a series of links, both direct cell references and a coloumn of formula's with links, to a different worksheet. Don't kwo if that makes a difference or not. If I open this database on MY machine, under Access 2002 sp3, and run the Macro which includes a TransferSpreadsheet command, (and not much more), ... 1 23.06.2006 15:54:08 when i copy from a cd,words come opposite i have a cd rom from which i copy words, and paste them into my document, but whenever i try to copy a sentence, and paste into my document, words come the opposite way. example: "The man was strong." when i paste that sentence into my Document, it comes:"strong was man the" can someone there advise me what to do? my os is xp proffesional. ... 2 23.06.2006 14:34:02 Possible Bug on importing - Urgent Help Hi, Thanks in Advanced. Import a spreadsheet through VBA and I do not get the same order in the table. Sometimes (Not all of the time) the first line of data might be line 59 in the table. If i run it again it might come in as line 10 then somestimes line 1 as it is should do. How can i keep parity. I need to import them in the same order I have checked Auto number is off, n... 2 23.06.2006 14:29:01 How do I add an auto primary key to data imported on a regular bas I want a database which I will import data to on weekly or monthly basis and I'm not sure how you handle the primary key if you need one to be system generated by Access automatically on or after import. Thanks for your help! Kristine... 6 23.06.2006 12:29:01 Move from FileMakerPro to Access end in Excel I have a FileMaker Pro 5.0 file that needs to end in an Excel Spreadsheet. To do this wouldn't I first have to move data from the FileMakerPro file to an Access database...then convert it over Excel? ... 6 23.06.2006 02:46:54 92 Pages: <<  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  34  35  36  37  38  >>