Search results for query: *

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?

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

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

I'm trying to load a variable with quotes (example would be I want to have X be loaded with Range("C2:C45") How do I put quotes into something like this? I even tried to load another variable with just quotes but no success...

I'm having difficulty doing something pretty simple. I have limited VB experience. I'm trying to return a value that is in the sheet to load into a variable. In this case, the value exists in cell X1. How do I get to set a variable = to value that is in cell X1? (what I'm doing is finding...

I have a form that has 5 boxes that appear/disappear based upon a choice made in a frame. This is done via a sub in the AfterUpdate for the Frame. I also want these boxes to appear/disappear based upon the value in the frame. It seems like I should be able to use the same code, but can't find...

And now for the BIG Question. I'm getting ready to distribute a database, what's the best way to begin to explore this? I was going to do something where you can make an ".mde" file, but that won't work (I get a nasty error, and I think my database is too big).. what other suggestions does...

Hi, I'm wondering if there's any way possible to extract the highlight color from a given cell as a value? If I can create a column on a spreadsheet, have it extract the color value of an adjacent cell, I could then be able to filter by color....

Argh, Long ago in a past lifetime I worked with someone who used an algorithm to store "true" values while looping through error-checking code. At the end of looping through each record, a total number for that record identified which errors the record had. If I remember right, we...

I am having problems creating a switchboard, it seems to be acting strangely. If I create a switchboard, only a few of the buttons will actually work. Also, if I try to create a sub-switchboard, that wont work at all. Does this sound like something wrong with my installation of Access or am I...

I'm trying to automate a very manual process. I have a database built in Access that will import and refresh tables. Then I need to have a macro that opens an Excel spreadsheet and calls an (Excel) macro. (This macro is necessary because it formats the spreadsheet in a certain way, populates...

I am automating some stuff from Access. I am using a module to kick off an Excel spreadsheet that has macros. This works great until I get a message that says the database has been locked by Admin (Uh, I'm the Creator, I'm the one in there, and it shows me locked out of my own db, can you say...