Answer Questions

• easot dim as new object at form level or just dim the variable

  Hi, I have been using the ADO data model in an ADP and have used two approaches (both are working) in terms of where I dim the connection and recordset object and where i actually create an instance of them. Here is an example of both approaches i have used: Option Compare Database Option Explicit Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim rs2 As New ADODB.Recordset Dim intUserid As Integer Private Sub Exit_Click ...Show All

• Siddharth Patil Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vot ...Show All

• Saul Left Joins with Multiple Conditions in VBA

  Hello, I am trying to run a query in Excel VBA. The query has a left join with a two conditions -- every time I run it excel crashes. If I remove the brackets enclosing the two conditions, the query fails. The query itself is correct because if I run it directly in Oracle it works. Also I can run it thru excel via Date->Import External Data but not thru VBA. Also if I restrict myself to one condition instead of two it works thru VBA. Any one ...Show All

• MetroP Microsoft Access Chart Question

  I have a graph that i'm trying to display showing the history of a few fields. There are 2 tables: Person and PersonHistory... For each person there is 1..many records in person history... So the chart would show the trend of these fields in PersonHistory over time (week_ID is one of the records in personhistory...) I am putting the chart on form that will enable the person to select a person from a dropdown containing all of the rows in the pe ...Show All

• Grib Novice Programmer needs help

  I just started using VBA to write macros for my Excel files.  I have created several small subs and now I am looking to consolidate them into one.  Here is the premise of my macro: Asks for an input Begins loop (running subs for each worksheet)    Runs subs a & b (which do not use that specific input)    Runs sub c (which should reference the input above) Ends loop End Currently I have Sub c ...Show All

• Nuno_L pass parameter to stored procedure

  Hello, Can someone please show me an example of how to pass a parameter to a stored procedure I have a crystal report that uses the stored procudure. I can call the report with this: Set s = CreateObject("InternetExplorer.application") s.Visible = True     s.Navigate " h ttp://exch server/scr reports/Se rvice/Main tenance/ma intenanceI nvoice.rpt " ' prompt0=" & JobStatus.Job & "&prompt1=" & CStr(Now) ...Show All

• Tony Long Problem in CDO.iMailBox

  I am working on code sending email in MS-Access using Exchange Server 2000. I grab the code from  http://msdn.microsoft.com/library/default.asp url=/library/en-us/e2k3/e2k3/_cdo_imailbox_interface.asp . Now my problem is casting CDO.Person to CDo.iMailbox     iPer.DataSource.Open "LDAP://" & Info.UserName '==> This line give me iPer obj     Set iMbx = iPer '==>This line is not able to conver ...Show All

• Peter Haik Excel macro question - ref: sheets (hopefully a simple one!)

  Trying to debug a macro in Excel and it has an odd line. Could someone explain it to me please. "Sheets("comparative_report.pl reportNam").Select As you can't have a question mark in the name of a sheet - what's this all about Sorry if I'm being a bit thick but this is new to me. Thanks Damian It doesn't execute ok for me either. I am told that this used to work with Office 2000 ...Show All

• TS1985 Opening a Word file from a macro in Excel

  I have some code that will open a Word document from a macro in Excel, but for some reason it won't recognize the Word file if the folders in the filepath have any spaces in their names. Here is the code: Sub MergeToWord() ActiveWorkbook.Names.Add Name:="MyData", RefersTo:="=Sheet1!" _ & Range(Selection, Selection.End(xlDown)).Address Shell "C:\Program Files\Microsoft office\Office11\winword.exe F: ...Show All

• JoeMiller Hyperlink to a subroutine

  Is it possible to get an hyperlink to run a subroutine I managed to get the hyperlink to go to the subroutine but it doesn't actually run it. thanks for jumping in to answer this question Brice! -brenda (ISV Buddy Team) can you please provide some additional details what program are you trying to do this from (Word, Excel, ) do you have an example of the code that you've tried for the engineer to look a ...Show All

• John Kennedy How to use Direct3D in VBA

  I want use Direct3D in PowerPoint, but I can't found a control like picturebox in VB. The control in VBA don't have 'hwnd', how can I initialize Direct3D. Thank you ! Moved to VBA forum Per our support engineer: Let’s talk about following issue. Our buddy wants to use D3D in VBA. Actually, we can insert an ActiveX control which hosts Direct3D into PPT file. I attached my sample code in the email. P ...Show All

• chrstdvd am i have mak mistake?

  dear all, when i try to run my program which I develop from MS-Access 2003 (.mdb), i received message "Run time error '2455' You entered the expression that has an invalid reference to the property MaxRecords" MsgBox "a " & Me.CurrentRecord a = [Form_Silsilah Form].MaxRecords MsgBox "b " & a I have tried this on MS-Access 2003 Project (.adp), this message never appear please help me ...Show All

• JuanBernabo Avalon Adaptation

  Scenario Lets say that Avalon is released for XP (and in Longhorn) on time, Holiday season 2006, and that it is accepted as “wonderful” like we all know it will be. Question: How rapidly will it make its way onto the corporate desktop What percentage of corporate desktop machine will have Avalon install one year later, two years Are there any moderately reliable figure that we can use in our sales projections Anything will be helpful Tha ...Show All

• auhe Access/VBA add the value to ListBox every column

  Use a list box to display SSN, Hours, FullName, 3 columns get value from a recordset, List0 is ListBox created in Form of Access. use List0.AddItem myRs(0) & " " & myRs(1) & " " & myRs(2), all records are added into one column, i hope myRs(0) into Fullname, myRs(1) into SSN, myRs(2) into Hours seperately. and add SSN, Hours,FullName to the head for every column of listbox. How to implement it I shou ...Show All

• jschell Host Headers

  Hi - I hoping someone can help me out. I've got a MS server 2003 running and I want to set up multiple web sites. Two of the sites are real domains. For the real domain sites, one I have set up as default with no header info and the other site I added my domain name for that site as the header info. All sites are using the same IP address. When I point to the site with a header assigned I get the default site page. When I try and navigate to ano ...Show All