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

    Controlling the InputBox?

    Dear All, Does anyone know how I can control the use of an InputBox when using VBA? For example, if the end-user enters data into the InputBox and hits the "OK" button, then I want to then call a particular sub-procedure (eg. continue with the application). If the end-user however...
  2. danharman

    MS SQL syntax into Oracle??

    Dear All, Can anyone assist with writing the below query in syntax that Oracle will understand? I am having trouble with the cross join syntax.... Please excuse my ignorance, I am new to SQL! ** THANKS TO bperry FOR THE SOURCE SQL** Select f2.flightno, COUNT(f2.flightno) as NumCities From...
  3. danharman

    Converting MS SQL Server syntax so Oracle SQL can Understand

    Hi All, Can anyone assist with the following MS SQL Server qeury that I need to run on Oracle? I am having trouble converting the syntax for cross join..... Any help would be appreciated. Djh Select f2.flightno, COUNT(f2.flightno) as NumCities From FLIGHT f2 cross join ( Select...
  4. danharman

    SQL - Queries on sub-queries.

    Hi, Hopefully someone can assist.........I need to query a sub-query, based on the outer query criteria matching ALL of the attributes obtained from the inner query. For example, I have two relations A and B. My inner query creates a new relation with 3 attributes from relation A. I then want...
  5. danharman

    MS Access – Investigating / Understanding Relationships

    Forum Users: Any advise on the best approach to investigate a large Access database, with the ultimate goal to gain an understanding of the data stored, the tables created and the relationships that they hold, and ultimately where (ie. the tables etc.) certain reported figures are sourced? I...
  6. danharman

    Importing Word Data into Excel, Manipulating and then back into Word

    As mentioned above, I am attempting to automate the process of copying a particular portion of data from a MS Word document, paste it into MS Excel, manipulate this data, and then create a new MS Word document and paste back into word. So far I have managed to create an object in MS Excel (via...
  7. danharman

    MS Excel - As an accurate timing device?

    Is it possible to use MS Excel as a timing and recording device (by way of some VBA procedure)? If so, does anyone know the accuracy of the times that could be recorded (i.e. to 1000ths of a second?). Any help would be appreciated. Cheers, Dan.

Part and Inventory Search

Back
Top