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!

Register Log in
  • Congratulations derfloh 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. mmaginniss

    pass data between pages

    I am wondering if there is a way to use Javascript to pass a value between different pages - without creating a cookie or putting the data in a database. For example, on page 1 I have a text input field. The user enters into the input field "ABCD". Then the user clicks a link and goes to page...
  2. mmaginniss

    compare two tables

    thx
  3. mmaginniss

    compare two tables

    I have two tables - one for the month of June and one for the month of May - and each table has the exact same data fields (and very similar data). I am trying to determine what records have changed from May to Jun using a query. Here is an example of the two tables: Table May Table June...
  4. mmaginniss

    IIf function issue

    Hi- I am having issues with the IIf function. What I am trying to do is use multiple conditions within an IIf function. At first, I created a calculated field with the following expression: Sort: IIf([ProjectManager] Is Null,1,0) This worked fine, giving null values a value of 1, and...
  5. mmaginniss

    Pass field values into SQL w/VBA...

    Thanks, RoyVidar! And yes, I did need a WHERE CLAUSE. Here's the final code: ' Take the value of txtAddOne Begin and ' txtAddOneStop and plug it into the SQL ' update query Private Sub cmdDoIt_Click() Dim intValueOne As Integer Dim intValueTwo As Integer intValueOne =...
  6. mmaginniss

    Pass field values into SQL w/VBA...

    I am trying to take the values a user would type into two text fields and plug those two values into a SQL update query. I am trying to do this using variables. Does anyone know where I might be going wrong... Thx. Here's my code: ' Take the value of txtAddOne Begin and ' txtAddOneStop and plug...
  7. mmaginniss

    OutputTo method and save the file by date

    you're the man, ramzi! thx.
  8. mmaginniss

    OutputTo method and save the file by date

    Thanks for responding. You're close, but I get a file CMDRpt.rtf31Jul03 which cannot be opened. It's like I want to stick the date before the .rtf ending.
  9. mmaginniss

    OutputTo method and save the file by date

    I have automated the task of ouptutting a report to a file on the network using the OutputTo method but now management wants me to save the file by date - so that they can see the changes in the report based on what day it was generated. Here's my current code (I changed the location to my...
  10. mmaginniss

    combining record data from a table into a query

    That works. Thanks Kevin! You're the man. There are times when the data shows 0,0,0,0 for employee hours on a project that I would rather not see. Any way to eliminate records where I get 0,0,0,0 in wk1, wk2,wk3, and wk 4?
  11. mmaginniss

    combining record data from a table into a query

    I created a company timesheet table that looks like this: Project # Empl. Start Phase Wk 1 Wk2 1 Bob 06/30/2003 A 5 2 1 Bob 07/14/2003 A 10 0 2 Joe 06/30/2003 M 8 4 2...
  12. mmaginniss

    protect cells while allowing user to filter in Excel

    Thx for the suggestions. I'll give them a try.
  13. mmaginniss

    Access TransferSpreadsheet problems

    I believe you can create a new linked table in access and link it to your excel spreadsheet. Then you can run a query off the linked table.
  14. mmaginniss

    protect cells while allowing user to filter in Excel

    Microsoft Excel 2000. Thanks.
  15. mmaginniss

    protect cells while allowing user to filter in Excel

    I have an Excel master sheet which is linked to several other Excel sheets. On the master sheet I have a filter. I want users to be able to use the filter but not change the actual values in the cells of the master sheet. I have tried protecting the sheet but it doesn't allow me to then use the...
  16. mmaginniss

    disable renaming tabs in Excel

    You guys are awesome. Thanks.
  17. mmaginniss

    disable renaming tabs in Excel

    That's one way to do it... but I would really like the user to be able to see the tabs and navigate with them. I am creating timesheets that have dates in the tabs. I want the users to be able to navigate between time periods to update their timesheets, but I don't want them to be able to rename...
  18. mmaginniss

    disable renaming tabs in Excel

    I would like to disable the ability for users to rename the tabs at the bottom of an Excel page. Any ideas on how to do that?
  19. mmaginniss

    sorting null values on reports

    Ginger, this works. Thank you so much.
  20. mmaginniss

    sorting null values on reports

    I am trying to sort a field ascending by date. Some of the records contain null values and those values appear first on the report when previewed. I would like to change the sort order so that the blank (null) values appear last. Any ideas?

Part and Inventory Search

Back
Top