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

    Access 2003 form & combo boxes / sync

    Am puzzled. I can't get an errorless sync between combo boxes on the same record. tblManufacturers has a 1-to-M relationship with tblModels. say, ABC Manufacturing has 3 models: red, blue, and green XYZ Manufacturing has 3 models: XYZ1, XYZ2, XYZ3 DD Manufacturing has 3 models: DD1...
  2. swtrader

    check box grouping

    I do little in Acrobat. I am mostly irritated by companies forwarding a non-fillable pdf to me for completion. SO, I convert it to a fillable form and send them a blank fillable and 'suggest' they use it in the future. Anyway, I have a fillable form I created from the Acrobat X wizard...
  3. swtrader

    Excel VBA variable print range

    I have a range of data from A1 thru H731. Rows (except for R1) in Column A are labels. Columns in Row 1 are day-by-day dates. Say A2 is 7/1/2012, A3 is 7/2/2012, etc. -- out 2 years. At various times a user may want to print only 9/1/2012 thru 11/30/2012 or 8/1/2013 thru...
  4. swtrader

    Use variables with CopyObject

    If I hardcode the table names, the code runs. However, I need to use varibles for table names. What is the proper syntax to be able to use variables? Thank you. Private Sub Command18_Click() Dim tblFileName_BU2 As String 'old table Dim tblFileName_BU3 As String 'new table newtable =...
  5. swtrader

    file listing

    I am using Allen Browne's code to get file names. http://allenbrowne.com/ser-59alt.html / Thanks, Allen I would appreciate help in editing it so that the full path is in one field. Also, although I can probably figure it out eventually, it would be good if someone can write the code that will...
  6. swtrader

    file name to hyperlink field

    Am putting together a document management db. Briefly, certain info is selected from combo boxes on form (from table: FileNames) and a concatenated string is created getting something similar to this: ABC.SignedLease.DSmith.20110901.FileNo1 which will be saved as a pdf file, OR...
  7. swtrader

    Excel 2007 VBA HPageBreak

    1921 static rows. Print area BD1:BQ1921 Autofilter is used on Column BD to hide unpopulated rows. In this example, BD1:BQ625 are populated and BD963:BQ1121 are populated. When printed, the report breaks at row 1024. I have tried various syntax to try to force a break at row 963 including the...
  8. swtrader

    vcard creation

    I am not the resident tech person in our little company. However, I built and maintain the Access database that we use. So -- I know a bit. BUT, I know nothing about HTML or ASP. Short question: I am trying to create a vcard that we can attach to our Outlook outgoing emails. I have used the...
  9. swtrader

    copy range from one workbook to another

    I've copied and made a couple of clunky modifications to internet-sourced code to accomplish: 1. Opening each Excel Workbook in the Tracking Reports folder. 2. Getting a customer number and storing it in schrange (the customer number appears only in Cell E7. 3. Getting a 20 row by 2 column...
  10. swtrader

    Excel VBA - Using variable for wksht name

    Dim S As String S = ActiveSheet.Name -- other code, going to different worksheet -- 'trying to return to S Sheets(S).Select -- doesn't work What does work? Thanks.
  11. swtrader

    Excel break text string into 3 rows in same (merged) cell

    I have a report that has five columns. 4 of the columns contain minimal info (like a dollar amount). 1 of the columns, however, contains: CompanyName, IndName, IndTelcoNo. I want this to 'split' and be centered on 3 different text rows within the cell....such as ABC Co. John Alexander...
  12. swtrader

    combobox message

    On a sub-sub form, I have a combobox. Double-click opens modal pop-up form listing all items that combobox lists. The pop-up form has an extra field, Archive?, for each record. The user can then select a record to archive -- thus 'hiding' it from view in the combobox. Once the modal form is...
  13. swtrader

    many to many with a 'set'

    Given: tblVols pkVolID VolFirstName VolLastName fkShiftGroupID etc. tblShifts pkShiftID ShiftName ShiftStartTime ShiftEndTime etc. tblShiftGroups pkShiftGroupID ShiftGroupName (ShiftGroupName = "MainGroup" will have all 10 shifts - (A thru J)) (A Vol might be able to...
  14. swtrader

    List All Open Files - of any type

    I am working on an Access application that will assist (require?) compliance with a file naming convention. What I would like to be able to do is show the user a list box of all files he has open -- whether they be pdf, xls, doc, etc. User would be able to select a file and certain portions of...
  15. swtrader

    Outlook macro fails...

    I copied the following code from vbaexpress.com over a year ago. (Modified it slightly to fit my needs.) It's worked perfectly for over a year. It now fails on the line: Set mlItm = itm Possible reason(s)? Thank you. =========================================================== 'Created by...
  16. swtrader

    Access VBA to Copy File (rather than move it)

    The following code is copied from the web and attributed to: FMS Development Team -- and it works great for what I am trying to accomplish...using Access to rename and move files...with one exception... It deletes the 'old' file once it has renamed and moved it. I need to leave the old file in...
  17. swtrader

    INDIRECT syntax to get value from same cell, different wksht

    A11 = "ProjectedCash" (the name of a different worksheet than the active one - which is CashFlow) CashFlow is the name of the worksheet where the following is in cell F17. This formula correctly pulls the value of F17 from ProjectedCash wksht. =INDIRECT(""&$A$11&"!"&"F17") However, I can't...
  18. swtrader

    Excel formula from text

    I will have 1 spreadsheet for actual cash and 1 for projected cash for each month going forward. (The actual will pull data from a list of actual cash transactions through "yesterday"; data will be pulled from the projection spreadsheet (into the actual cash spreadsheet) for "today" and all...
  19. swtrader

    Don't get the Do Loop syntax or something

    Here's a portion of my code that I need to loop. Whether I put the "Loop" before or after the "End If", I get the error, "Loop without Do". Do While rTC > 1 If InStr(StringToSearch, SearchTerm) > 0 Then 'put the Code in the cell to the left of the transaction detail MsgBox...
  20. swtrader

    extract filename text from hyperlink

    I am using Access as a Document Manager -- saving most (but not ALL) documents in one folder. I drag the document into a hyperlink text field on a form. I would like to extract the name of the file to an adjacent unbound field. Given these possibilities...

Part and Inventory Search

Back
Top