Thanks Doug, I will give this a try, and let you know the result. I dont suppose you can help me with the Excel Save as command. I want to 'Save As' the spreadsheet to the value of the variable "Scheme". I tried ExcelSheet.SaveAs Filename:=Scheme But it didnt work Thanks again Kevin "Douglas J. Steele" wrote: Try replacing ExcelSheet.Application.Sheets("sheet1"
Hi, I am tking values from a report and putting them into a spreadsheet, and I am slowly but surely getting there, but have a problem with the below code, It updates the spreadsheet Linktest.xls, but when I run another report and try again, it places the values in the wrong cells. If I first open the spreadsheet and save it with cell 1,1 selected, it then works fine. Can someone please
Jajajaja Buena Yuri Precisamente estoy Peleando con el Err 94 Invalid Use Of Null ya que efectivamente el recordset aveces no trae datos. -- ----------------------------- Sin mas, saluda atte. a Uds. Armin Saez PD: Los tildes se han suprimido intencionalmente. "Yuri Aponte" <yuri(-PUNTO-)aponte(-ARROBA-)apocal(-PUNTO-)com(-PUNTO-)pe> escribió en el mensaje news:u$6VwQ4jIHA
On Sun, 23 Mar 2008 18:19:00 -0700, Bob Barnes <BobBarnes@discussions.microsoft.com> wrote: John - I used a DateValue of a Date/time Field stored as "General Date"...based on a Card Swipe... R = "SELECT * FROM Swipes;" Set RT = Z.OpenRecordset(R, dbOpenDynaset) With RT .AddNew: !MemSwipe = Finder: !AWhen = Now() Now() does not add the date. It adds the date AND TIME, accurate
Try grst instead of grst.Name Private Sub Report_Open(Cancel As Integer) Me.RecordSource = grst Jeanette Cunningham "Siew-Ming" <SiewMing@discussions.microsoft.com> wrote in message news:45A00C25-716E-4CBF-A6B6-9E53F784B35A@microsoft.com... Hi, I've stumbled on this for quite awhile. It'll be fantastic if someone can help me on this. Created a 3 column combo box
