Search results

I was just wondering if any of you have used or know someone who has used a program called DBAmp. Could you let me know if you like or dislike the software? My boss asked me to look into the software, but aside from the manufacturer's website, I'm having trouble finding reviews for it. The...

Is there a way to set a macro up that would loop through a list and find and replace multiple words in a cell? I have a list of addresses and a list of acceptable USPS abbreviations. I would like Excel to look at the address and loop through the list of abbreviations and apply any that fit...

Is there a way to validate a list of addresses in Excel that is free of charge? I have a list of addresses that were put in by various individuals that I would like to standardize. For example, I would like to change all of the states that are spelled out to state abbreviations. I would like...

Has anyone here used the software Tableau? I am working on building a report in it, but am having a lot of difficulty getting a calculation to sum. The program either tells me that the data has to be from the same data source or it tells me that the calculation is already aggregated and cannot...

Is there a way that I can merge data from two reports into one spreadsheet? Both reports contain an ID number that would line the records up. However, one report contains a lot more records then the second. I know I can use the Vlookup Formula to accomplish this, but wondered if there was a...

Is it possible for an InputBox to have a ComboBox instead of just an open text field? I would like to utilize the InputBox functionality, but I would like to limit the user on what can be entered (I don't just want a free form field). Is there a way to give the user specific options to enter...

I currently have my database linked to a page in SharePoint. Some of my teammates are complaining that the database is very sluggish in connecting to SharePoint. Is there any way to speed up that connection? Would it be possible to update the database from SharePoint when the database first...

One of my coworkers contacted me today to let me know that her database suddenly quit working. When I looked at it, I found that the database was not in a "trusted location". I tried to add the location as a "trusted location" and received this error message: "The remote or network path you...

I have been asked to create a report based on e-mails in a group inbox. I just need to know the subject line, date and time received, and whether or not the e-mail is read. The only way I know to do this right now is manually go through the inbox. Is there any way to programmatically pull...

I have a spreadsheet that I am using for a template. The template has two pretty simple macros and a handful of formulas. Since this is a template, there is no data in the spreadsheet. However, the size of the spreadsheet is about 28MB. I don't understand why the spreadsheet is so large, nor...

In my database, I have a table that houses information based on order project. An order project can have anywhere from 1 to 50 orders tied to it. This is just one record in my database, but there is a field that states how many orders go with the project. For average purposes, I would like to...

Can the AverageIf formula be used as an aggregate formula? I'm trying to get an overall average from 5 tabs on a workbook. I tried using =AVERAGEIF('MON:FRI'!F6:F615, ">0"). Unfortunately, this returns a "Value" error. Is there a way to get this to work?

Is there a way in a query to calculate the number of workdays between two dates? I have an order received date and an order released date. I would like to see the number of workdays between those two dates. For example, if an order was received on April 8 and released on April 11, it...

I have a database that is split and I want the users to have a copy of the database on their harddrive, instead of using it off the network drive. The problem is that some of my users are over seas and the desktop on their computers is linked to a network. I have code that works great if the...

I need to combine the date and time column on my spreadsheet, so that I can calculate the number of days that it takes to complete an order. I've tried everything I can think of, but Excel will not allow me to combine these two columns into one. Do you know if this is possible? I have my...

Is there a way to monitor an Outlook Inbox (one that is not the primary inbox on the computer) through Access? My department has a department Inbox that everyone has access to. However, since it is not the primary Inbox, we are not notified when messages are received. Is there a way for...

Is it possible to update one record on a table from another record in a form? I have a form that tracks orders. It shows if one order is replacing another. If it is, the database checks to see if the old order needs cancelled. If it does, a message appears on the screen letting the user...

I have a table that contains order information based on order number. In that table, I also have a field labeled ReplacingQuote so that when one order is entered to replace another, we can keep track of it. Now, I want to create a query that will show this history, but I can't seem to get it...

I have a ComboBox on my form that has a lot of options (its for customer name). Is there a way that I can program the combobox so that once the user enters the first couple letters, the combobox will just show the customers starting with those letters? For example, when the user enters BO...

Is there a formula that will show me the maximum value in an array based on a certain criteria? I have a list of parts and the teams that repair them. I want to find out the part in each team that has the highest dollar value. Is there a way to do that without needing to go through each part...