Search results

Thank You Sir, Adding the DAO prefix is fine however, I'm not clear as to where in the code should I insert your suggested modifications rnd give a number >= 0 and < 1 There is no X= 0 line.... Although this works its "Bad practice" [PS: I did not author this code and neither am I a...

I thought the prevoius attachment was ok....I guess not...soryy about that. Here's another attempt tp show you what I currently have selected for references. Pls tell me what you would like me to choose instead. Regards & Thanks for your patience Manu

Thanks, Attached is currently reference selections. What would you like me to change?

Thanks Wayne, Given I'm not the author of this code and neither do I have the expertise, would you kindly update the existing code so it can work in Access2000. Also, I tried your suggested priority settings etc...resulted in another error prompt [Compile error: Method or Data Member not...

The previous Nth Select related string was getting too long so I chose to start afresh. I can't seem to get either of the attached codes to work with Access 2000. These were working fine as long as I was using Access97. I've tried using "Dim dbs As DAO Database" instead of "Dim dbs As...

Getting Syntax Compile Error Attached is screenshot indicating your suggested syntax, however, it gives a compile error.... Manu

Screenshot Here's the screenshot

Here are the 2 codes Sub Runthething() changeYN 96 End Sub Sub changeYN(bytpercSel As Byte) Dim rst As Recordset Dim dbs As Database Dim x As Integer Dim lngTotalRecords As Long Dim lngNumToSet As Long Set dbs = CurrentDb dbs.Execute "UPDATE CEON_AGE SET chosen=False" Set rst =...

Getting errors with Access2000 Both codes [outlined in the attached message string] have worked very well for me as long as I was using Access97, however, I recently upgraded to Access 2000 and they don't seem to work anymore. Can someone help identify and correct the problem? All help is...

Thanks a million Fuzzygeek....it works like a charm It was quite dumb of me to not recognize that possibility.... Regards & a big thanks to all experts for promptly helping out...

Yes Mailman... I've tried your suggestion.... Attached are some screenshots indicating the code that I'm working with and results..... Regards,

Thanks Mailman, The code worked in debug window but the query still returns "undefined function" error even after adding the prefix of Public to the function. Your time and patience is appreciated....Pls advise possible next steps. Regards,

Thanks Mailman, The code did work in debug window [it removed the brackets] but the query still returns "undefined Function" error even after including the prefix of "Public" in the function..... Any further suggestions? Regards,

Hi Bob, Thanks for your promptness & patience.....I know this is frustrating because running the Update query after copy/paste of the entire previously posted code to a new module still yields the same result "undefined function" I hope this is not because of a silly oversight at my end....pls...

Hi Raskew, Attached are results based on your suggested method....pls advise next steps... Regards,

Gentlemen, Attached are some relevant screen shots to give you an idea of what I've done so far and the results..... Looking forward to your help so I can resolve this matter ASAP... Thanks a lot for yout patience & time Regards, Manu

Hi Fuzzygeek: Could you pls take a moment and respond to dcx693's question.....I would really aprreciate having the update query syntax that can take care of the brackets.... Thanks for your time in advance....

Thanks dcx693, This one seems to be a challenging one for me. I anticipate the ( or ) to occur at the same position in the string most of the time whereby could you pls send me the syntax for update query that I could run... regards & thanks for your time.....

Hi dcx693, Thanks for responding, however, could you pls help me construct your suggested query... Thanks for your time in advance.... Regards,

My Phone field has values like (626) 123 5555. How can I delete the brackets? All Help is appreciated