Threads Replies Last Post 92 Pages: <<  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  41  42  43  44  >>   Problem with export into Excel I have a database which is quite simple and stores information about customers. When I export it to Excel, one record always gets messed up. The fax number is only entered once in my access database, but in excel it appears four times all the sudden. How can I prevent that mistake? I already checked the database entries several times, as well as I checked the Excel spreadsheet, and I have to... 1 01.06.2006 20:45:06 how can i export one report in mulitple excel sheets Hi I have date range report in Access, i want to download each date output in a separate spreadsheet. Currently i am download date by date in excel sheet. If we have any option or macro , program which wil download by multiple date range report in separate spreadsheet Is their any option for the same Your help is will be appreciated.... 1 05.06.2006 08:12:02 Error 3265 When linking table with all permissions revoked My application is workgroup secured and I'm using RWOP queries on back-end tables where all permissions have been revoked. I have a routine that runs at startup to link all tables. It basically follows the following topic in Access Securitiy FAQ 14.3 No Permissions necessary - Using the .Connect property to relink tables So for well over a year now the routine has run flawlessly. I rece... 2 04.06.2006 23:32:40 copy excelcells into access memofield Hi When I copy cells from an excelsheet into a textbox after pasting, the cells are separeated by black verticalblocks in the textbox. To get rid of them I delete those colons manually and put some empty spaces between the data. I tried also with search and replace but that doesnt work 160¦packages¦320¦kgs¦ 160 packages 320 kgs Is there an easier way to handle this? ... 3 04.06.2006 16:47:38 Exporting to Excel with conditional formatting I have a query that I built a macro for that exports data to an excel spreadsheet. My problem is that I have a conditional format in the spreadsheet that highlights the background on certain cells. The problem is when I update the spreadsheet from the query I lose the conditional formatting formula. Is there a way that I can export the data to the spreadsheet and still keep the conditio... 3 03.06.2006 16:27:29 disk How do I append data from a table found in a floppy disk to another database table. The source table(the one in the floppy) called batch.dbf contains new record which need to be appended to another table called tblbatch(path=c:\mydocument\batch.dbf). Right now I use an append query, but both tables reside in the same database. I am not sure how to do for the above said situation Che... 7 03.06.2006 04:07:02 Export to Excel highlights dates period Hi, I have a database of events. Each event has the fields Code, Name, Description, Start Date and Finish Date. I want to export the filtered records of a month period to an Excel list that has, Code to Column 1, Name to Column 2, Description to Column 3, 1St day of month Column 4,…..,31st day of month Column 35th The Code, Name and Description should be placed under the relevant ... 2 02.06.2006 20:48:23 Import Access report into a Word document, not as rtf I would like to export an Access 2003 report, with all its grouping formats, into a word file as a table but not as a rich text file, rtf. The source of the report is a query. I am able to import this query into Word "table format" but without the grouping format, the result is a Word table with lots of duplicate data in one of the fields. Can I create a query that will only display d... 2 02.06.2006 18:55:04 Exporting to text file In 97, we used to export a table to a fixed width text file (using a saved spec). The file was always the same name with the extension ".ser" rather than one of the conventional text file name extensions. This worked fine. Now we are running the database in 2003 (still in 97 format), we keep getting the error message that the database is read-only. Fair enough, I know we can't change... 2 02.06.2006 09:50:01 refreshing imported data I am creating an application that imports an excel spreadsheet into a database during the setup process. The spreadsheet has hyperlinks to documents and other information and will be what is going to be maintained. If any changes occur the person does not have to go into the database but will make the modifications in the spreadsheet. Is there a code that can refresh the database to show any... 4 01.06.2006 20:57:01 Problem updating linked SQL table from mdb, addnew is OK I have an application that was migrated from an Access database to SQL. Still using the mdb as a front end. Problem is that I can add new rows to a table, but can't modify them later. This is true using either a form or opening the table directly. Problem is just with this 1 table. This is new behavior, I can't figure out what has changed. -- Thanks, MB ... 8 01.06.2006 19:23:08 ** Urgent Help ***Exporting one table to Multiple Excel Spread She All, I have a table that has Multiple account types, I need to export these into seperate excel spread sheets to send the different departments. I tried using Marcos and placing a condition but that does not seem to work (and I dont understand Macros very well either). I have a plethora of data and to export it to one spread sheet and cut and paste will take me a month of sunday's. ... 2 01.06.2006 19:20:46 Importing Problem with Phone Numbers Hi, I have an excel file with phone numbers. Some are international. It is a text filed in Excel. Whenever I import them into Access, access changes them into an exponential number. When I reimport them back into excel from access it stays as an exponential number which is a problem. Is there a way to avoid this and keep the field as is? Thanks, -- Chuck W -- Chuck W... 3 01.06.2006 19:07:12 Exporting a record to text file Hi, I have a continuous form with records from a single table. I would like to add a command button that would export the selected record to a text file. Can someone help me with the code to do this or direct me to a place where I can find what I need? Thanks, -- Phil... 2 01.06.2006 18:51:33 opening outlook's emails attachments from Access Hi Thanks to this group I know how to link Access to my Inbox:) But I wonder if it is possible to access atachments as well? I can see only field indicating if there is att. or not. Is it possible to open attachments directly from Access? Or how to open specified email in Outlook, to allow user access this attachment? Thanks!... 2 01.06.2006 18:45:14 Importing from several files daily what's the best way Our business has an inventory management set up in access but we have run into a problem with multiple warehouses and keeping up with the info. On a daily basis we receive a .tab file and several .csv files. I am looking for the best way in access to keep our inventory management accurate. Our information thus far has not been hard to handle but any more will bury us. Please advi... 2 01.06.2006 18:38:02 Automate .txt File import and assign Import ID field with filename I am in the processes of creating an Access database that will import Text file data into a cumulating table; however, to uniquely identify which records came from which file, I created a field titled 'Import ID' in the cumulative table were I would like the file name where the records came from to be populated in this field (with or without the '.txt' file extension--this part doesn't m... 2 01.06.2006 17:30:03 Files List I need the ability to search a directory and list al or some files. Then I need to list them on a form to be used for bit comparison. I could not figure out how to access a directory and list the files in question. I am using MS ACCESS 2000 / 03. Please respond. -- David Curtis GM DBA... 4 01.06.2006 13:54:02 How do I automatically import multiple Excel spreadsheets? I have a folder into which I am placing multiple excel spreadsheets of daily usage data (all spreadsheets have the same format). The number of spreadsheets would typically be 7 (ie, one week), but may vary. What I'm interested in doing is automating an import macro or similar that essentially will import data from the first listed spreadsheet into a form, and then append every subsequent ... 2 01.06.2006 12:58:01 Time Format in Excel I have a query that pulls the information below. I export it to excel to create a graph, but the time fields are giving me problems. The duration colum in access is formated at SHORT TIME. If it isn't, I get a decimal number that doesn't make sense (see below). The other times are irrelevent to the graph. I only care about the Room and duration. When imported into excel, I want to S... 8 31.05.2006 20:34:19 Can you import a chart from excel to access and how? I need to import charts form excel to access but can't find info on how to do it. Can anyone help.... 1 31.05.2006 18:19:03 macro/code needed to export multiple tables to .txt files Several times a month, I export the same 3 tables each to a fixed-width text file. I maintain the same file name (as table object) and then append the current date at the end of the name. These files are then appended together in a text app for upload to another system (I can't do this in Access as the table structures vary widely.) How can I automate the export of these files using the... 3 31.05.2006 17:24:03 code to link with a text file Good morning, I need to write code to link to a txt file one fixed width and one with "|" delimiter. The 'Get External Data' on the Access I have does not line up well thus the result contains a lot of unwanted/missing data. Thanks. cg... 4 31.05.2006 17:23:45 URGENT How use a weighing machine Hello, Please need to link my Access DB to a weighing machine. How can I do that? I need the weigh automaticaly pass from the machine a form in my database. The machine is linked in com1. Thanks ... 4 31.05.2006 17:05:01 Query by record number in access? How do you query by record number? For example, I would like to see records 300-1500 in a separate table. ... 3 31.05.2006 14:02:01 92 Pages: <<  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  41  42  43  44  >>