Recent content by DummyForAccess

sorry, I'm lost. I'm not doing any programming with it, I'm just trying to add the box to a document in Word that will be used as a form to fill out - but not linked to any database or anything like that...

I am working on a form in Word. I want to add a text box that users can fill in. If I add a text box from the Form toolbox, it creates a teeny one that can "grow". How can I create one that is like the very box I am typing in now, that is a specific size and shape? I had one on the form...

How do I insert a working check box on a Word document? When I insert one, it doesn't allow anyone to "check" it...

I am working on a form. I am using drop-down lists for folks to choose different answers. Is it possible to have a dropdown reference a previous drop-down and base the options on the previous drop-down? For example, if they choose a department of registration, the next drop down of job titles...

I have a simple script that I used a utility to write that ftps some files for me. I just want one more step added to the script, that will run a .bat file. I tried typing in run f:\htp\bkup_move.bat but that doesn't work. What syntax will run this .bat file?

This will work, I was hoping to figure something out that I could automate more....

I have several files that I want to combine into one workbook, BUT, I want each file to land on a separate tab. I know how to do the copy function in DOS to make them into one file, but is there anything I can do during this copy functino to make the different files go to different tabs?

I am trying to put a watermark into an Excel document. I need the watermark to print when the document prints. I can get a background inserted, but it won't print when the document prints. Anyone know how to do this?

I have a presentation that I'm wanting to have linked to certain spreadsheets that are in excel. This works great, except, I need to show only a certain portion of the sheet, not the entire sheet. (this will look much better too, instead of having half an empty sheet show up in the...

Help, it's been a while since I've done ANY coding in VB. I'm trying to copy several excel files into one, I want it to work just like a .bat file will work if you use code something like: copy file1.csv + file2.csv file3.csv In this case file3.csv would have the data from file 1 and 2...

I don't mind the slight subject change at all. Now I understand how the form works (doesn't mean I like it...). In response to your situation with wanting to hold data back and then append all at once, I'm not sure if this would work for you, but have you considered having your records append...

I have a simple form built that is linked to one table. It is designed for the user to edit records in that table. I have a "process" button and a "find Record" button. Also the typical navigation buttons at the bottom, to scroll thru the records. Here's my horror: I've discovered that if...

Thanks so much. I've got error handling in all of my macros now, it looks so much better for the user to get a message that makes sense to them rather than getting the VB "End, Debug" kind of message.

Ugh, it's been a while. I can't for the life of me remember how to do two things: Create a simple error handling routine inside a sub. Once I do the above, need to create a little message box, probably just an okay button type.

Help, Here's the code I have so far. The error I'm getting is that it's expecting a sub or function. How can I call a sub based on the value contained in cell O2? Sub M_Run_Macro_D2() Dim mcro_nm As String Dim windw As String Sheets("Macro List").Select windw = Range("N2").Value...