Recent content by alr0

Thanks Remou, This is very helpful. I was hoping for a more general solution that would find all characters that show up as square boxes without listing each ascii character. Any thoughts? Thanks, alr _____________________________________ There is no rule more invariable than that we are...

Hi All, We have been receiving data for mailing lists in Excel spreadsheets that have a line feed or carriage returns (chr 10 or 13, I believe) When imported into Access the character appears as a square box like many unprintable or foreign characters. I need to alert operators to the presence...

I never thought about importing formatted components from Word. I have never used bookmarks but I will look into this. Thanks, alr _____________________________________ There is no rule more invariable than that we are paid for our suspicions by finding out what we expected. Henry David Thoreau

Hi All, I need to produce professional looking merged letters that are driven by and display data from tables. Some of this is simply conditional formatting but the more complex part is displaying certain records in a one-to-many table that are flagged with a descriptive paragraph. Access...

Hi All, I need to produce professional looking merged letters that are driven by and display SQL Server data. Some of this is simply conditional formatting but the more complex part is displaying certain records in a one-to-many table that are flagged with a descriptive paragraph. Access...

Thanks Remou, Environ("username") worked just fine. Are there circumstances where it would be advisable to use the API? Thanks again, alr _____________________________________ There is no rule more invariable than that we are paid for our suspicions by finding out what we expected. Henry...

I'm sorry, Widows user logon. alr _____________________________________ There is no rule more invariable than that we are paid for our suspicions by finding out what we expected. Henry David Thoreau

Hi All, I want to add a field to an Access 03 table that records the user logon that added a record. I thought I had used GetUser in the past but neither the help or knowledge base had that phrase or others I tried. Isn't there an easy way to trap the user logon? Thanks, alr...

Thank you both, PHVs suggestion did work but this point in the code was way before I had the breakpoint for debugging. Another piece of very useful information to squirrel away. Thanks again, alr _____________________________________ There is no rule more invariable than that we are paid...

Hi All, I added a new feature to a production application (Access 03). Everything works as expected except, the first time you use it, the code window opens to the "If" staement below. If I hit F5, it runs perfectly. All break points have been cleared yet this continues to happen intermitently...

Thanks pwise, I would never have tried that! Is there a particulare theory behind that method? Thanks, alr _____________________________________ There is no rule more invariable than that we are paid for our suspicions by finding out what we expected. Henry David Thoreau

Hi All, I have tried: DCount("[searchLname]", "prepsearch", "IsNull([SearchLname])") DCount("[searchLname]", "prepsearch", "[SearchLname]=null") DCount("[searchLname]", "prepsearch", "Len([SearchLname]) < 1") ...as well as several different concatenations. I could not find specific...

Thanks to all and especially: Keith: the code worked the first time and it is instructive to see some other ways to combine these tools. It is a little slower than with the GoTos. I wonder in terms of speed if calling another functions isn't similar to a GoTo? This quote that JoeAtWork...

I just got this working so I apologize, it has yet to be cleaned up and I have never used the code window for display here and did not see any instructions for it. I understand the maintainability issue and it is real. In a case where there is one statement (GoTo nextCsz) used several times it...

Hi Orgi, Case is certainly useful but if three varibles are involved I am not sure it would work. Nesting them does not seem useful. Perhaps GoTo is sometimes justified but it would depend on the execution time of finding the target and moving control. It could be much slower than other...