Search results for query: *

Perfect. Thanks.

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

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.

Oh, sorry. Using Excel 2003.

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

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()));

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.

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

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

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

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

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.

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?

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

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.

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

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.

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

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.

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.