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 Mike Lewis 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: *

  1. DummyForAccess

    Word - Form - Text Box

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

    Word - Form - Text Box

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

    Word - Check Box

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

    Excel - Conditional Lists?

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

    Run a .bat file from .vbs

    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?
  6. DummyForAccess

    Combine files into one Workbook - Different tabs

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

    Combine files into one Workbook - Different tabs

    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?
  8. DummyForAccess

    Excel - Watermark

    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?
  9. DummyForAccess

    Power Point - Excel Linked

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

    Copying Files into One

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

    Form - Edit, Updates when changing records

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

    Form - Edit, Updates when changing records

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

    Error Handling

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

    Error Handling

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

    Call Sub based on a variable

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

    Loading quotes in variable

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

    Excel - VBA - Return Value

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

    Form - Binding a Frame

    Exactly what I needed! I don't work too often in Access, and once again I spent about an hour playing around trying to get this to work. 5 minutes after posting this, you gave me the info I needed to get this up and running like a charm!!!
  19. DummyForAccess

    Form - Binding a Frame

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

    Access DB Distribution

    Oh, forgot you asked that, yes the users do have Access installed. I did have to convert the db over to 2002, I got that message earlier on.

Part and Inventory Search

Back
Top