Search results

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

If you defined the variable within the Form module then the variable will only be global within the Form. If you define the variable in a Global module. Then it will retain it's value until you quit the current database. (i.e. Create a new module from the Module page and define your global...

Here's one way... It's in my Global Module that will return the number of records in a recordset (meaning, a table or valid sql statement) Public Function ReturnRecordCount(aRecordset As String) As Long On Error GoTo ErrorHandling Dim dbs As Database Dim rst As Recordset Dim...

When you create a Subprocedure or a function what you want to do is trap errors if any would result as in your case... Here is how to do it generically... Private Sub AnySubOrFunction() On Error Goto ErrorHandling write some code . . . Exit_AnySubOrFunction: Exit Sub ErrorHandling: if...

Are the fields the Name of a school? If so, why not try it another way, instead of having a table with 1 row, why don't you have a table with two fields... the name of the school and the other field containing the yes/no response... with 100 records. Step 1: Creating the table Lets just call...

Hello, I don't have access in front of me but I hope I can shed some light in the matter. 1) Since you are using a form to retrieve responses from a user then you should have a corresponding Table that will hold the values. 2) Now go to the Reports section and use the Reports autowizard...