Threads Replies Last Post 92 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  >>   Export Access report to a folder Hi all I have a problem exporting MS access report to a folder on my system. I have a monthly report in MS Access and I have about 50 users that send this report every month. I want to write a VBA code that will export this report with the IDs of the 50 users in my database and i want the exported report to be stored in a folder in my harddrive. I have a Macro which I have converted into... 1 04.08.2006 17:47:34 Getting external data from ODBC error 3423 With Access 2003, I am trying to import data from Simply Accounting. When I try to open the data source under Machine Data Source, I get the following Error: You cannot use ODBC to import from, export to, or link an external Microsfot Jet or ISAM database table to your database (Error 3423) Simply Accounting uses ODBC. What am I doing wrong and wow do I get around this problem? ... 1 04.08.2006 16:31:03 Scrambled data using Winsocket Control in my Access Form I tried using the windows winsocket control on my Access form and place the recieved data in a text box. I got it to work but the data is coming accross like ÿþ%ÿý and I cant use that information. Is there a way to descramble this. I'm thinking it might have to do with using some sort of emulation that can read the info. We have software right now that connects to our server with VT101 e... 2 04.08.2006 14:57:31 Excel Connection Hi, I've only recently discovered linking Excel to Access, so my problem is fairly basic: I want to import data to Excel from a query in Access. The Access query requires you to select a customer first. Do I have to run the query in Access first, or is it possible to select the customer via Excel? Thanks! -- Message posted via http://www.accessmonster.com ... 3 04.08.2006 14:43:02 Import from Filemaker Pro Can anyone point me to some information (links, etc.) on how to import data from a Filemaker Pro database to Access. thanks Brian... 2 04.08.2006 05:05:13 Search Key not found in any record Every month for the last 6 months I import a text file into access with no problems. Suddenly this month when I tried to import the most recent data I get the message "The search key was not found in any record." Why have I never seen this message before and is there a way to get around it? Thanks for any help in advance.... 1 03.08.2006 18:33:02 Linking Tables from Outlook - nothing shows up I have tried to link Outlook tables (I understand Outlook doesn't really use "tables") but when I open the table created in Access there is no info populated. I use a custom form so not sure if that stores info in another Outlook Address book or not (b/c I need to specify which address book at times). Thanks, Mark... 1 03.08.2006 14:31:01 Default Field Types/Lengths in Export Query I have some calculated fields in a query. When I Export the Query to dBase, those calculated fields (even math calculations the have a numeric result) all default to a length 255 text field in the dBase file. How can I control what the field type and length will be in the target dBase file? ... 1 03.08.2006 02:02:02 Why don't I have the export option to save as snp file in Access 2 I am running WinXP and Office Professional SP3 and I don't have an option under export to save as file type .snp. I have tried to add/remove in Office all of the features that seem relevant but to no avail. What I read is that it automatically installs with Access 2000 and later; so I don't understand why I can't make a .snp file. Please help.... 5 02.08.2006 22:00:10 Importing signed mainframe fields Does anyone know a way to import signed dollar fields into and Access table? Examples: 0000700E 0004251C 0000625E 0006290{... 3 02.08.2006 20:52:47 Importing Text and Dates Together I am currently working on an access database and importing data from excel into an access table. In some of the columns, there are dates and access recognizes them as dates too, but some of the data has written in "N/A," which access cannot recognize and identifies them as errors. thus, they are not included within these columns. Is there any way to fix this problem without changing the dates... 2 02.08.2006 15:13:01 path name contains blanks I am trying to import a .TXT file where the directory path of this file contains embedded blanks in the name e.g. //Mainfolder/My subfolder I have tried following syntaxes: //mainfolder/my subfolder/myfile.txt "//mainfolder/my subfolder/myfile.txt" '//mainfolder/my subfolder/myfile.txt' \\mainfolder\my subfolder\myfile.txt "\\mainfolder\my subfolder\myfile.txt" '\\mainfolder\my ... 2 02.08.2006 09:26:55 Migration Questiion to SQL Anyone know how and where I can find the basics of what I need to be infomred about onhow to migrate Access 2002 to SQL? ... 2 02.08.2006 02:08:56 Inporting data to specific record I have a database of students with unique ID numbers. When they complete an assignment, their results are caluclated in an Excel Spreadsheet. I want to import the scores to matching fields in my database. so I want to do an export or import (whichever is easiest), match to the unique ID and then fill in the fields. It's not an update query, because I'm not replacing data and it's not... 3 01.08.2006 20:31:02 Import a route into Streets & Trips through MS Access Code Can anyone help me find a way to import a route into Streets & Trips, set up the route planner to show the route in the order that the import tells it to, and then display the map? I am writting a dispatch database that I need to be able to import into Streets & Trips in the order that the client selects and then display that order on Streets & Trips. I have a sql that will give me the ... 2 01.08.2006 18:53:08 Exporting to Excel to specific name range I have existing Excel workbook with numerous worksheets that are linked to Charts. I need to be able to update the worksheets data from Access 2003 to using two different datasources. 1st datasource is based on ALL and must reflect the summarized version of the data and 2nd is based on selected criteria. Is it possible to use the same wkshts with different datasources without affect... 5 01.08.2006 17:48:02 Strange problem with Transferdatabase method Hi, I am having a real problem with access and I think it might have something to do with the A2003 versions. Basically I am doing a transferdatabase method from a third party provider called Macrobase. the code below is simply: DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=ANIS-M;AS=0;PTH=x:\skid841\pth\magfakt.pth;ASNAME=;ASGROUP=default;ASADDRESS=localhost;ASPORT=5580;;... 1 01.08.2006 12:04:17 Exporting rich text I tried the following on the Office 2007 beta (july) this week: Copied some richtext from a Word document. Pasted it into an richtext field in an Access 2007 table. Created a simple report with that field (looks great in Preview mode!) Exported that Access report to a new Word 2007 document. The text completely fell apart! It works much better in a PDF export, but we really need to be a... 3 01.08.2006 00:56:40 different results w/transferspreadsheet 2002sp2 and 2003 OK, Same database, same spreadsheet, running on two different XP pro machines, accessed from a network drive. I have a macro that includes a transferspreadsheet command. The spreadsheet is in excel 2000 format. I am doing an import, with field names, with the range a1:n2001 The transferspreadsheet ommand, in Access 2002 sp2, I get a dialog box saying that fields in two records were delet... 6 31.07.2006 23:01:58 Able to import but not link tables Hi there, I need to create a linked db to edit some backend data held on a sql server. I can import data via 'Get external data' but am unable to actually do a link. I get two main errors: Connection failed: SQLState:'01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState:'08001' SQL Server Error:17 [M... 3 31.07.2006 21:11:01 Retrieving accidentally deleted field (lots of records) I'm working on sprucing up this database, and everything has been going well until I accedentally deleted the wrong field. I didn't think it would be a big deal- I could just use an append query from my backup. But things have not proven to be so simple... When I attempted to run the query, I got an error message saying that there was "Not Enough Temporary Disk Space" to complete. I ... 5 31.07.2006 20:31:52 Type conversion failure I have a brand new - blank - db table to which I am trying to import an excel file. Most of the data are numeric, but I have the field type set to text because a select few do have a single letter after their 4 digit number. It is these 8 alpha-numeric rows that is giving me the type conversion failure. I cannot understand why. This particular column is my primary key data - but I do... 3 31.07.2006 19:53:01 Convert Existing Full Name Data > Seperate First & Last Name Field Is this possible, have a list of records where their full name is in one field, covert all those records so their name is split up into two fields, first & last name? Thanks Curtis ... 4 31.07.2006 19:36:02 Run-time error '3011' Hi Guys, Anyone Help with this error please. I am running some code that imports spread sheet data and keep getting this error: Run-time error '3011': The microsoft Jet database engine couldnot find the object 'C:\database\Appointment_456_fred Bloggs.xls', Make sure the object exists and that you spell its name and path correctly. When I go to Debu the error were it stalls it shows... 2 30.07.2006 15:52:30 how to; transfer a data base from excel to access office 2003 stu I recorded an assignment in Excel and I should have done it in Access. Does anyone out there know how to transfer the whole thing to Access. I have till the end of the day to accomplish this or my grade will bejepordized tremendously. PPlease HHelp! ricki racer... 2 30.07.2006 15:25:22 92 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  >>