Search:

We have to download data from an online database. I then run that data through macros to prepare the data for use in Access. I found that my XLSTART file was accumulating the download files I was...

I have been using the personal.xlsb file to hold several macros that are used in various files when download for our online database. Today I created a new macro assigned to persoanl.xlsb and it...

Thank you, I had thought of that, but I am depending on users to click both buttons before using the final data. I was hoping to find a way to make sure that they only have to click one button.

I have a couple of things I am trying to accomplish.
1. Allow users to select one or more than one title from the list and run a parameter query.
2. Append this data to a table that will make sure...

I have a worksheet where the range of cells change with each download of the data. The downloaded data gives me duplicates on some information. I am using excel to remove the duplicates on the...

Thank you, already have it bookmarked. It seems to explain things in simple terms, I have been told that I am a visual person and that is why programming is more difficult for me. I have taken...

Your correct, that worked. But I still would like to learn how to write a loop based on data from a query. Thank you Djsmith

I know just about enough programming to get me into trouble and frustrated enough when I don't understand how to proceed. Hence, I have come for assistance. I have been trying to figure this out for...

RG: Thank you for the well described instructions. It worked like a charm and must of know, I would not have know what to put into my Query to call my function. Thank you very much.;)

I have a number of conditions to test for and each has its' own value if true. I can get this to work in the Query design window until I get to the very last piece then I get a message that my...

Thank you tgw7078 for your suggestions. I will definitely look into revamping this database. Especially since the end user wants to create more tables and reports than previously provided. I am...

Just this morning, I replaced the data in the tables of a known working version of this database and that worked. With this process I used the original table structures. I discovered that someone had...

The database when opened from SharePoint, saves a local copy of the database. When entries are complete the "Publish to SharePoint" button updates the copy on SharePoint.

Unfortunately, I do need...

Thank you, I have looked at the references and those are fine. I am been trying to work through the issue using a known working version of the database. It seems to work fine until I import the...

I have a database that was created in Access 2003 and has since been upgraded to 2007 and now is being used in 2010. This database currently resides on SharePoint where it is download, updated and...

Sorry, I have been tied up with a few other projects. Just tried the statement suggested by Cronk--Thank you a thousand times, works like a dream. I appreciate everyone's help out here.

Thank you both! I have removed the 'as string' from the function declaration. and declared it as a variable. Then I added SplitPart = LSTRSP_EML_DOMAIN before the Return.

I went through my VBA...

I have attempted to address each of the points you made, I just am not sure I am really clear on some of the terms. Below is my updated SplitPart () with comments to see if I am understanding your...

No, but that could well be my problem.

This is a drawn out process that I am trying to simplify with code. An Excel file is created from a report pulled from an online web database. This report...

I have a function
Public Function SplitPart(LSTRSP_EML_EMAIL)
Dim LSTRSP_EML_EMAIL As String

'Dim LSTRSP_EML_DOMAIN As String

Split([LSTRSP_EML_EMAIL], "@", 2) = [LSTRSP_EML_EMAIL]

...