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: *

  • Users: ztm
  • Order by date
  1. ztm

    cell data in header

    misterstick, To answer your question, the answer(I believe) is no, not without VBA. But - there's always a but - you could use the 'Print Titles' option to print the same row of data at the top of each page. If you put the row at the top of your sheet with the data you want to include...
  2. ztm

    VGA Ext. Cables distance limit?

    Hello all, I need to control two PC's located about 30 feet apart with one keyboard/monitor. I've been looking at KVM switches and they say they'll do exactly what I need. However, last year, I needed to place a monitor and keyboard about 60 feet away from the PC. I used pre-made 100 foot...
    • ztm
    • Thread
    • Replies: 4
    • Forum: Cabling
  3. ztm

    Combo Box to list sheet names

    Dear Dale, Skip, and other members of the forum. No offense intended. I am very grateful for the help I've received and am quite impressed with the generosity and knowledge that members have shown. You're right, I was unaware of the "Star treatment". It won't happen again.
  4. ztm

    Combo Box to list sheet names

    Skip, Thanks very much!! I was able to paste your code almost exactly as you posted it. All I had to do was define the range and add one line... Sheets(UserForm1.ComboBox1.Text).Activate - just before the last For..Next loop. I was getting an application error before that. Thanks again.
  5. ztm

    Combo Box to list sheet names

    I'm putting a user form in an Excel 2000 spreadsheet that has has several worksheets. On the form I have two comboboxes. I need the first combobox to list the names of all the worksheets, i.e. "sheet1", "sheet2", etc. Then, I need the other combobox to list the contents of...
  6. ztm

    msgbox at bottom corner of screen

    Here's something I've never seen before...All of a sudden all of my message boxes in one Access database pop up in the lower right corner of the screen. What's up with that? Anyone? Not a big deal, but it bugs me 'cause I can't fix it.
  7. ztm

    select items in list box at startup

    Very nice Aivars, Thanks.
  8. ztm

    select items in list box at startup

    How can I have multiple items in a list box selected at startup? I'm using Access 2k. I've built a report generator for a maintenance tracking database. We have about 30 machines listed in a list box that the user can select as many as they want to generate a report for the selected machine...
  9. ztm

    halt code from form

    I'm working on a keno game for a school project that lets you play multiple consecutive games and tallies the results. i.e. if you play the same 7 numbers for 1000 consecutive games, how many times do you hit 7, 6, 5, etc. and calculates winnings and losses. I have two little problems...
  10. ztm

    Which Label did I click on?

    Index!! That was it! Thanks for the quick response. I did have the labels in a control array, but just couldn't make it work. I ended up with Private Sub labelarray_Click(Index As Integer) labelnumber = labelarray(index) End Sub Thanks again.
  11. ztm

    Which Label did I click on?

    I'm working on a project that has a bunch of labels in an array on a form. When I click on one, I want to execute the same code as I do for each one (hence, the array) but I can't figure out how to tell which label I clicked on once the code starts? Any help would be appreciated..Thanks.
  12. ztm

    Print dialog box

    Hello all, I’ve got an Access form that prints an existing excel spreadsheet from a command button. I want it to prompt the user for number of copies and printer (print dialog box) but otherwise, run in the background. I accomplished this on another project I did and it was clean and...
  13. ztm

    variable in query?

    Hello all, I’m creating an Access database to track machine maintenance. I have a table that lists the standard costs of each type of PM (periodic maintenance) for each machineID. The fields in the table are MachineID (number), Daily (currency), Weekly (currency), Monthly (currency), etc...
  14. ztm

    Wild Card in Criteria from form

    You are a GOD! I would have never thought of doing it that way. It worked perfectly. Thanks very much!
  15. ztm

    Wild Card in Criteria from form

    ...an item, but if I don't, I get zero records returned. This is what I have in the criteria field. IIf(IsNull([Forms]![formname]![Combo]),"*",[Forms]![formname]![Combo]) I've tried all kinds of variations of the wildcard using the words Null, like, etc. and all I get is zero...
  16. ztm

    Word quits too fast...

    Thanks John, It seems so obvious...now.
  17. ztm

    Word quits too fast...

    Hey all. I'm creating an access form that prints a Word document. It works great if I step (F8) through the code, but when I run it in real-time, I get a message from Word that says "...quitting Word will cancel print jobs." Obviously the code is running too quick for the document...
  18. ztm

    B.E. on PDC?

    What are all the services and how do I make sure they're running?
  19. ztm

    B.E. on PDC?

    I guess I'm not as smart as I thought. I'm running Win2K server on a Dell PowerEdge 1400. I try to install BE 8.5 and when I run it, I get an error message that says..."Unable to connect to the backup server." I don't have a backup server. How do I tell it that? I can't seem to...
  20. ztm

    tranfer spreadsheet macro

    ...argument blank. It prompts me for a filename with a standard windows 'save as' dialog box. I think the same would work with the TransferSpreadsheet command. Be sure to include the comma, though. DoCmd.OutputTo acOutputTable, "tblName", "Microsoft Excel (*.xls)", , 1

Part and Inventory Search

Back
Top