Search results for query: *

Has anyone out there come across any code for connecting to Amazon Web Services using vba in MS Access with the Office Web Services Toolkit 2.0? I figured out how to use the toolkit to autogenerate the classes. I just need to know how to query the web service. How to send an EAN or ISBN and...

Yes, I would like to know that as well.

Supposedly the dual prompt on Open, is an IE bug, but there's got to be a way around it.

It opens in the same window, which is the problem. I did alter my code so that opens it in Excel instead of IE. Weird thing is, if you click open, it prompts you again, so you have to click it twice. Dim fn fn = "ExcelExport.xls" ' Set the content type to Excel...

I ran into the same problem a while back. It's with the way Crystal authenticates with the SQL db. I had to use SQL authentication hardcoded in order for it to work. I used Windows auth on all other forms, but Crystal.

I am using the following code for an onclick event on my web app. ' Set the content type to Excel. Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" ' Turn off the view state...

AllowSorting=True will cause it to fail. It confuses button with clicking column of datagrid. To fix, what I did was create a second grid that is not sortable, and fill it with your dataset and kick it to excel. You won't see the grid, so it will be seamless to the user.

You could also insert the code at the Mouse Move event, and it would react the same as using Controltip under form properties.

I found my resolution. My problem was I was trying to have it autoscroll the main form, when I tabbed in a subform. According to MS KB 106306 this is by design, and can't be fixed. Of course this may be a challenge to all you tek-tips experts out there.

I found my resolution. My problem was I was trying to have it autoscroll the main form, when I tabbed in a subform. According to MS KB 106306 this is by design, and can't be fixed. Of course this may be a challenge to all you tek-tips experts out there.

I have a 21" wide form. I have the tab order set perfectly, however when I tab, it tabs off screen, and I have to scroll back and forth. I have tried setfocus and gotocontrol. It sets the focus on the next control, but doesn't move the screen to the right or left to show the control.

I have a form that is 21" wide. When I tab through the fields it tabs off screen. The user then has to scroll over to the right, and back. Is there a way to have the screen move to follow to where you are tabbing? I have tried both setfocus and gotocontrol. They set the focus but it is still...

Almost there.

I'm almost there. I now have an additional column that is showing checkboxes, and everything in the SOX column that is true is showing a checked box in the noname column. How would I substitute the SOX column with this column and label it SOX. Also, prevent the checkboxes from being changed...

<%@ Page Language=&quot;VB&quot; %> <%@ import Namespace=&quot;System.Data&quot; %> <%@ import Namespace=&quot;System.Data.SqlClient&quot; %> <script runat=&quot;server&quot;> Public strViewString As String Sub SetData 'Connection Setup Dim strConnection As...

Hello, I have an asp.net page that is written in vb.net and html. I use a non-editable data grid to display the results from stored procedures coming from a SQL 2000 box. One of the columns is a bit field that currently shows up on the web page as True or False. How can I have it display as...

I am having the opposite problem. I have display as icon selected, but it only shows the text of the document. I have to go in manually to each record and convert to icon.

It seems like you would need to add the user to AD power user or local power user, or something along those lines. Does anyone out there know? I only have one user that this is happening to, and all users have the same permissions on the SQL box. I even log into her machine and have no problems.

I've been trying to figure this out too. I even gave said user dbo on the database, and she still has dbo appended to all objects in the access data project. None of my other users are having this problem, and they have fewer permissions than her on the SQL server and database. We are using...

That doesn't really solve the problem. The others that use it that don't have (dbo) will not be able to connect.