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!

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

    ComboBox Selection Limits Next ComboBox

    I have a form that has the following: Category SubCategory Dogs Maltese Dogs Golden Retreiver Birds Parakeet Birds Finch I would like to select Dogs from Category and have SubCategory automatically limited by that selection. I have looked through pages of postings...
  2. Elvis72

    Editing Table in Macro

    Hello!~ I am trying to setup a Macro that will create a table header and resize the cells. When I create the macro it will not let me edit the table parameters, I can't change the margins or the cell size? Is this a finite thing or is there a work-a-round? Thanks!~
  3. Elvis72

    Hyperlinked Word Document on CD

    I have a Table of Contents in Word that I have had to create with Hyperlinks to 400 Word Files. The client wants to be able to open the external documents from the TOC on a CD. I found an posting here that gave me this: Option Explicit Dim TrkStatus As Boolean ' Track Changes flag...
  4. Elvis72

    Word - AutoText/Field/Macro for Procedures

    Good Morning!~ I am working on a client driven procedure template. Each action in the procedure has to have a sign-off so the page looks like this: TIME Start Stop Initials _____/_____ ________ 1. Action _____/_____ ________ a. Subaction I have tried this 2 ways: -...
  5. Elvis72

    Add Description to Folder

    I am in the All Documents View and I have a list of folders that hold procedures. The name of the folder has the procedure number, but we need to also add the title for reference. I added the Description column to the view, and I see it...but I cannot for the life of me figure out how to add...
  6. Elvis72

    Copy and Paste Inverting Text Boxes

    I have Drawing 1 which has text boxes on it that I want to copy to Drawing 1A, when I copy and paste it flips all the boxes where the text is upside down. It even does it when I insert the pages into the same document and copy/paste. Any ideas? This will save hours of work for my engineers!~...
  7. Elvis72

    Chart with ComboBox Pop Up Record Selector?`

    I have the following Query: PARAMETERS [Enter Job/Proposal Number] Long; SELECT TblProjectInformation.JobProposalNo, TblConstructionServices.Title, Count(TblProjectInformation.ProjectID) AS CountOfProjectID, TblDate.TheDate, TblProjectInformation.[HR Classification]...
  8. Elvis72

    Date Last Modified

    OK, I have a Main Form with several tabs and subforms. On the Main Form I have a Text box: Text153 which is linked to Date Last Modified in my Resumes Table. Then I have this event on After Update: Private Sub Form_AfterUpdate() Me.Parent.Text153 = Now() End Sub Which was working fine but...
  9. Elvis72

    Excel Spreadsheet Column Heading is Numbers?

    One of the guys I work with has a spreadsheet he has used for forever. All of the sudden the column headings went from A,B,C to 1,2,3? He hasn't done anything different, I have not clue? It has links to different pages in the spreadsheet with formulas but other than that I can't see any issues.
  10. Elvis72

    Multiple Filter Search Form - AND/OR??

    Same Search Form as the previous post but it just hit me that either you have all the criteria given or you have nothing. So how would I change this to an AND/OR Search? Private Sub Command12_Click() Dim strWhere As String Dim lngLen As Long Const conJetDate = "\#mm\/dd\/yyyy\#"...
  11. Elvis72

    Multiple Filter Search Form - Combo Box??

    I have a great multiple filter search form: Private Sub Command12_Click() Dim strWhere As String Dim lngLen As Long Const conJetDate = "\#mm\/dd\/yyyy\#" If Not IsNull(Me.txtfirstname) Then strWhere = strWhere & "([First Name] Like ""*" & Me.txtfirstname & "*"")...
  12. Elvis72

    Count Months in Date Range

    I have a Demobilization and an Mobilization for every Personnel record related to a project. I need to accomplish this: Name Mobilization Demobilization Total Months Jack Sprat 1/1/2008 1/1/2009 12 June Carter 1/1/2008 2/1/2009 1 All I can locate to...
  13. Elvis72

    Saving Adobe PDF back to SharePoint

    Hello!~ I have a user that opens PDF's on the portal and then draws on the PDF. When he goes to save, he hits save...it acts like it does but does not update the portal. When he hits save as it opens to his My Documents. How can he save directly back to the portal?
  14. Elvis72

    Search Form - Export Results to Excel Button

    I have this multiple search criteria form that I need to make the search results exportable by simple users into an excel spreadsheet. The simplest approach in my mind is to add a button...but from reading some of the posts...maybe not? For grins here is the code for the form just in case it...
  15. Elvis72

    Help with Filter Form

    I have this code for one of my text boxes: If Not IsNull(Me.txtfirstname) Then strWhere = strWhere & "([First Name] Like ""*" & Me.txtfirstname & "*"") AND " End IF Now, I need to make one that can handle a range of numbers. I have the following field: Years Experience They...
  16. Elvis72

    Best Way to Search Multiple Criteria

    I have in the past created forms that had 2 search boxes that popped up for searching like this: Enter First Criteria: Refinery Enter Second Criteria: Saudi Arabia At the moment I have a Find as You Type Form that works fine, but I need to be able to narrow results with multiple criteria like...
  17. Elvis72

    Concatenate Single Field

    At the moment I have the following: TblPlantType PlantTypeID PlantType TblPlantTypeList PlantTypeID ProjectTypeID JobProposalNo TblProjectInformation ProjectID TitleID WorkerID JobProposalNo Requisition No Mobilization Date Demobilization Date TblResumes WorkerID First Name Last Name Address...
  18. Elvis72

    Showing Title of Group on Report Export to Excel

    I have a report that has a Title Field on the Page Header which on the Report its fine.... When I click to have it put into Excel the title of the text label shows up but the information the the title field does not. So I have this: =============================================== Project One...
  19. Elvis72

    Conditional Formatting for Null Field

    I need to have the whole record on a report highlighted in Red if the Last Name field is null. I understand the Conditional Formatting tool in reference to dates and numbers, but not text? Any help is GREATLY appreciated!~
  20. Elvis72

    Last Date Modified

    OK, I have searched and searched, while I have found helpful posts I can't find one that hits home with what my end goal is. I have a Main Form, then I have multiple SubForms, I need to have a field on the Main Form that shows the date something on the Main Form or Subforms was last updated. I...

Part and Inventory Search

Back
Top