Search results

I've transfered the XL macro code to the Access sub that runs the transfer spreadsheet: Dim stDocName As String Dim objXLApp As Object Set objXLApp = CreateObject("Excel.Application") Dim objXLBook As Excel.Workbook Set objXLApp = New Excel.Application Set...

The XL file is saved with a name that includes the date. The spreadsheet is passed around and updated by several people and then ultimately printed as a report. I need the report to include a printed cell with the original date of export. I created an XL macro to copy the date cell and paste...

I'm exporting an Access query to an excel template using the TransferSpreadsheet method. I want to capture the date/time of the export and keep it static. I currently have a cell with Now() in it, but everytime I open the workbook the date gets updated. How can I correct this? Any help is...

cross5900, I appreciate your suggestion, it worked after I added a line to Set the xlObj. The working code is: Private Sub cmdOpenExcel_Click() FollowHyperlink "C:\ExcelReport.xls" Dim xlObj As New Excel.Application Set xlObj = GetObject(, "Excel.Application")...

I have the following code behind a button to open a saved spreadsheet: Private Sub cmdOpenExcel_Click() FollowHyperlink "C:\ExcelReport.xls" End Sub Excel opens and is maximized, but the spreadsheet is not maximized. How can I maximize the spreadsheet when it opens? Thanks, Sup

I've resolved the problem by changing the template and switching from outputto method to transferspreadsheet method. Thanks, Sup

Hi All, I have created and saved an excel template "Report1.xlt" with a Header and a Footer. I want to export a query to excel using this template. I am exporting the query using the following code: Dim stQryName As String Dim stTemplate As String stQryName = "qryReport" stTemplate =...

Jaeden, I use the following two subs to establish a DSN-less connection to a foxpro table: Sub FoxProLink(dbase_path As String, Optional oconn As Connection, Optional rst As Recordset, Optional file_name As String) 'connect to a foxpro table based on the dbase_path information Dim file_path...

I've played around with the code , including your suggestions, and I've got it working! Thank you very much for your help! Sup

I'm trying to build a string for a report that contains a summary of a combination of service description and teeth for a group of records. ie) Record , Service , Tooth Record1 , Examine , 1 Record2 , Examine , 2 Record3 , Examine , 3 Record4 , Fix , 4 Record5 , Fix , 5 Record6...

Jason, That is exactly what I'm trying to do! I'm trying to calculate a rental fee based on a monthly rate. The rental period may be any fraction of a month or months. An item's rent may begin on any day of a month and end on any day of a month. When I replied: "Your DateFraction function...

Sleepyjay, Thank you very much! Your DateFraction function comes as close as possible to what I'm trying to do. Thanks, Sup

I need to (accurately) calculate a rental period to fractions of a month. ie) 1/1/2006 to 2/14/2006 would equal 1.5 months. DateDiff("m",[Start],[End]) returns whole months. DateDiff("d",[Start],[End])/30 is very close , but not precise. Is there a way to accurately calculate fractions of a...

I'm trying to make a DSN-less connection to an Omnis ODBC database. I've tried to alter a working Foxpro connection by changing the driver from {Microsoft Visual FoxPro Driver} to {Omnis},and the source type=DF1 which is the file extension that Omnis uses. I'm trying the following code behind a...

I figured out the type conversion problem and got it working. Thanks very much for your help!!! Sup

Thanks for the quick reply!!! DateSerial(Year([dtDate]),Month([dtDate]),Day([dtDate])) + TimeSerial(Hour([dtTime]),Minute([dtTime]),Second([dtTime])) returns exactly what I want. At least it looks exactly like I want? But when I try to update my date/time field using it, I get a type...

I'm working with a linked table that has a seperate field for the date, and a seperate field for the time (which show in the linked table as '11/30/1899 9:46:00 AM'). I need to calculate the time difference between 2 entries. How can I merge the 2 fields into a combined date/time field for my...

I've now tested the code on a different workstation using Access/Outlook 2003 and it works! There must be something specific to his installation that is causing the problem. Where can I look? How can I isolate the problem? Can someone point me in the direction of a different email w/attachments...

still need Outlook automation help? All of the research that I've done indicates that a reference to the Microsoft outlook 9.0 library should work in Access 2003 (with outlook 11.0). Also, the code works fine in Access XP (with outlook 10.0), so I don't think the wrong reference is my problem...

The following code works perfectly in A2k, but gives a -2147024770 error in A2k3 on my client's workstation: Sub CreateMailItem(strRecip As String, strHome As String, strAttach1 As String, Optional strAttach2 As String, Optional strAttach3 As String) 'make a reference to Microsoft outlook 9.0...