Recent content by tc3of4

thanks david, guess i'm going to have to use ADO and DAO together on this one tc3of4

I guess I should have put more information I've written dynamic queries through code. but they are SELECT queries and the docmd.runsql will only run ACTION queries. So how do I view the results of a SELECT query (that was created through code) thanks tc3of4

docmd.runsql only works with an action query how do I view a SELECT query tc3of4

okay here it is... Private Sub RunDynamicQuery() Dim sPeriod As String Dim sTransType As String Dim sStatus As String Dim sRevFlag As String Dim sTransOrigin As String Dim sBN As String Dim sReport As String Dim sqlString As String sPeriod =...

I tried it that way but no luck...

with the above I binded the sql statement to a string dim sqlstring as string sqlstring = "sql statement above" docmd.runsql sqlstring [This message has been edited by tc3of4 (edited 05-02-2002).]

in access xp tried using docmd.runsql sqlstring sqlstring is a valid statement but access keeps giving me error message runsql requiers valid sql statement i.e. SELECT Report1_MAY0102_025148.Period, Report1_MAY0102_025148.BN, Report1_MAY0102_025148.Name, Report1_MAY0102_025148.TransType...

front end: Access XP backend: Oracle 8i Question: Using running a query which has a criteria that is populated by a textbox from a form. this is the easy part. My confusion is when a user enters a wildcard "*" the query looks somewhat like this Like form![field] so if they enter a wild...

found it.... can delete this post

You can catch the error. I think it's 2501 so you can have something like this -- in your event procedure for the button private sub movePrevious() on error goto error_handler ... end_here: exit sub error_handler: if err.number = 2501 then '/** do nothing else goto end_here end if...

Was posted here once but can't seem to find it. tc3of4

This is more than what I require... Thank you very much... Will be able to do a lot of things which I was too lazy to think about once again thanks for the prompt response tc3of4

Any help would be appreciated. tc3of4

Here's one way... Object: TextBox Name: txt_NewPassword '/** Just in case they leave the text box without entering the right length Private Sub txt_NewPassword_LostFocus() '/** If nothing entered then don't worry about it If (Len(txt_NewPassword.Text) = 0) Then Exit Sub...

try this docmd.setwarnings false docmd.cancelevent docmd.setwarnings true tc3of4