Search results for query: *

Are you attached to a view (query if your in Access) or a table? If your view is not updatable, your dataadapter won't be either.

This will maintain your Apostrophe properly without 30 lines of code. str = Replace(str, "'", chr(34)) or str = Replace(str, "'", "''")

We have an ODBC connection to a SQL Server database which we have built an Access Query on. We do this in several spots without a problem. The problem is one Query we run will run the first time we open the program, the second time we open the query an error with a problem with Heterogenous...

Hi We export to pdf all the time for display, people are used to viewing pdf. This is the additional lines you should use. Although the loop is not always required, it will not always load large reports properly if you don't use it. Do While cryTwo.IsLoaded = False Loop...

I also have the same code and it doesn't seem to run either. It doesn't get past the load

Zombie you missed a couple of steps, I have figured it out and had what you wrote when I posted this as well. What also has to be done is every cell and row id has to be set in the server table control as well. This is what I was missing. As soon as I add that it worked fine. What you wrote...

I build a table on the fly using a table control. On the table control I add a textbox, 2 labels and a dropdownlist. When the selected item in the dropdownlist is changed I need to read that event. The problem being is because the dropdown box was built dynamically there is no known name for...

I use setupsite.com, they also use SQL Server or Access. Very good service, very cheap. I have about 30 clients that I have moved over to there system now.

Hi I want to set a random picture into a word template, I can get the picture into the template but it doesn't set where I want it to. It causes the rest of the template to move down the page and picture and doesn't set where I need it to set. here is the code we have...

Hi Like snowboardr said you can use the replace statement, but you don't need to use chr function. You can use the replace statement like this strText = replace(strText,"'", "''") this same code is common practice in VB with ADO connections.