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...
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...
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.
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.