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

    Home Outlook Issues with Contacts list

    OK so Outlook 2003 used on Home computer linking to our Fios account. Windows XP When I updated the contacts list the wrong information was then populated in the address book. Additionally I know the NK2 file (which helps to populate the drop down list of previously used emails) is out os...
  2. chadlmiller

    Report question on grouping

    Ok so I have a grouping by date. Dates are grouping by Qrtr report shows Q4 2009 the code which shows this is as follows in the properties sheet in the control source:="Q" & Format$([Opened Date],"q yyyy") OK so here is my question: How do I modify the qtr report to show up for Government...
  3. chadlmiller

    Force required cell data

    So I have excel 2007, on windows xp. I have three sheets. Sheet 1 contains raw data, sheet 1 disassembles data and sheet 3 reconfigures or rewrites data based on logic to populate for a .prn file to be upladed into a mainframe system. I need to ensure that cell E2 has data populated based on...
  4. chadlmiller

    I need a script to create alternate file types

    OK this is a two part question. First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend if the Macros security issues are different between Orgs using a templated Excel spreadsheet. Second, what I need the macro/script to Execute. I have a data template (DATA...
  5. chadlmiller

    Multiple Users Saving data

    OK , I thought this was simple fix. Please help. I have an ACCESS 2007 Template which I modified simply and it works with one user. I placed the Tracker.mdb onto a share drive \\tulip\fmbm No one except one person at a time is able to input data until one person enters informaiton then saves...
  6. chadlmiller

    Excel Macro or VBA on Button

    OK this is a two part question. First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend if the Macros security issues are different between Orgs using a templated Excel spreadsheet. Second, what I need the macro/script to Execute. I have a data template (DATA...
  7. chadlmiller

    reading a partial string in Excel

    Ok I am using Excel 2007 and here are the examples of what I need. in the column I have data example: 03 - Maintenance & Production Facilities 02 - Training Facilities I want to read the text of the first two identifiers 03, 02 and store it into a new column seperate rows. I plan to delete the...
  8. chadlmiller

    parameter requested

    OK, I am working on Access 2007, I am familiar with the Access 200 concepts but haven't worked it since. I added a new field to an Issues Tracker MS Template table. I copied the "comments" field and added a new field called "Resolution_Comments" I added it to the "Issues" Form Now when ever I...
  9. chadlmiller

    Parameters in Form

    Ok so I have an access 2007 table which I was updating with a new field. This is a Memo field and all appears fine. After saving the table and form update suddenly when I go to reopen the Db or the Form it asks to fill in a parameter. It does not require an entry if I select OK then it will...
  10. chadlmiller

    If statement can change color?

    I'm trying to make a cell in an excel document change color within the context of an IF statement... [=IF(A20="LSS Training", blue background, no background)] Is something like this possible?
  11. chadlmiller

    VBA script Please

    OK MS EXCEL 2003 I know it can be done but my script skills are not savy enough. I want to use an Excel work book and develop a macro or VBA script that does the following without a great deal of link correction: I want to click on a button to create a new sheet that is an exact duplicate of...

Part and Inventory Search

Back
Top