Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. trScott

    Web Services Variant Return Type

    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...
  2. trScott

    Web Services Variant Return Type

    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?
  3. trScott

    Web Service returning a File

    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!
  4. trScott

    Access 2003 Lifecycle support

    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!
  5. trScott

    PDF fillable form

    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...
  6. trScott

    PDF fillable form

    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!
  7. trScott

    Report with a memory Leak

    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...
  8. trScott

    Arial Font displayed differently on machines

    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...
  9. trScott

    Arial Font displayed differently on machines

    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...
  10. trScott

    Reports NOT visible in design mode

    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!
  11. trScott

    Reports NOT visible in design mode

    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!
  12. trScott

    Access 2003 conversion - query criteria using function

    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...
  13. trScott

    Access 2003 conversion - database slow opening

    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...
  14. trScott

    Access 2003 conversion - database slow opening

    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...
  15. trScott

    Combo Box Control Source - Combination Primary Key

    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...
  16. trScott

    Can I able to change button icon image

    Were you able to determine a solution? I need the exact same functionality.
  17. trScott

    JSObject and a signature

    Help!! I'm pretty clueless on adobe javascript. I'm using it to retrieve a JSObject (using Microsoft Access as my tool to edit/create). I can use the JSObject to set String values without problem, but now I need to use it (or some other method) to insert an electronic signature (jpg or tiff)...
  18. trScott

    Print on existing PDF document.

    I'm just looking for someone to point me in the right direction regarding the printing of PDF documents through Access. Web site, examples, etc... I'm not trying to generate a PDF file from my Access report, but rather using Access as an intermediary to populate the form values (?) in an...
  19. trScott

    German numeric format

    I need to format a value in the German format - switch the commas for periods and vice versa. 3,455.00 should be 3.445,00 Thanks for any help!
  20. trScott

    Reset row numbering on each page?

    I have a very simple report. It is just a large number of consecutive rows listing a persons name and one identification number we use internally. I'm numbering each row consecutively (running sum), but I need to reset the running sum back to 0 on each page (results in a series of pages with...

Part and Inventory Search

Back
Top