Search results for query: *

Now that Access 2003 doesn't support tif images, does anyone have any ideas on what to use/do in order to include tif images in an Access 2003 Report? Under 2000 tif images were supported by Office 2000 if you also installed the extra graphics packages, not so for 2003. Any ideas? ActiveX...

Opps you would need something like this at the beginning of the query string: sql = "PARAMETERS sG_Desk Text ( 255 );

Something for long term might be to change it into parameterized query. Instead of: & "WHERE T.DISPLAYNAME like '" & G_Desk & "'" try: & "WHERE T.DISPLAYNAME like [sG_Desk]" To set the parameter [sG_Desk] you might then do: Dim param1 As DAO.Parameter Set param1 = qdfTemp.Parameters!sG_Desk...

Simple and yet frustrating. I've got a form (FORM1) which opens amodal form via a button. User enters some value into the modal form and clicks OK, which calls a sub on FORM1 and changes a label on FORM1. However, this label on FORM1 never changes. I've seen this before, but can't remember how...

I found the same thing. Obviously, the downside of VARCHAR is the limited characters allowed whilst TEXT can hold more. There is 2 solutions I found: 1. Make sure the TEXT column is last on your SELECT statement. 2.OR Change the recordset location from Server side to client side. eg. Set rs =...

It might be this: Microsoft Knowledge Base Article - 318079 http://support.microsoft.com/default.aspx?scid=kb;en-us;318079 "SYMPTOMS When you preview a report that contains a graph object, you may notice that the graph does not match the data that you expect to appear. The graph may also...

More than likely due to connection pooling. Which is why the connection is still visable on the SQL Server.

Does anyone know why if I print a TIFF image in a report, it varies in size depending upon the DPI of the image? eg. 100x100 92DPI tiff is bigger than 100x100 72DPI And yet if you print out the images in say Paintshop, it's the same size?

Has anyone come across this before in Access 2k under Win2k? run-time error '3633' Cannot Load DLL: '?????L?' It was very easy to produce this via a module. Public Sub test() Dim abc As Workspace Set abc = CreateWorkspace("abcdef", "test", "test", 1)...

Strange if i have the following in an xsl file: <xsl:if test= &quot;500 >= @numbID&quot;> ... </xsl:if> it works! BUT reverse it: <xsl:if test= &quot;@numbID <= 500&quot;> ... </xsl:if> the XML transformation fails! Go figure.

Does anyone know how to obtain the printable area of a page via code? I know that you can set the reports margin to be zero, but when you preview or print the report, the printer will set it's minimum values. Peter.

I know from VB (and via the MSDN library) that you can retrieve ADODB.Recordset asynchronously via the properties and using adUseClient and adAsynchFetch. Having done various test .asp files, I can only assume that it's not possible in ASP? Is this right? If so, has anyone come up with a nice...