Search results for query: *

I have the following VB script set in an event procedure for a button: Private Sub Command5_Click() Dim fs As Object Dim i As Integer Set fs = Application.FileSearch With fs .LookIn = "J:\USB_Requests\Original Requests" .filename = "*.xls" If .Execute() > 0 Then...

I would just create a pivot table that would catagorize each date with the associated ID accordingly. Then all you have to do is keep entering date and ID sequentially going down and update pivot. Hope this Helps!

The easiest method would be to include an if statement with sum of the fields your adding up. example: if((sum(a1:c1)>699,"Exceeds Limit","") I would put this after the last Monthly column so that as each previous month is entered, the individuals can see the pop up field...

If I understand correctly then you would have your Master workbook with all cells linked to the APPLE worksheet but you wouldn't be able to change the cell data in the master to show on the APPLE worksheet. Your best approach would be to use the Protect and Share Workbook functionality found...

A few suggestions would be: 1. Protect the workbook with a password and have Worksheets from other "Users" workbook linked within this protected one with sheet 6 available. 2. A little more intense VB approach would be to create a button that runs a macro or VB script that goes to...

I'm sort of confused on what your asking, but maybe creating a shared,MASTER workbook, would capture everything you are wanting to do. Shared workbooks allows you to set parameters of updates and who over rides who when a conflict occurs amongst everyone using the same workbook. Hope this Helps!

Skip is correct below in that when you apply protection via cell properties, security, it pertains to the entire workbook. If I'm understanding you correctly you want to allow changes to A1,A2,A4,A5 while keeping A3 unable to delete formula. Well then you need to select all the cells using the...

to add to the reply below, if you wanted to eliminate the absolute "$" sign in the formula,you would have to add this (just change your column ref accordingly as stated before): for info found in A column-...

OutLook 2000 is backwards compatible and should allow you to IMPORT from the file menu your personal and archived files from 97 unless of course your archived files are corrupt; you should get an error message stating so though. Hope this helps!

In any of the versions of access you can create subqueries within a report and capture information from different queries in one report. If your pulling in same data from multiple datasources then create a union amongst them. hope this helps!