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 IamaSherpa 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. MaltaC

    You cannot use Peachtree right now because the serial number(s).....

    We have Peachtree Premium 2007 with multi-user license (5). It is hosted on a peer-to peer network and we can successfully connect from another PC. When I try to access the networked company from a third PC I get the following error message: "You cannot use Peachtree right now because the...
  2. MaltaC

    Problem with Tab Contol and Command Button colors in access forms

    I am using Access 2003. When I create a new form and place a Tab Contol or Command Button on the form the color of the color of the Tab Contol or Command Button is WHITE rather than the usual GRAY. This happens whether the database was created in Access 2000 or Access 2003. When I place a new...
  3. MaltaC

    The Microsoft Jet database engine cannot find the input table

    I receive the following error message when my code attempts to import a comma-quote delimited file: "The Microsoft Jet database engine cannot find the input table or query 'Daily_Price_Pre_Import'. Make sure that it exists and that its name is spelled correctly." Also, the file is not...
  4. MaltaC

    Create Table with a multiple column primary key

    The solution from PHV is below: PHV (MIS) TableStr = "IF NOT EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES " & _ "WHERE TABLE_NAME = 'Daily_Price_ImportT') " & _ "Create Table Daily_Price_ImportT ( " & _ "TerminalNo Int NOT NULL, " & _...
  5. MaltaC

    Create Table with a multiple column primary key

    Thnak you for reviewing my problem. PHV supplied me with the needed information.
  6. MaltaC

    Create Table with a multiple column primary key

    PHV, It worked. Thank you very much for your help. Gerry
  7. MaltaC

    Create Table with a multiple column primary key

    WELL THANK YOU. YOUR RESPONSE IS EXTREMELY USEFUL!!!!!!!!!!!!!!!
  8. MaltaC

    Create Table with a multiple column primary key

    I am trying to create a table with a multiple column primary key. When I run the code below I receive the follwoing error message: "Cannot add multiple PRIMARY KEY constraints to table 'Daily_Price_ImportT'" What is the correct coding to create a table with a multiple column primary key...
  9. MaltaC

    Create Table with a multiple column primary key

    I am trying to create a table with a multiple column primary key. When I run the code below I receive the follwoing error message: "Cannot add multiple PRIMARY KEY constraints to table 'Daily_Price_ImportT'" What is the correct coding to create a table with a multiple column primary key...
  10. MaltaC

    Set column "Identity" property with VBA

    I am appending a new table in an Access Project. I am trying to set the "Identity" property (autoincrement) of the first column in the table. I receive the following error message: "run time error 3265, Item cannot be found in the collection corresponding to the requested name or ordinal...
  11. MaltaC

    Set column "Identity" property. Append a new table in an Access Projec

    I am appending a new table in an Access Project. I am trying to set the "Identity" property (autoincrement) of the first column in the table. I receive the following error message: "run time error 3265, Item cannot be found in the collection corresponding to the requested name or ordinal...
  12. MaltaC

    Create and Send emails from Access using an SMTP server

    Ignore my last post regarding "set a reference to CDO". Regarding FancyPrairie's solution which is working. How can I save the email so that it may be resent at a future time if need be? Thanks
  13. MaltaC

    Create and Send emails from Access using an SMTP server

    How do I "set a reference to CDO" ?
  14. MaltaC

    Create and Send emails from Access using an SMTP server

    Is there a way to do it without using Exchange Server or Outlook?
  15. MaltaC

    Create and Send emails from Access using an SMTP server

    I need to Create and send multiple emails with attachements (Excel and PDF), to different recipients from Microsoft Access thru an SMTP server. Is there anyway to code this in Access VBA? Thanks

Part and Inventory Search

Back
Top