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: ztm
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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.
  4. 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...
  5. 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...
  6. 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.
  7. 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...
  8. 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...
  9. ztm

    Wild Card in Criteria from form

    Please help! I've been struggling with this for an eternity! I have a query that gets its search criteria from a combo box on a form. I'm trying to make it so that if the user selects an item in the combo box, the query returns results based on that item. But, if they leave the combo box...
  10. 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...
  11. ztm

    automatic export

    hello all, I'm having trouble making a clean app. I run a series of queries in access and put the results in a temporary table. I export the table's contents to an excel spreadsheet. I have macros set up to format the data, perform calculations, etc once inside excel. Everything works...
  12. ztm

    Append a List Box

    I have a multi select list box that I want to be populated by items selected in a drop-down combo box. We have thousands of job/part numbers and I want a form to generate reports for each selected part number. If I have the list box populated by a query of all job and/or part numbers, it takes...
  13. ztm

    B.E. on PDC?

    Does anyone know if I can run BE 8.5 on my primary domain controller or does it have to be run from a backup server?
  14. ztm

    Win2K BSOD

    Hello all, I know there are about a million threads about the bsod, so what's one more? I'm running Win2K server on a Dell 1400SC PowerEdge dual pentium III machine. All was running fine until I tried to install Veritas Backup Exec 8.5 (the cd that shipped with the machine.) After...
  15. ztm

    Win2K BSOD

    Hello all, I know there are about a million threads about the bsod, so what's one more? I'm running Win2K server on a Dell 1400SC PowerEdge dual pentium III machine. All was running fine until I tried to install Veritas Backup Exec 8.5 (the cd that shipped with the machine.) After...
  16. ztm

    Multiple criteria from list box

    Hello, I've read through this forum, and it appears many people have a similar problem. I've read the solutions offered, but can't seem to make any of them work. I need to run multiple reports (i.e. 1 report for each item selected in a listbox on a form) where the item/items selected...
  17. ztm

    Can't Join Domain...

    I'm trying to add a w2k station to the w2k domain, but I get a network Identification error "The following error occurred attempting to join the domain 'CORP': The credentials supplied conflict with an existing set of credentials." Any guesses?
  18. ztm

    Problem with Date Range in Having Clause

    I have built many queries and sometimes I have this problem and sometimes I don't..I can't seem to figure out what is causing it. Here's an example. Two seperate queries referencing two different forms. Each with user input From and To dates. One works, one reports back zero records. Here...
  19. ztm

    Can't maximize, resize, or move excel worksheet.

    I saved an excel spreadsheet with password protection. When I opened it, I couldn't maximize, resize, or move the worksheet. Most of my menu options are disabled. There are no controls on the form (min/max/close buttons). I removed the password protection and no change. I have resaved it as...

Part and Inventory Search

Back
Top