Search results for query: *

Does anyone know a quick and efficient method to strip duplicates from a string? For example: My string = "AB, CD, AB, EF" My string without duplicates = "AB, CD, EF" Thanks

Does anyone know a quick and efficient method to strip duplicates from a string? For example: My string = "AB, CD, AB, EF" My string without duplicates = "AB, CD, EF" Thanks

I have a main form with a linked subform. I have a text box on the main form allowing the user to enter data that they want to use to filter the form. This works fine when the field being filtered is on the main form. It does not work at all when the field being filtered is on the subform...

After your open a form with a recordsource, the data is pulled in from a table. Assuming that the table is located on a server and is not local to the database, if you use the filter command, does Access hit the table again to complete the filter request or is the processing done at the form...

I need to send automatic emails to different recipients based on data that has not changed for a certain amount of days. Most of the posts I have looked at in this forum are for the opposite - send an email when data has changed. Here is an example for my case: Field value = "Pending". If...

I am trying to customize a field code in my Word 2000 mail merge document so that the last name displays with an apostrophe + "s" if the last name does not end in "s", or it should display with just an apostrophe if the last name ends in "s". Example: If last name ends in "s", as in Simmons...

I set up a Mail Merge that will use Word 2000 as the front end and an Access 2000 query as the data source. The merge will be run from a command button on an Access form. Everything works fine, except when I use code to close the Mail Merge template without saving it, I'm still prompted to...

I need to check if a database is running from a specific drive and directory. I tried using the "CurDir" function, but that does not give me the path that the database is currently located in, it appears to give me the last path that it was located in or created in, but it does not change no...

I am unable to run a batch file using any of the following methods: 1) RunApp command in macro Action: RunApp Command Line: C:\CopyFile.bat 2) Shell command in module Shell "C:\CopyFile.bat" What am I missing. Does anyone have any suggestions? Thanks.