• WSgellwood

    WSgellwood

    @wsgellwood

    Viewing 15 replies - 46 through 60 (of 215 total)
    Author
    Replies
    • in reply to: Signing a VBA project (Word 2000) #891888

      Hi Stuart – I bought a code signing certificate from Comodo, but I could not make it work (altho I had no problem with Self Certificate) confused . Do you recommend the Thawte certificate?

    • in reply to: Table Design (all) #888581

      Thanks Charlotte. I’m actually working in MSDE instead of Access, but I wanted to post here in the hopes you’d answer.

    • in reply to: Table Design (all) #888582

      Thanks Charlotte. I’m actually working in MSDE instead of Access, but I wanted to post here in the hopes you’d answer.

    • in reply to: Sending data to Access (2003) #885304

      Charlotte:
      What we mean by using XML in SQL server is this: We have an object which has a big ArrayList as one of its params. With SQL Server, we would use a stored procedure and pass it all the object properties as sql params. The ArrayList is converted to XML and also being sent as a string param to the stored procedure. Inside the stored procedure we would convert the XML to a temporary table and update the needed data. The questions are: 1. Can something like that be done with Access? 2. Is it the recommended way in term of preformance?

    • in reply to: Sending data to Access (2003) #885305

      Charlotte:
      What we mean by using XML in SQL server is this: We have an object which has a big ArrayList as one of its params. With SQL Server, we would use a stored procedure and pass it all the object properties as sql params. The ArrayList is converted to XML and also being sent as a string param to the stored procedure. Inside the stored procedure we would convert the XML to a temporary table and update the needed data. The questions are: 1. Can something like that be done with Access? 2. Is it the recommended way in term of preformance?

    • in reply to: Sending data to Access (2003) #884995

      Hi Charlotte,
      We have a schedule screen in the DOT.NET front end which is made up of many small objects. My colleague, who would prefer to be using SQL Server, says that with SQL it would be better to process all the changes in the front end and create a recordset or XML file, then open the database connection, and plop all the changes into the database at once (the chunky approach). The chatty approach would be to loop through all our changes and update the db directly using ADO. I have little experience with SQL Server and can only conceive of using ADO.

    • in reply to: Sending data to Access (2003) #884996

      Hi Charlotte,
      We have a schedule screen in the DOT.NET front end which is made up of many small objects. My colleague, who would prefer to be using SQL Server, says that with SQL it would be better to process all the changes in the front end and create a recordset or XML file, then open the database connection, and plop all the changes into the database at once (the chunky approach). The chatty approach would be to loop through all our changes and update the db directly using ADO. I have little experience with SQL Server and can only conceive of using ADO.

    • in reply to: Upgrading Win for .NET (Win98/Off97SR2) #852467

      I put .NET on then tried to upgrade from Windows XP Home to Windows XP Professional. It was a nightmare – i think i cried a lot crybaby .I would recommend Windows XP Professional or Windows 2003 with Office XP or 2003 and then .NET. Are you going to format your harddrive or try upgrading? I had Office 2003 installed but now I’m back using Office XP because that’s my current customer’s platform.

    • Hans – Thank you! Works like a beauty now. cloud9

    • Hans – Thank you! Works like a beauty now. cloud9

    • in reply to: Outlook COM ADD IN (Office XP VBA6) #850866

      I just bought the book too – they should be paying a royalty to woody

    • in reply to: Outlook COM ADD IN (Office XP VBA6) #850867

      I just bought the book too – they should be paying a royalty to woody

    • in reply to: Intercepting Word Commands? (Word 2K/XP) #850802

      Wow – I downloaded that list of Word commands. Thank you so much Hans – its brilliant! bravo

    • in reply to: Intercepting Word Commands? (Word 2K/XP) #850803

      Wow – I downloaded that list of Word commands. Thank you so much Hans – its brilliant! bravo

    • Thanks Jefferson. Your code is perfect.

    Viewing 15 replies - 46 through 60 (of 215 total)