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

  • Users: krets
  • Order by date
  1. krets

    Excel: Check active sheet before running macro

    Perfect. Thanks.
  2. krets

    Excel: Check active sheet before running macro

    How would I create an If statement to check the name of the active sheet and only continue to run if a certain sheet or sheets are active? In this case I only want a macro to run if the "Data Processing" sheet is currently active. Otherwise I'm going to pop up a message box. Is there an...
  3. krets

    Excel: Transfer sheet with formulas intact

    And particularly it is the vlookups that are getting mucked up. The table arrays are still trying to reference the array in the old workbook.
  4. krets

    Excel: Transfer sheet with formulas intact

    Oh, sorry. Using Excel 2003.
  5. krets

    Excel: Transfer sheet with formulas intact

    I would like to move one sheet from an Excel workbook to another workbook with the formulas intact. The problem is that when I move the sheet the formulas within it still try to reference the old workbook instead of the new one it has been moved to. The names of the other sheets in both...
  6. krets

    Find date of the beginning and of LAST week

    When I tried that method I would get a "vbSaturday" text box. Here's what I ended up doing: WHERE tblAITInfo.AITDate >= (Date() - WeekDay(Date()) - 6) AND tblAITInfo.AITDate <= (Date() - WeekDay(Date()));
  7. krets

    Find date of the beginning and of LAST week

    Damn fat fingers. What I would like to do is set the first and last day of the previous week for the WHERE clause of my query. So the query will return only those records with a date of last week.
  8. krets

    Find date of the beginning and of LAST week

    Is there a way to find the beginning and end of last week (week starts on Monday and ends on Friday) in a query?
  9. krets

    Updating three databases automatically

    The three sites are in different locations across the US. If the backend is kept on a network folder in one location the other two sites experience extreme wait times while data is loaded. I have not tried replication, no. But from everything I have read and been told it is more headaches than...
  10. krets

    Updating three databases automatically

    We would love to have this on a secure website. The problem is that right now our IT department is so bogged down with other huge corporate projects that the wait time for something like that is six months to a year. So in the meantime we're trying to come up with another solution. My thought...
  11. krets

    Updating three databases automatically

    I've been trying to come up with a way to update databases across three different locations in an automated fashion. I can't use a linked backend because our networks are currently overloaded so adding and accessing records takes way too long. I looked into replication but everything I read and...
  12. krets

    SQL Text Functions

    Sweet. I knew there had to be something like that. Do you know of any references that would list all of the SQL functions like this? I've yet to find a really good one. Even if it were a book.
  13. krets

    SQL Text Functions

    How can I pull a certain number of characters from a field with SQL? For instance, if I have values in a field like "OP 200, CY 301, CB 101, etc" how can I pull either the first two characters or the last three digits?
  14. krets

    Conditionally sending an email

    I'm pretty new to VB so I don't know how to do that.
  15. krets

    Conditionally sending an email

    Ah, it wasn't my Dlookup, it was something in how I had the routines structured. I changed the order around a bit and everything works. Thanks for the help.
  16. krets

    Conditionally sending an email

    I think my Dlookup was formed badly so I changed it to add single quotes: DLookup("[Rework]", "tblAIT", "[ErrorCode] = '" & Me!ErrorCode & "'") If I use the immediate window to change to form field to a hard coded error it returns a -1 or 0 corresponding to the Rework field. So to use that in...
  17. krets

    Conditionally sending an email

    When I run a query that should return the same result it returns what I want: SELECT Rework FROM tblAIT WHERE ErrorCode = "Whatever" That returns the Yes/No check box with the appropriate value.
  18. krets

    Conditionally sending an email

    Nope, it's bringing back Nulls for some reason no matter what error code I use. Is my Dlookup malformed or something?
  19. krets

    Conditionally sending an email

    Ok, that sounds like what I want. When I set up the conditional statement like: If DLookup("[Rework]", "tblAIT", "[ErrorCode]= " & Chr$(34) & Me!ErrorCode & Chr$(34)) = True Then Do email stuff End If Even if I select an Error Code where I know Rework is true, it's not running the email routine.
  20. krets

    Conditionally sending an email

    There is no control on the form for Rework. Rework is set in tblAIT by a supervisor or manager for each Error Code. It is not set by the user. Each Error Code either requires rework or it doesn't.

Part and Inventory Search

Back
Top