Search results

I'm working in Access 97 (though I can use Access2000) and Outlook2000 and am trying to write a process that will go into a specified folder in a user's outlook and pull in the data from the emails there. The data will be in a standard csv format - but my biggest problem is trying to figure out...

I'm looking to purchase/download a listbox type control that will allow the font color/size, background color, etc to be different for each line - not just the entire backround. Anyone have any clues for me?

Ok, here's my dilemma - What I'm trying to do is perform an incremental counter on a table, based on the dates - by month. For example, here is the date data in the table... and my desired "counter" result: date desired result ------ ------------- 1/3/05 1 1/4/05...

I have written a macro in Excel that pulls data in from an Access table - but it's running INDRECIBLY slowly. Could someone please take a look and see if they can help me speed it up? All I am trying to do is pull data from an Access table and insert it on a worksheet. Sub LoadPLDMY() Dim...

I'm looking to output an entire table from one Access 97 database to another. I do not want to copy data from one table in one database to another table in another dbase. I want a table created in the 2nd database with the same name/data of the 1st. Anyone know how to do it?

Hi, I'm trying to create a report in Access 97 that has a number of subtotals, but only for specific data. Other data in the report doesn't need subtotals. I have attached a .txt file (format.txt) that shows the type of layout I'd like. I have also attached the data that I have in the table...

I'm having a bit of trouble opening and closing forms... I have 1 form, called "FORMLIST", that when I click on a button, should open a 2nd form "FORMDETAIL", and close itself ("FORMLIST") so that only "FORMDETAIL" remains. sform$ = FORMDETAIL So the event does: DoCmd.OpenForm sform$...

What I'd like to do is export one MSAccess97 query to one sheet of my Excel97 spreadsheet, and another query to a 2nd page in the spreadsheet. I've tried the TransferSpreadsheet function, but it only allows the user to specify a range for Imports, not exports. I also tried the OutputTo...

I currently create a report in Access97 that gets printed when executed with the following code: DoCmd.OpenReport "Risk Break Report", acNormal, "", "portfolio like 'US8*'" What I'd like the report to do as well, is export to an Excel Spreadsheet (similar to what I can do manually with...

I'm working with queries in Access97, and would like my query to round a number to the nearest million. So, if I have 1,233,555, I'd want it to round down to 1,000,000 And if I have 1,544,121, I'd want it to round up to 2,000,000 Anything under 500,000 would round down to 0. It'd driving me...

I've been given the menial task of determining the UID and PASSWORD used by each of the linked tables within a few dozen Microsoft 97 databases I support. Is there a way, other than opening each table in design mode and looking at the properties, to see the linked table properties? Perhaps a...

I am having trouble importing data into Microsoft Access 97 from a Microsoft Excel 97 spreadsheet. I am getting the Run-time error '3274', "External table isn't in the expected format." DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tablename", "c:\file.xls", True...