Search results for query: *

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

How are you Aceman1, I accept your invitation and the code I am working on is a good example: I have a City, State, Zip line from an address label and need to copy it to city, state, and zip fields if it is USPS address or all to FCountry if not. I have the line parsed into words in an array...

Hi All, As long as I can remember, GoTo was considered bad coding and was to be avoided. I have used them whenever the circumstances seemed to call for it with no known problems. When stepping through a recordset, once a record has all of the processing needed I may be skipping 20 to 50 lines...

Hi All, Thanks to Tarnish and Allen Browne we have a new City, State, Zip splitter that does a better job for our needs than Right Fielder and does not require exporting data to DBFs. It is a little slower running but that time is more than made up in other ways. When data is returned from the...

Hi PHV, Actually there are several ways that users can add records to this table and I would like to be certain that this field is populated no matter how records are added. Can this be done with a public variable or must it be done programmatically after all records are supposed to have been...

Hi All, I want to set the default value of a table field to the contents of a form control. I keep getting an error that the form control cannot be found. Is this possible or do I need another way to populate the field. Thanks, alr _____________________________________ There is no rule more...