Search results for query: *

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

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

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

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

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 trying to set up a button on a form to conditionally send an email based on a field in a table. The form is unbound and saves data to a table through a VB function called by a button. The field comes from a table called "tblAIT", is a Yes/No field and is called Rework. Basically the user...

Have any of you run across a technique or created one yourself that would email a certain report to every agent in a database once a day? We have an error report that is sent to our agents once a week but there has been some talk from higher up that they would like to do this once a day. In...

I'm having trouble figuring out how to set up my PivotTable to filter by dates. The raw data I'm using has the following column heads: Key | CellNum | Error Code | AITDate | Severity The table is set up with Error Code as the column heads and CellNum as the rows. The data is a count of Key...

On a form I am using I have a drop-down field that is used to control the filtering of a sub form. There is also a button on the main form that exports the sub form's source query with: DoCmd.OpenQuery "qryJoinXtb2", acViewNormal DoCmd.OutputTo acOutputQuery, "qryJoinXtb2", acFormatXLS, "AIT...

If I have one column that shows an employees hire date, how can I create a second column to calculate the number of days they have been employed based on the current date?

If I have a date in a cell, how can I force Excel to use the date as the value? For instance, if a cell says 10/30/2006 I want that to be the value, not 39020. What I would like to do is be able to use the LEFT and RIGHT functions to generate a unique key for each record in a long list that...

Something happened to one of the tables in a database I designed. I have no idea what happened as the guy who maintains it will either not tell me or really has no clue. Basically what I have is a database with a table called tblAITInfo that is missing all entries from 5/22 to 6/12. I have...

Would there be a way to use an array formula to pull the top ten values out of a list of 400 or so without using the sort feature?

Is there a way to easily auto-fill formulas that transpose data? What I have is a set of data that has the date on the X-axis and different error codes along the Y-axis. I'd like to recreate the table using formulas on a different sheet but the data needs to be transposed. When I've tried to...

It's been such a long time since I've used Quark. How do you turn off hyphenation? Such a simple thing and I can't seem to find the option.

I have a large table of data that contains some blank cells here and there. What I would like is to set the background color/pattern conditionally for any cell that is blank but I can't seem to get that done. I've tried setting all cells to the "greyed out" pattern and then formatting with...

I'm learning Access on the fly and I've been looking into replicating a database for use between three sites. I've found a few articles that cover the basics of how to replicate a database but what I am looking for is something that covers not the how-to but the should. Does anyone have any...

If I have a form and one of the field displays an agent's initials, how can I make the initials appear as a hyperlink that would open up a different form with a filter or query set for those initials? Can that be done?

I have a formula that conditionally averages the non-zero values of a column: {=AVERAGE(IF(E192:E199<>0,E192:E199))} Sometimes though, all the values are zero and the result will be the good old #DIV/0!. Is there a way I can write that formula so it returns a null or zero in place of that...

This formula is giving me a #VALUE! error: {=MEDIAN(IF((B3,E3,H3,K3,N3,Q3)<>0,(B3,E3,H3,K3,N3,Q3)))} (Yes, I did Shft + Ctrl + Enter to create the array formula.) Can I not use that like I would use: {=MEDIAN(IF(C3:C33<>0,C3:C33))} If not, how can I perform the equivalent of finding the...