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

    Script to move files based on file name to folder with same name

    All I have done so far is to search the internet for a solution, tried robocopy, didnt have what I need. I did move all the documents to the base directory named client dat, where there are subfolders for each client name and the documents are also named by client name. each folder and...
  2. dkriese

    Script to move files based on file name to folder with same name

    I have 1000 files/documents saved with last and first names, I need to move these files/documents to their respective folders that also have last name first name. I would like the script to read the last name and move it to the folder with the same last name, some sort of script or batch file...
  3. dkriese

    Data Validation with Comments Box included

    Check out this cool code I had help with. Works great if you have a list of names and addresses used for Data Validation and you need to have additional customer info. Take a look Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ' Ignore VBA Error If Trying To...
  4. dkriese

    Excel database - Reference material

    IF you download from Microsoft Template Wizard with Data Traking it will create an excel database of your data entry from a template to the excel database, which is a workbook with the same name as your template with the word database added, and a worksheet named Table1
  5. dkriese

    MsQuery in Excel not working....'Database has no tables'

    Office XP/Excel 2002 Yes, you had to download the add-in from the microsoft site, it's a great little wizard, and if you follow the instructions for Template Wizard with Data Tracking, it creates an excel database file with the same name as your template which adds the word database, the tricky...
  6. dkriese

    Blocks remain on screen

    Check the monitor regresh rates, you can change them based on your video card speed. Or in XP you may have to turn off the effects I am running at 85 hertz
  7. dkriese

    How to restrict USB port from data storage device on Win2000/XP

    Diasble it in device manager, disable this device USB Root HUB
  8. dkriese

    Excel worksheet, macro, or formula to copy rows

    The issue is I can't change the original worksheet as it was produced by the company, what they want is to have the person doing the data entry (who only knows data entry) be able to automate making separate worksheets for each client number for that month. The same client may appear on the one...
  9. dkriese

    EXCEL97 to 2002

    take a look at this site http://www.j-walk.com/ss/excel/faqs/xl97faq1.htm John Walkenbach who wrote the Excel Bible has alot of good tips you may need to re-write the macro in VBA, however, are users still using 97? in other words, are users using both versions of Excel?
  10. dkriese

    Excel worksheet, macro, or formula to copy rows

    what is the best method to automate the copying of rows to another worksheet, macro, or formula. I have a worksheet with rows of client data, I need to copy all the same client data to another worksheet i.e. with column headings client id name location hours I may have client id 1004 listed...
  11. dkriese

    Excel Stand Alone Application

    I was advised by the application developer Timberline to use excel, really
  12. dkriese

    Excel Stand Alone Application

    THe spreadsheet has to integrate with another accounting program, and I was advised that I could only use excel, otherwise I would have to create an access database that exports to excel that imports to another app, too many steps
  13. dkriese

    Excel Stand Alone Application

    take a lok at the draft sheets I started http://www.dkriese.com/ex3.jpg http://www.dkriese.com/ex4.jpg The weekly sheet (ex3) needs to post to the monthly sheet (ex4) which is then used to create a draft invoice which is sent to the parent company for final invoicing. The shaded area are the...
  14. dkriese

    Excel Stand Alone Application

    Can anyone advise me - I am creating an interactive excel spreadsheet for a client who is not computer literate. It is for project management. I wish there was an MDE for excel, but we all know there isn't. Can all of you advise the best way to make this spreadsheet appear a a standalone...
  15. dkriese

    Excel - pick id and merge row data into one cell

    I have a columns of customer id numbers, names, addresses, state zip, how can I get my client to pick the id number and it returns the data of the name address etcc in the next cell, i used vlookup but it only returns the data in one column, are there many ways to do this?
  16. dkriese

    SelfCert

    Did you do a search for selfcert.exe on your computer, it is usually in your microsoft office folder. Or as i was told you need to go to add/remove programs and click on microsoft office and add it thru there. or click on this link...
  17. dkriese

    Excel XP Tabloid Printing

    All printing options should be in your printer configuration, did you check on your printer menu to see if the paper size is still there? Does your printer support tabloid? If you installed XP it may have installed default options, you may need to go to the printer mfg website and download new...

Part and Inventory Search

Back
Top