Recent content by LadyDi

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

Perfect :) Thank you

I know how to call a function in Access. Unfortunately, I've never done it in Excel. Could you tell me how to call this function in Excel on Open?

This is perfect. Thank you so much. I have one more question for you. Is there any way to set this to run each time the workbook is opened?

Okay, here is what I tried, but it isn't working. I keep getting an error message that states "For control variable already in use". Also, for some reason it is enclosing my cell references in single quotes. What am I doing wrong? Dim addr As Integer Dim abr As Integer Dim newaddr As...

Would you be able to give me an example of what it should look like? Unfortunately, I have had trouble in the past when I try to write a loop - somehow, I frequently end up with an infinite loop and I don't want that.

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

This is not a one off. We receive applications daily from a website. We want to download the addresses, correct them and then re-load them to the site (unfortunately, we don't have permissions to regulate the fields on the website). Unfortunately, I don't have the option of using Access for...

You are correct, this is not really validating the address, it is just standardizing it. I downloaded a list of acceptable abbreviations from the Post Office. Could someone tell me a way to update a list of addresses with these standard abbreviations without doing a formula that is nine...

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