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

    The use of "All" in query build

    I have several combo boxes on a form for people to design there on query criteria. In one field, named Program, in the data base they select "All" it the record applies to all programs. No problem with this part. But when they select "All" on the report criteria form the Microsort Visual Basic...
  2. tledwards

    2 Reports on 1 Email message or fix subreport problem

    Is there a method to attach two reports to 1 email. I want to send a report which tasks a person to perform a number of functions. Then attached a second report to the same with my email and other information for him to tell me his plan for performing the actions. I was doing this on one...
  3. tledwards

    Windows XP Home - XP vs bios

    I bought a new computer with Window XP Home on it. I installed a 20 gig hard drive from my old computer which had Windows 2000 installed on it. XP would not read the disk. It Partitioned it as 3 drives. The computers help desk said this is an XP problem. My computer friends at work think its a...
  4. tledwards

    Error Message

    I have an Access database with a problem. The database is on my D:\ but each time I try to open it the following error message appears. Is there any hope? "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same...
  5. tledwards

    Pass through query SQL problem

    I am going to a Oracle database from an Access database and want to append records to a table in the Access database. I need about 40 fields but here is an example of just three. INSERT INTO ADMIN200.SDW_LD_DATA (SDW_LD_DATA.ADMIN_BY_CAO, SDW_LD_DATA.PRIME_CAGE, SDW_LD_DATA.PIIN) VALUES...
  6. tledwards

    Pass Through Query -Missing Expression

    When the following query is run the Ora-00936 Missing expression error message appears. What is missing? INSERT INTO SDW_LD_DATA (ADMIN_BY_CAO, PRIME_CAGE, PIIN) VALUES (SELECT CONTRACTS.ADMIN_BY_CAO, CONTRACTS.PRIME_CAGE, CONTRACTS.PIIN FROM OLAP_OWNER.CONTRACTS WHERE...
  7. tledwards

    Where Clause in Pass Through Query

    This is my first time useing a pass-through query but this problem does not any since to me. I am attaching to an Oracle database. Here a simplified version of my SQL statement. SELECT CONTRACTS.ADMIN_BY_CAO FROM OLAP_OWNER.CONTRACTS WHERE CONTRACTS.ADMIN_BY_CAO = "YL" When I run...

Part and Inventory Search

Back
Top