Recent content by SAK

Hi, I was googling for a solution and I found an incidental post you made on launching Outlook via VB code. While my VB coding background is only incidental I was able to grasp what you posted and not only integrated it as a function in Access but a macro in Outlook. Actually your post opened...

Unmatched Query with Several Fields After a bit of obsessing over this for a while, and plugging in different code permutations I finally hit on what I needed: :cool: SELECT tblAllMembers.* FROM tblAllMembers LEFT JOIN qrySeekbyGroup ON (tblAllMembers.Address1 = qrySeekbyGroup.[Mailing...

Hello, My task is to compare our master membership table with a second table, removing matching names in the second table from the master table. (The second table are those individuals who chose not to receive a paper newsletter, so we want to save money and trees :) and not send them one.)...

Cleaning up data Yes, I am considering some routine that would address just what you said, and not delete wanted spaces, such in street address text strings. Thanks for the discussion, it helped me understand this situation a bit better.

Replace Function Thanks, I modified my SQL and that did the trick. I'd like to take this a bit further, and if someone has the insight as to why this occurs, I'd like to know. This particular database I run, I get/maintain updates by exporting specific portions of the data to Excel and...

Replace Function Hello, as follows, I need help with the syntax to identify an ASCII character. I am attempting the replace functions using SQL, however my attempts are not working. How is the ASC part entered so the replace function will find it properly. Here's my SQL: SELECT...

Does Blank = [Space]? Thanks Pat, I ran that and got back the value of 160, which I looked up and that is [space]. This aspect of coding is new to me, is a space = to a blank in this case? If not, I need to come up with a way to trim the [space] from the front of some fields and the back...

Trim Issues Doc Man, thanks for responding. One of the uses for the data is that it's exported out to our commercial newsletter mailer, and I found that the cleaner I send the data, the less they tend to screw things up... ;) Thus I want to pursue the TRIM() issue. I set up an update query...

Hello, need help with the Trim() function. In a query I am using this SQL: SELECT TRIM(tblAllMembers.First_Name), tblAllMembers.Middle_Name, TRIM(tblAllMembers.Last_Name), tblAllMembers.Address1, tblAllMembers.Address2, tblAllMembers.City, tblAllMembers.StateOrProvince...

And let there be light Finally. Thanks charityg, for the code: the 2K version module was something I needed to see. Accessing a recordset via code has been on my list of things to bone up on and voila, here we go. The proverbial lightbulb went on, and I see all sorts of uses for this in my...

Howdy, I did some searching here and see where Pat Hartman advised someone that Access doesn't support relative file paths for certain purposes. But probably somewhere in VBA coding, there's a solution to what I want to accomplish. Maybe? Here's my situation. For my coworkers, I am devolping...

App Launch ghudson, thanks much for your help, I was encouraged to keep digging by your communications. Now I have another related question, and I think I will start a new post on this one. Now I need to get that file name into "relative" file path, not on a server but to allow burning the...

May I " you on that? Found elsewhere herein the coding solution to my question.... Needed more quotes. Option Compare Database Option Explicit Public Function RunArcMap() Call Shell("C:\arcgis\arcexe83\bin\ArcMap.exe ""C:\Documents and Settings\skleiner\My...

Launch App ghudson, very observant. I tried using the actual directory string, with spaces in Win XP Pro, and the error message never even got close to the actual path, and showed the file string error as c:\Document.mxd. Taking a stab, I added the underscores to and got, at the least, an...

Run Shell ghudson, if you're out there, I'd like to follow up where I left off wherein I am trying to launch an ArcMap application and a specific file to that app. I run the following code and get an error message that the file can not be found. The code I used is: Public Function...