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?

Absolutely awesome! You're the greatest! Absolutely awesome! You're the greatest! Now all I have to do is figure it out!

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...

WOOHOO! I got it! sht.Range("PLDMYData").CopyFromRecordset ss Thanks all!

I need to actually do the PULL from the EXCEL side... I can't push from Access to Excel here. I have to pull from the table into a specific range of rows in an Excel sheet. There simply has to be a way to do a dump like: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8...

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?

Please...can anyone help? I can supply more info if need be! Please...can anyone help? I can supply more info if need be! thanks in advance.

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...

By golly, that did it! Thanks a bundle!

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...

well... it's new to me! thanks kkil.

Thanks for the help, mile-o-phile... changed it to 1000000 for millions and it worked great so far! just have to do a little testing to make sure! you guys are great at thinking outside the box!

maybe i'm not referencing the correct dll's, but I don't have a ROUND function in Access97

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...

both ways work like a charm. thanks guys. made my life THAT much easier today.

Close! How would I add the table name along with the connection string so that I know which table is connected via each specific connection string! If you can do that, you're the greatest!