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  >>   Importing fractions. When I import a fraction it is showing up as an upside down F. I have imported from other users and it works fine. I am now trying to import from a new user and it is showing up like an upside down F. Any suggestions?... 1 28.08.2006 15:33:01 Additional password question when running from cmd line Hi, I have an Access DB which is loading a whole table from a remote Sybase DB. To do that, I've added VBA code that refers to an ODBC souce to connect to the SYBASE DB. That code is mentioning the password that I have to indicate to get access to the Sybase DB. I run the code as a macro. Works fine in interactive mode, and it doesn't ask for anything, it just runs when I double-click... 1 28.08.2006 11:22:01 2 sql server connection database ms access project Hello guys, I have a problem with a ms access. I would like to open 2 databases in the same project. I would be able to do query between this two database and also update the tables. I tried already with the ms access project : So, I connect to one database and linked table to another one, and works file but I cannot updated the database that I linked tables. how can I have two connec... 1 28.08.2006 10:04:15 Linking multiple Exel workbooks We are currently using an excel spreadsheet to keep track of our daily energy sales and purchases. Each day is saved in a separate workbook by the date (i.e. data for Aug24 = 082406, etc) I would like to use Access for the after-the-fact data and analysis. I’ve tried to use “Get External Data” and “link tables”, which works fine for each day, but then I end up with a number... 2 28.08.2006 06:57:32 CSV Import Errors - Unparsable Record Hi, I am trying to import a csv but i am encountering big problems. The text in the file has the following ="account name", the numbers are separated by (") "12312.23312". Halfway through import text wizard the columns are correctly separated with all text having an equal sign (=) at the front. The numbers look fine. If i am to finish with the wizard i am getting import error msgs called... 1 28.08.2006 06:50:01 import text files into access 2003 Hi, i need some help in transferring the data in the Text file to the tables in access 2003. below is a sample of how the text file looks like. DATE :11/08/06 BUYER : M00000 S.X.X ORDER NO. :(Sxxx-SP-000/00) LOCA TERMS/CURRENCY : 15th of next month / S$ or US$ or Yen PAYMENT : 15th of next month PACKING : CARTON CASE... 1 28.08.2006 05:30:01 import text files into access 2003 Hi, i need some help in transferring the data in the Text file to the tables in access 2003. below is a sample of how the text file looks like. DATE :11/08/06 BUYER : M00000 S.A.S ORDER NO. :(SAMS-SP-000/00) LOCA TERMS/CURRENCY : 15th of next month / S$ or US$ or Yen PAYMENT : 15th of next month PACKING : CARTON CASE... 1 28.08.2006 05:21:01 Export PivotChart form to Excel Hello, Is it possible to export PivotChart form to Excel? How can it be done? Thanks!... 1 27.08.2006 13:46:01 Connect to external table with OLE Can Access connect to an external table with an OLE connection vs the typical ODBC connect? My application is attaching FoxPro tables in Access to link them with native Access tables. The problem is that MS has not updated the ODBC driver for FoxPro to work with V9 of VFP. When I try to connect with ODBC, the tables are seen but can't connect. I verified programmatically that it was ... 2 27.08.2006 11:43:25 Importing a mdb file from a website Hi friends, Our supervisor updates the database daily and uploads the mdb file so that we can share the info. This is what we are doing now. He uploads the mdb file with the latest data to his webpage. We have a link to the page in access, (and not to the file because access tries to open the file and cannot, there is no option for saving) and then click on the link to the file, which ... 1 27.08.2006 08:50:02 can i do a mass mailing from access? If I have a table that has all of the e-mail addresses for people who want to be on my mailing list, can I use Access to CALL Outlook to send an e-mail to all those people? Can I export the mailing list to a comma deliniated list so I can just paste that list into my Outlook? I'd really RATHER have Access do it all for me though. ... 2 26.08.2006 11:46:05 How do I export integer data with leading zeros How do I include periods in my file names when using the TansferText macro? My file name that I'm transfering looks something like this TT30UDLK.PERM.FILE13.csv, but when I look on the receving server, the file name appears like this TT30UDLK#PERM#FILES13.csv. The two inner periods are replaced with "#". I can't use a different file name because a process on the receiving server is e... 2 26.08.2006 06:17:45 Excel Export I experience the problem in KB 823222 frequently - the article details an issue when exporting to Excel from Access v2000, 2002 or 2003 that sometimes values such as those in list A are export in the form in list B below. The work-around provided in the article is painful with the volume and frequency I encounter this. Is there a better way around this problem? Will it ever get fixed?? Lis... 3 25.08.2006 19:22:06 Link .jpg or .bmp in table to view pic in a form I have been searching your db to try to find out how I can insert a photo of each employee into our 2003 access db so when you search for an employee, the form comes up with their picture on it. When I did this with OLE and linked it to a file and packaged it for the table, on the form it only shows a thumbnail of the pic and the file name under it. Please help -- Message posted via Acc... 1 25.08.2006 18:14:16 want autonumber start at 1 after deleting all recs in the table I want a table with an autonumber to start at 1 after I delete all the records in the table.e.g I have 10 records in the table and i delete them all. when i go to enter a new record then i want the autonumber to be 1 rather than 11.... 5 25.08.2006 17:22:01 Export Access table without fieldnames How do I go about exporting a table into excel without including the fieldnames in the first row of data?... 4 25.08.2006 16:26:01 Trouble setting up import actions - Help! I posted the question below in the Queries group but have not yet received any feedback. I'm trying to import data from another database via an append query. It seems this is the logical method, but having never done this, I am starting out struggling a bit. Please read my previous post. Feedback is greatly appreciated!! - Previous post - I have never used an append query, but need to... 5 25.08.2006 14:43:23 hai iam currently working in VBA.I have 2 database .Out of which one is front end and the other is back end.I have linked them.I haven locked either the database or the form. When i try to edit the data in a database via form iam neither able to edit it nor add a new one. Any help wud be appreciated. bye nithya ... 1 25.08.2006 13:10:51 Importin Data from Micrsoft Works Our old database was created a long time ago in a galaxy far away in Works. It's very basic but as there are several thousand customer name & address records with a couple of dates and another field I need, which I don't want to have to re-type, how do I import them into my shiny new Access database?... 2 25.08.2006 10:40:02 Change text encoding for reading & printing document When I open an attachment it's unreadable and is set for Japanese. I've tried to reset it to Microsoft default and also to MS DOS but it's not resetting.... 1 25.08.2006 03:12:01 #DELETED on ODBC connection to SQLSeerver2005 I get #DELETED on all Rows in and Columns in an ODBC Connected table in SQLServer2005. I built a Pass-Through Query and can see the Data Just fine. The PK in the table is a BigInt. I'm on a XPPro SP2 Box using the latest Access2003, MDAC 2.8 and JET4 SP8.... 3 24.08.2006 23:16:01 export query and add date to file name? Hi, I would like to attach the date to the file name when i export a query. Is this possible to do in a transfer spreadsheet macro? e.g file is called "mm-dd-yyyy Account qry". Thanks George... 4 24.08.2006 20:43:24 Duplex printing a Word doc from Access Hello, I'm attempting to have a Word document print out duplexed (double-sided) but I'm not having much luck. I have a function that creates a reference to a file using GetObject(fileName) command then uses the .PrintOut command to print the document, but the command does not offer duplexing. I found some code from the MS Knowledge Base - SetPrinterDuplex(Printer.DeviceName, duplexOpt... 1 24.08.2006 18:55:02 Automatic field advance I am attempting to construct an inventory system that captures a string of numbers via a barcode scanner. Within the number string is several pieces of data. I need to separate the number string (i.e. first 4 digits in one field, next 3 in another) automatically so that as the scanner reads the number string it is separated for interpretation. I've seen this type of thing happen when inp... 2 24.08.2006 18:43:20 Export error occurs on two computers We are currently experiencing an issue on only two computers in our office. The users are attempting to execute a query that exports a Microsoft Excel document from Access 2003. When one of the users performs this function they are only able to export 30 days worth of information. The query prompts the user for a beginning ate and end date and then exports the data. However the user ... 3 24.08.2006 15:55:02 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  >>