Recent content by SqueakinSweep

I am not over familiar with VBA, but recently I was tasked with pulling data from our SQL database into an Excel spreadsheet. I managed this fairly easily, but what I really want to do is to execute a SQL stored procedure, and be able to pass parameters into it. Executing the stored proc works...

Ohhh..now that is very interesting if it works. I have worked around the PDF viewer problem simply by shelling to another process of AcroRd32.exe which solves the problem for now. I do however have have another embedded viewer control, which I will try your solution on. So, would I be correct...

I have a VB.Net app which has an embedded COM Adobe Acrobat reader control within it. It works fine on XP, and Win7 32 bit, but falls over with a "Class not registered" error on Win7 x64 Has anyone else encountered this, and knows a workaround?. I was wondering if there was an x64 Adobe Reader...

You dont need the ListSource Table, you already have the data you need in TXMasters ListBox1.DataSource = ds.Tables("TXMasters") ListBox1.ValueMember = "ID" ListBox1.DisplayMember = "Barcode" ListBox1.SelectedIndex = -1 Sweep ...if it works, you know the rest.. Always remember that Google is...

Good idea to eliminate the dynamic SQL. I've been through the same iteration process myself. The way I do it is this. Pass1...create a backend SQL table eg UserFilter, and add in all the ids you require, and commit the SQL transaction. Good idea to also add a user identifier if you have one, so...

Hi All I have a windows form with an Adobe 8.0 browser control on it. (Adobe Acrobat 8.0 Browser Control Type Library). Its simple to use, and you can use the loadfile method to open up your pdf. All I want to do is to rotate the PDF clockwise through 90 degrees automatically, after each PDF...

If you are using try catch, then take a look at what properties are available on the exception (ex) ex.Source, ex.Stacktrace and ex.Message should give you all you need. Sweep ...if it works, you know the rest.. Always remember that Google is your friend

You need a generic error/exception handler. The Try/Catch/Finally block will help you along. Take a look at the link for some basic exception handling www.codeproject.com/KB/dotnet/VB_NET_Error_Handling.aspx Sweep ...if it works, you know the rest.. Always remember that Google is your friend

You can use System.IO.File.CreateText() System.IO.File.OpenText() Sweep ...if it works, you know the rest.. Always remember that Google is your friend

And then you can write a Stored Proc which works off a view! I originally had this scenario in 2000, and I ended up with serious speed issues which I resolved using temporary tables for my "inner select". Not tested the SP based on a view scenario in 2005 however, simply because I avoid using...

Does your friend have the same version of Word as you do? If not, your code wont work unless you adopt late binding. If he has the same version, try making an install set rather than just sending the exe and dll. Sweep ...if it works, you know the rest.. Always remember that Google is your friend

I have encountered this problem too before, but only on SS2000, and I think it had something to do with the fact that VS thinks the SP has to be compiled at run time. By editing it, and basically changing nothing at all, you can resolve the problem. (SS then recompiles the SP). I have yet to...

Pat..no need on VS2005 You just include it in the prerequisites. No more messing with messy merge modules! Sweep ...if it works, you know the rest.. Always remember that Google is your friend

Right click the Setup Project, go into Properties and click on Prerequisites.Set a tick on .Net Framework 2.0 and on Crystal Reports for .Net Framework 2.0. That should be all you need to do. Sweep ...if it works, you know the rest.. Always remember that Google is your friend

I have found that the build sizes are smaller in VS2005. All I can think of is that you have some references which are not needed Sweep ...if it works, you know the rest.. Always remember that Google is your friend