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 derfloh 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. swtrader

    Access 2003 form & combo boxes / sync

    You've both given me some direction. I've slept a couple of years since I built a database with continuous subforms -- so thanks for reminding me about the limitation on CF's combos. I've read online that a - perhaps not the only nor the best -- solution is to lay a textbox on top of the combo...
  2. 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...
  3. swtrader

    check box grouping

    Sort of answer my own question. Under Edit, right click a checkbox. Radio Button Properties 'form' will pop-up. Under General, the Name should be the same for each checkbox you want in the 'radio button group'. So, in my case, I have a Name for the Yes ckbox: undefined_10 and for the No...
  4. 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...
  5. swtrader

    Excel VBA variable print range

    Will do. Good advice.
  6. swtrader

    Excel VBA variable print range

    Excellent. Very helpful. I could have gotten there after a couple of hours but it would have been clunky at best. And I just ordered an Excel 2007 pivot table book: "Pivot Table Data Crunching for Microsoft Office Excel 2007" Jelen, Bill I respect your suggestion on use of PTs. As time...
  7. swtrader

    Excel VBA variable print range

    What I am working on is essentially a pivot table. The data is in a flat file... Date Description Amount 8,000 rows +/- The Description strings in the raw data are searched for certain key words and the record is then classified as to category. Code then runs to group and sum all...
  8. swtrader

    Excel VBA variable print range

    You're absolutely correct. "Say A2 is 7/1/2012, A3 is 7/2/2012, etc. -- out 2 years." would indicate rows, not columns. It should have been "...B2, C2, D2 have the dates " My mistake. Whereas you answer dozens, if not hundreds of these over a period of time, I ask only 1 question every few...
  9. swtrader

    Excel VBA variable print range

    I use the filter a lot to hide/unhide rows of data based on criteria. However, I don't know how to filter columns. How would I use a filter to include the ranges A1:A4 (Labels) and C1:D4 (Data, with Dates in R1) based on dates? If filtering of Columns won't work, I think I can write the code...
  10. swtrader

    TransferSpreadsheet

    I'm unclear if you are using Access or Excel as the source of the code. Are you trying to export from Access to Excel (using Access) or import into Excel from Access (using Excel)? And I'm not sure what is timing out. With some clarification, we can help you. swtrader -- If you don't know...
  11. 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...
  12. swtrader

    Use variables with CopyObject

    Great. Thanks. Here's what I needed: Dim OldTableName as string Dim NewTableName as string OldTableName = "tblFileName_BU2" NewTableName ="tblFileName_BU3" DoCmd.CopyObject ,NewTableName , acTable, OldTableName this keeps the old table and creates a new one
  13. 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 =...
  14. swtrader

    file listing

    Solved. I toyed with and wrote some clunky code but it works. Thanks for looking. swt
  15. swtrader

    file name to hyperlink field

    addy, Thanks for your help. It made me realize that I really didn't have a common ID between the two files -- which made it impossible to run an Update query. I bootstrapped getting the FileNo out of the FileNames file into the myFiles file(which has the files listed from the system folder)...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. swtrader

    copy range from one workbook to another

    Thanks, Skip -- This is what I finally scrapped together. Interestingly, I did not use Resize in this part. As is usually the case, I don't fully understand everything but I did get it to work... (The 'syntax' on the Range setting was part of what I had trouble with) With schrange...

Part and Inventory Search

Back
Top