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 Chriss Miller 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. work4livinsean

    Set background behind frames

    Hey everyone, I would like to take a picture and set it as the background. The only problem is that I have frames! I would like to set the background in my .html document that contains the frameset. The reason for doing this is that I want picture to be seen in all frames as one continuous...
  2. work4livinsean

    Data Doubling in Query

    Hi everyone, I am having a serious problem and cannot figure out how to fix it. I have a new query that has one query and a table. The query and table are not joined but I need the table there to exclude information from the original query. Here is the SQL Statement: SELECT...
  3. work4livinsean

    Exclude data through a SQL Statment in a Query

    Hey everyone, I am having a problem with a simple SQL Statement. I found something that worked on another thread but when I tried it it did not work. What I am trying to do here is exclude some data from a query by matching up the ApexID's. Here is the SQL Statement: SELECT queSubmit.Name...
  4. work4livinsean

    Split Field into Two Types

    Hi everyone, I am trying to create a query that will split a field into two types. The field has numerous certifications that are being kept (in text format). I would like to name some certifications 'CI' and others 'External'. Since there are many different types of certifications I prefer...
  5. work4livinsean

    Activate PowerPoint Window from Excel using VBA

    Hello everyone, I am having a problem activating a powerpoint window from a VBA in excel. I have a couple pieces of code but nothing happens when I run it. Can someone please help me with this, thanks: Sub ChangeToPower() Dim PPApp As PowerPoint.Application Dim PPPres As...
  6. work4livinsean

    Select a range with the mouse using VBA (Excel)

    Hi, I am trying to write a code that will let the user select a range with the mouse during a macro. I have found a code where the user can select the code before the macro is ran but the user may have to select many different ranges on many different sheets. I have been looking and looking...
  7. work4livinsean

    Error message '1004' Simple code cannot get to work

    Hi, I am a little confused here because my code works the first time the error trap works but the code will not work the second time. I get the error message runtime error 1004. I can type in a number instead of a letter and the error works, but if I do it again it will not work. Basically...
  8. work4livinsean

    Export charts from Excel into PowerPoint

    Hi everyone, I need to export a chart from Excel into PowerPoint on multiple slides. I got this code to work! The problem is that I want it to place the charts on lets say slides 1, 3, and 5. Right now the code places the chart in sequencial order. I was thinking for the if statement to...
  9. work4livinsean

    Need to find a record in a table from a form (Using DLookUp)

    Hi Everyone, I have a pretty extensive database but I need to do something very simple. I have created a form that has a submit button. When the submit button is clicked it takes all the fields (in the form) and puts them into a table (#1). I want to take one of those fields (lets say the...

Part and Inventory Search

Back
Top