Search results

I changed the IsError to IsNull, and tried again. Unfortunately, I am still getting the "Data Type Mismatch in Criteria Expression" error. How do you get the IsNull to work?

This actually works, as long as the Bin is found in the e-mail table. Since the BinName is stored as a string variable, it errors out if I add the delimiters. I already tried it this way -- DLookup("EMAIL", "EMAIL_TBL", "BIN = ' " & BinName &"'". However, when I do it that way, it never...

I am using a DLookup to capture an e-mail address as a variable in my code. Then I use the e-mail address when I generate an e-mail with an attached report. My problem occurs when the e-mail address I am looking for does not yet exist. I tried using IsError with my Dlookup in an If statement...

I am currently working on a database where an administrative associate will need to send a report or form from the database to a field technician for update. The technician will need to update the report for each piece of equipment he or she has on a truck and then send the information back to...

That formula works great. Thank you for your help.

I have a query that lists the total number of parts received by month. I would like to be able to compare those monthly totals with a rolling 12 month total. I've been able to get the rolling 12 month total, but I can only get it to work for one 12 month period. Is there a way to get a 12...

The Crosstab worked perfectly when I set the date up the way you suggested. Thank you very much for your assistance. I appreciate it.

The link with the Master Dates worked great. Thank you very much for you assistance.

The formula you provided works great. Is there a way (without re-ordering the query every month) to get the columns to go in sequential order? For example, I would want this month to go May 2013 - April 2014. As it stands right now, my query always shows Jan to December no matter the year. I...

I am trying to use a Switch formula in a query so that I can list results in the query horizontally by month. However I am having a lot of trouble with it. The only way I can get the query to run is to enter the formula like this: Mar_Totals...

I was just trying to make this database as automated as possible. That's why I was trying to avoid the need to update a Holidays table once a year. You mentioned that this was possible. Could you tell me what I need to do? If there is not a way to avoid a Holiday table, then I will add it.

I have modified my tables as suggested elsewhere on the forum. My tables now show ORDER_PART_NUM, ORDER_MONTH, ORDER_YEAR, ORDER_AMOUNT. The problem I am having now is getting it to show totals for each part by month horizontally.

I am trying to create a rolling twelve month query that will total the months across. I set the query up so that it is a rolling twelve month, but I am having difficulty getting it to list the months across. I would like it to take the first month, list it as a column and show the totals...

Is there a way, in a query or via the use of a module, to calculate the workdays between two dates excluding holidays without needing to maintain a separate table with the holidays listed out? For example, I would like it to calculate 21 work days for the month of May. However, I don't want to...

I am trying to create a database that will keep track of the orders placed for a given part number by month. Currently, my table houses the part number, and the ordered amount for the past three years by month (there are thirty-five columns for every part). My column headings are ORDER_MAY_2013...

I am trying to create a database that will keep track of the orders placed for a given part number by month. Currently, my table houses the part number, and the ordered amount for the past three years by month (there are thirty-five columns for every part). My column headings are...

I have a column in my spreadsheet that contains the call text that each technician enters about each call. I also have a list of words that I am looking for within those call texts. I have a formula the finds the words (--...

I have a spreadsheet that has a column for effective date (column R), effective time (column S), complete date (column T), and complete time (column U). I need to be able to calculate the time difference between these fields, and then I need to be able to run analysis on the results. The...

I am trying to create a form in InfoPath that will later be published to SharePoint. On that form, I have a Multiple-Selection List Box that is comprised of 5 check boxes. I want to limit that list box, so that only two selections can be made. I know I need to do it through Visual Basic, but...

That is the tutorial that I've been trying to get through all week. I can get it to work, up to the "Starting Another Activity". However, when I try to get the Send button to work, my "virtual machine" keeps telling me that my app has closed. I don't know what I'm doing wrong. I've done what...