Search results for query: *

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

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

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.

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.

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.

Very nice Aivars, Thanks.

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

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.

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

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

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

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

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

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

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

I use the OutputTo command to output a table to a spreadsheet, and I leave the filename 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...