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 derfloh 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: dpimental
  • Content: Threads
  • Order by date
  1. dpimental

    Read PLT (Plot) files

    Does any one know how to read plt (plot) files. I have a project I'm working on that requires that I read the properties of a plt file from timestone. Anyone ever done that before? These files are template files that have product codes embedded in them that I need to read. David Pimental (US, Oh)
  2. dpimental

    manage thread to update UI Control

    All, I'm working on an asp.net app. I have (C#) pdf page validator that evaluates the number of pages in a pdf file and compares it to the number entered on a form (the form will create an xml file used to configure an order). My problem is that the process to run the validator against a large...
  3. dpimental

    Open Save File Dialog Error - ThreadStateException

    When I try to run an OpenFileDialog or a SaveFileDialog from my asp.net web page I get an exception that says ... Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. This exception...
  4. dpimental

    Save Object As Text

    All, you know the method Application.SaveAsText - it allows you to save an object as text. Does anyone know a way to save the text of the object to the database as a field value in a table. I want to covert a number of objects as text and then save them to memo fields, so that I can convert...
  5. dpimental

    command or action isn't available now

    All, I am running the following code DoCmd.RunCommand acCmdRefresh And getting the error "action or command not available now" run-time error 2046. And the intelisense isn't working (such as Me.) Any ideas? David Pimental (US, Oh)
  6. dpimental

    conditional object libary reference

    All, I have a set of databases on a network that several users access. Some access them from their local machine and some on a remote server. The problem is the remote server has ms office 2010 and the local machines have ms office 2007. I need to reference the Microsoft Access Object Library...
  7. dpimental

    problem with multiple criteria - not all variables bound

    I have a gridview that I'm populating. I'm connecting to oracle and when I use one select parameter, Name, it works fine. When I add another one, it gives me the error, ORA-01008: not all variables bound . Anybody see this error before in this context? David Pimental (US, Oh)
  8. dpimental

    archiving data from one schema to another

    All, I am using Oracle 11g and Toad and I am planning a migration of data from one schema to another. The data is order data that is old and we want to archive the data to another schema. Copying the data is easy enough. But, planning the removal of the data from the current production schema...
  9. dpimental

    word objects in a multi version environment

    All, I am using some code to automate merging word documents. But, I have to refernce the correct ms word version. But the users have different versions of owrd (2007, 2010). How do I avoid the errors I would get, if I set the version to 14 and a user only has 12. Is there a way to create a...
  10. dpimental

    64 bit windows query on linked tables problem

    All, I have a 64 bit version of windows 7 running access 2010. I am trying trying to run an update query, whose tables are a combination of linked oracle tables and linked access tables. The data is order related data. If I run the query and filter to a specific order, it runs fine. If I try...
  11. dpimental

    class module to recordset

    Are there any quick and dirty ways to transfer data from a recordset to a class and back to a recordset again. Example: I have an "orders" recordset. I have an orders class I want to be able to pass data back and forth between the class and the recordset. Is there any easy way to do this...
  12. dpimental

    ODBC to Oracle - Record Locking Issue

    All, I have ms access 2007 and I have a number of user databases connected to back-end access tables and some Oracle tables by odbc. We are using the 10.02.00.01 version of the Oracle Driver. We are in Windows 7. Here's the issue we experience. We run an update query in Access, which uses both...
  13. dpimental

    Strange Cursor Behavior While In Module

    All, while I am in a module, if I set the cursor point at the beginning of a line and high-light a single word and move my mouse down (without clicking) it high-lights the lines below as if I am clicking and dragging? Has anyone seen this before? I am using windows 7 and Access 2007 David...
  14. dpimental

    Form_Current Error Number 0

    All, I need to have 3 combo boxes to requery based on the value of another combo box on each current record. When I use the Form_Current procedure and call a public function to requery the combo boxes, I get an error with an error number of 0, but not error description. I am using the...
  15. dpimental

    crosstab like query - flip table on its side

    All, I have a table that lists orders and which stage of production processing they have gone through and a create date for each record, like so order # stage create date 1234 StartProofing 3/29/2011 1235 StartProofing 3/29/2011 1234...
  16. dpimental

    keep users from opening tables directly

    all, I have an access 2007 db front end which I distribute copies to users. I want the users to be able to have access to the navigation pane; but not to open the tables directly. I don't just want to hide the tables, unless there was a way for them not to be able to unhide them. Any ideas or...
  17. dpimental

    improving speed of queries of linked tables

    I have a number of databases that have back-end table to both access and oracle. The oracle tables seem very slow, especially in larger queries. I am using the 10g driver for oracle. Does anyone have any ideas about speeding up the connection or other ways of increasing the performance of the...
  18. dpimental

    dissappearing memo data - from linked table

    All, I have a form based on a query from combined linked access tables and linked oracle tables. From time to time, we have data in a memo field that disappears. Technically, it's just a text box, since the field is in a linked oracle table and there is no such thing as a "memo" field in...
  19. dpimental

    Oracle Linked Tables are slow

    I have a number of oracle linked tables and they are so slow. Is there a way to speed them up. I know pass-through queries are fast; but I need to update the data. My office has office 2007 and the database version are 2003. Any ideas, Anyone? David Pimental (US, Oh)
  20. dpimental

    dbAttachedODBC Settings / Options

    All, I have some vba code that "refreshes" or "updates" the odbc links on some linked oracle tables. When I moved from office 2003 to office 2007, I starting getting errors when updating from access fields to oracle fields in linked tables. So I ran an update that reset the connection string...

Part and Inventory Search

Back
Top