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!

  • Congratulations bkrike 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: *

  • Users: trScott
  • Content: Threads
  • Order by date
  1. 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?
  2. 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!
  3. 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!
  4. 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!
  5. 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...
  6. 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...
  7. 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!
  8. 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...
  9. 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...
  10. 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...
  11. 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)...
  12. 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...
  13. 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!
  14. 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...
  15. trScott

    Backup software selection

    I'm selecting a backup software program and am looking for some recommendations. I am the lone IT person and any help based on experience will help. We just installed a PowerVault 114T and will be using Ultrium 2 LTO 200/400G data cartridges. Our backup requirements are not very complex. The...
  16. trScott

    Creating a global rule

    I'm filling in for the sick network guy (I'm a developer) and I need to create a rule. Basically, if anyone in the company receives an email from company XYZ (it could be Bob@xyz.com or Al@xyz.com), a copy of the email is forwarded to an XYZ folder. I'm sure it is easy, but am not sure how to...
  17. trScott

    Forward a copy of a user's received emails

    Please forgive me, I'm really just a user of outlook (developer), but our network guy is out and the owner has tasked me with the following: The owner's son has an email account on our exchange server (and receives his emails at home). The owner wants to receive a copy of every email his son...
  18. trScott

    Image is increasing size by 10M

    I am creating a tax input form and rather than recreate the form by hand, I'm simply taking a PDF document(from the IRS); using adobe's PDF professional's snapshot tool to select a page and save an image onto Window's clipboard; then pasting the image onto an Access form. The form looks great...
  19. trScott

    PDF as background Image

    I'm trying to take a PDF image and put it onto an Access report. The PDF document is a tax document and I need an almost identical copy (document is scanned in by gov.). The page is actually a sub-report of a much larger report with many other custom designed sub-reports. Any ideas?

Part and Inventory Search

Back
Top