Recent content by trScott

Our web service is not returning a variant - that is how access interprets a complex type. Below is a snippet of the web service call from access (using a Microsoft tool to generate): 'Proxy function ' '"wsm_ValidateAllTansferForPartnership" is an array with elements defined as...

We are calling a web service and the web service returns an array of strings (in a Variant data type). We cannot determine how to convert the variant into a usable data type. Has anybody done anything similar?

My Access 2003 app is calling a Web Service that returns a byte array. The byte array is actually a PDF file (believe Access wants to store it as a variant). Does anyone have an idea how I can retrieve the document and display it for my end user? Thanks!

In doing some long term forecasting, I'm trying to determine when support for Access 2003 shall end. Does anybody know where I can find such information (or some sort of estimated date)? I have the same question for SQL Server 2000? Thanks for any help!

I found a way to render the form fields inactive (if using Adobe objects): Dim gAVdoc As Acrobat.CAcroAVDoc, pdDoc As Acrobat.CAcroPDDoc, gApp As Acrobat.CAcroApp Dim formApp As AFORMAUTLib.AFormApp, formField As AFORMAUTLib.field, formfields As AFORMAUTLib.Fields Public Function...

Using a PDF fillable form, I've filled in all the values from my Access 2003 application and saved the document. I now need to make the fillable fields no longer editable (flattening perhaps)? Does anyone have an idea how to accomplish this via Access? Thanks!

I have a very large report (really a main report with about 30 subreports (and some of those have subreports)) - it is a tax return. I am dynamically setting the recordsources of almost all of the subreports using multiple "Me.RecordSource = xxxx" - per example: If (abc for is loaded) then...

Thanks for the info. I did some looking around and the text showed up properly on two machines and incorrectly on three others. I found one common denominator - the created date in the properties of the font. The working machines had an August date while the non-working had a July date. It...

In one of my reports, I used an Arial Font and typed in a size 7 (not in the selection box for font size). The font displays fine on my computer, but is cut off on most everyone else's computer. If is my guess that size 7 Arial is not really a valid font and each individual computer is...

Thanks for the help. Michael Kaplan's solution looks like it will be perfect. As it turns out, the reports were there, but they were about a pixel wide and I couldn't see them (let alone grab). Not very user friendly, but was able to finally resolve. Thanks!

I converted a 97 application to Access 2003. In design mode, I can no longer see subreports or subforms anywhere in my program. Is there some Access 2003 settings I must change? Thanks for any help!

I recently converted my Access 97 database to Access 2003 and ran across the following problem: In a reports recourse source, I was using a function in the recordsource as a criteria value. The function simply returns a constant from within my program. Per example: SELECT * FROM ABC WHERE...

Thanks for the tip - I will uncheck autocorrect features; however, I discovered the problem. My antivirus software (Free AVG) was the culprit. Didn't think it would as both the 97 and 2003 versions have the same extension, but apparently it was doing some internal scans and slowing the startup...

I just converted a large Access 97 database to an Access 2003 database. When using Access 97, the startup form would show up almost instantly. With 2003, it is taking 20 seconds before I see the startup form. I cannot figure out if it some setting on my computer OS (XP) or a database...

I'm trying to use a combo box to select values for a record in a table. In addition to the primary key value and other arbitrary information, three of the required values are a Foreign Key to another table (say field A,B, and C). In the foreign table, A,B and C is the primary key value...