Search results for query: *

Rick, I tried this code and it works great! Thanks again! Hopefully I'll get up to speed in VBA/Access (I'm a former PowerBuilder/Oracle developer) and soon be able to help others as you've helped me. Kathy

Thanks, Rick. I was afraid I'd have to do something like that. Bond numbers may or may not contain alphanumeric characters. If they do, the alphanum prefix is 1-3 characters long. So, I need to parse through each bondnumber and locate the start of the numeric portion, as well as the length...

Help! I have an alphanumeric, 10-character text field defined. It contains bond numbers which may be anywhere from 1 to 10 characters in length. The problem is the sort order. If I have bond numbers A1, A2, A11,A32, and A200 I would expect them to sort in this fashion. However, Access...

MichaelRed, I am aware that link is broken.. It wasn't supposed to be part of my message, but I pasted it in by mistake!! Must not have had enough caffiene in my system at that time. Kathy

Thank you, Rick. I"ll check it out. I did check Access help but not under the topics you suggest. Kathy

Hi, I want to check the success/failure of an INSERT INTO statement. I've checked 'ERR' but this does not pick up the status of the SQL statement itself. I have done this against other databases using different languages, but cannot find the code or reserved word to check this. Below is the...

I understand your suggestion, but it did not help. I still get the same error. I also removed Me!Combo83.Value and replaced it with "B299" (in double quotes), which is a valid class value on the Bondclass table. Still received the same error. Any other ideas? Or, there must be...

Hi, I'm new to VBA and cannot figure this one out. I'm sure it's quite simple and is probably a rookie error, so I'd appreciate any help. I'm executing the following code and get the 3065 run time error when I attempt it. The text of the error is "cannot execute a SELECT query&quot...