Threads Replies Last Post 92 Pages: <<  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  41  >>   can not print in tint comes as solid color, why? I have designed a tri-fold page in Publisher where there is shading from dark to light going from bottom to top. But when I go to view it or print it out, it comes out as a solid color, which is the color on the bottom of the page. Please help I don't know how to fix this.... 2 15.06.2006 17:46:26 Copying inport/export specifications Some help for a novice! How do I copy an inport (or export) specification from one Access database to another? Thanks for any help - as ever! Jim Jones Botswana... 2 15.06.2006 17:45:09 Importing tables and linking them I have a table called tbl CATS which I have imported from a spreadsheet I have then used table analyser to split the table inorder to normalise it. The table was originally in the following format below: tbl CATS WBS Code User Id User Name Date A/A Type Hours GB2-L0144.02 205445 John Edwards 03/01/2006 401 1 GB2-L0144.02 205445 John Edwards... 2 15.06.2006 17:43:15 export totals from access to excel without moving columns When exporting a report from Access to Excel the totals are shifted one column to the right. So if you have six colums of numbers, it will export out 12 columns, 6 with data and 6 with totals. How do you have the total export and stay under the column of data?... 1 15.06.2006 17:22:48 Make Directory I export my results like this: DoCmd.OutputTo acOutputQuery, "q_RNtoExcel", acFormatXLS, "C:\PAD\.xls", True But if the user does not have the dir "C:\PAD" as you know it cannot write it out. Is there a way to code a make directory statement, then run the DoCmd.Output...?? thanks ... 2 15.06.2006 14:47:01 XLS export Life would be so good if:: "DoCmd.openform" as you know, will open the form, based on the previous code.. Is there a way to say "DoCmd(output results in xls format)" ????? ... 2 15.06.2006 12:44:02 Update Tables I have a table called tbl CATS which I have imported from a spreadsheet I have then used table analyser to split the table inorder to normalise it. The table was originally in the following format below: tbl CATS WBS Code User Id User Name Date A/A Type Hours GB2-L0144.02 205445 John Edwards 03/01/2006 401 1 GB2-L0144.02 205445 John Edwards... 1 15.06.2006 10:21:57 Can I attach a MSACCESS object (page) to an OUTLOOK email? I am trying to send a MS ACCESS Page via email. Is this possible?... 2 15.06.2006 09:47:31 How can I access a MySQL from Access 2003? I want to build an Access front end for a MySQL database. I have downloaded the MySQL ODBC driver, but I get an error every time I try to link to the db. Any help would be appreciated.... 7 15.06.2006 08:52:01 In Access 2002, how to find the names of recently imported files? I have imported some csv files into some tables in my Access database. I want to find out the names of those files, where can I look? The reason I want to know is that I have similar looking files and am not sure which one I imported into existing tables. For eg: Mar06 and Mar06v2 are both csv files and I just want to know which one I had imported and on what date. Please help me if yuo ... 2 15.06.2006 05:36:10 Exporting to Excel, decimals change I exported some data from an Acces97-query to an Ecel97-sheet. In the excell-sheet the figures are changed. For example, a field that containes 1503.6 (not a calculated field) in Access, now shows in Excell 1503,59997558593. What is the cause of this and, more important, waht is the solution for this problem ? Thanks in advance.... 2 14.06.2006 20:51:44 Linked to ODBC - Primary Key keeps changing I really need help. I'm using a bunch of Access db which all have tables linked through ODBC. When I create the link, I often am prompted to set the Primary Key(s) for that table. Now I'm finding that sometimes when I go back into a linked table the Primary Key has mysteriously changed or is gone. This is creating havoc with my queries. A possible clue: I'm using Access 2003 ... 4 14.06.2006 20:17:04 Linked table troubles i have a database i am trying to use a set of excel spreadsheets in. each sheet is data pertaining to a specific machine we have built. i am trying to use these excel spreadsheets that each part of each machine is built of to combine into my database. each sheet can be imported easily and access doesnt complain about any of it. but when i look at the data in access there are some number... 2 14.06.2006 18:29:02 Importing from Excel I have an access database that holds details on computer equipment I also have an Excel spreadsheet that contains this data but holds full records for all employees. I am looking for a way to bring this data into Access but only bringing in those records that are missing and entering them into the correct areas e.g. Access Database Table Tag Serial No Equipment Assign... 1 14.06.2006 15:01:03 Import from SPreadsheet has strange behavior Hi All, I have written a VBA proc to load data from a xls, but I seem to have a problem. Some (4) of the fields are text fields that contain either TRUE or FALSE. I have the table design set to TEXT for these columns, but the values inserted are -1 and 0. Is there any way to get around Microsoft converting my text values into their numeric equivalent? Thanks in advance, Corey ... 5 14.06.2006 08:51:02 Import a text file to acces using VB Hi, I really need help, i am not familiar with VB. I have a text file with headers, here is an example Header: Agent ID ACD bcd Calls Avg work Hours Avg Calls per Hous Avg after call Misc Avg Time Staff Acd ACW AUx Misc acd misc Columns: John, Smith 236 66 396 7 288 256 05:27 04:33 00:07 00:16 00:32 00:08 10 Karmen, shae Kendra 657 63 386 10 425 145 06:27 02:36 00:09 00:19 00:36 00:0... 2 14.06.2006 05:25:43 Create PDF form and link answers to an Access Database I'm trying to create a survey form. I will use Adobe Acrobate to convert it to a pdf file, which is easier to send, but I want the fields used for the answers to correlate to my database, so that I don't have to re-enter the information.... 2 14.06.2006 05:21:10 Importing/Appending multiple versions of Excel into Access table I searched and could not find a viable solution to my issue: On a daily basis, I can receive a different version of an Excel spreadsheet to be imported into an Access database. Basically, I want to take any version of the spreadsheet, look up a column and then copy the entire column into the master table in my database. I don't want the user to have to select which version of the spreadsh... 4 14.06.2006 05:17:36 What does "No object in this control" mean when importing data? Dear Sir or Madam: I have huge ammout of data (about 250M) in a text file and cannot be open in excel since the maximum row number exceeds excel maximum row number limit. When I tried to import external data(both in .txt and .xls formats) using access, the import wizard said "there is no object in this control." I don't know what's wrong. Please help me out. Thank you very much. I really... 4 14.06.2006 04:50:01 Compare 2 MDB Table Structure Collections I need to compare two MDB files to verify that they each table in each database has the same structure and that the collection of tables is identical. Is there a way to do this programmatically ? Am I missing a tool or function somewhere that can perform this operation ? Thanks in advance ... Elizabeth ... 1 14.06.2006 00:36:48 prevent cell expanding into cell above in XP, when entering data into worksheet cell, that cell is now expanding into cell above thus obscuring any data in that cell ~ solution please.... 2 13.06.2006 18:17:27 Import wizard unable to access information for Excel spreadsheet I can import an Excel 2003 spreadsheet into Access 2003 on my XP machine, yet when I try to import that same Excel spreadsheet into Access 2003 on a Windows 2003 Terminal Server, I get an error message, "The wizard is unable to access information in the file <file>. Please check that the file exists and is in the correct format." From the Terminal Server: I can import other spre... 1 13.06.2006 16:03:02 Importing a text file to Access where the file name changes daily Is it possible to do create a macro within Access to import a text file where the file name changes daily ie there is a dialogue box where the user can select the file required. Any help would be much appreciated? thanks... 5 13.06.2006 15:42:02 Export to another Access DB and delete what was exported? Hi, I need some help on how I can do this. What I need is some VBA code which would help me retrieve all records for yesterday which of course I can query with Date()-1, and then 1) Add these records to a Table1 in another database (Note: Table1 already has records in it) Then 2) Delete those records from the original database. Any help would be appreciated. Cheers Sunny ... 4 13.06.2006 13:41:38 Writing record from Access to multiple excel spreadheets I need to export spreadsheets from Access based on a series of queries. The data looks like this in access: Table in Access UserID Data1 Data2 Data3 first 1 1 1 first 2 3 1 first 2 1 2 second 1 1 1 second 3 4 2 third 2 2 2 etc. … … … And I need a process to write-out 3 result sets to different spreadsheets named for the values in the UserID field. So something like this is... 2 13.06.2006 13:08:02 92 Pages: <<  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  41  >>