Recent content by infoscion

Hi All, I am getting this error message "Run time error 3709" ----Requested operation requires an OLE DB session Object which is not supported by the current provider." The code stops at the execution of the query which will write the record to the table. any inputs will be appreciated...

PHV: Thank you for your tips. What is required is that you need to include the "AddItem" to the following statement. Forms!searchnames!SelectCode.RowSource = strSQL The correct syntax to achive this is Forms!searchnames!SelectCode AddItem strSQL Having included the AddItem term, the code runs...

Hi All: I am working on a way to display results of a search. The user enters the search criteria in the form named form1. Depending upon the entry made often dictated by the location of the wild card charcter a set of different SQL statements are executed. I was wondering as to how do I...

Hi PHV: I have another follow up question for you. Do you want me to include the query in the row source property of the list box or in the VBA code that drives the form. When I include the query [name of new listbox].RowSource = "SELECT * FROM directory WHERE last_name LIKE '" _ &...

PHV: I do really appreciate your help. I do have a follow up question. The wild card character could precede or follow the search criteria. Please correct me as to how do I handle the varibaility introduced through the location of the wild card character. I want the system to be flexible such...

PHV: Thanks for your inputs Regards, Info I was curious as to how do you assign a null value to a string?

PHV: Thank you for your inputs. I understand that I could do something like that. But the issue at least I think is that it wont be in a position to handle the wild card character(like a * or some thing). To include the wild card character I think I need to write the VBA code for it. Also, I...

PHV: Thank you for your inputs. If I have a list box can I transfer the results of a query to it? This is the code that I have so far:How do I tie in the results of the recordset with those of the entries for the list box that is there on the form that I am opening? Regards, Info Private Sub...

Hi All: I am attempting to implement a search application. Depending upon the number of records pulled up by the SQL query I would like to create corresponding number of text boxes on a new form. Please advise me as to how do I achieve this? Thanks Info

Hi: TABLE directory includes lastnames, first names and the addresses of the customers. Here is part of the code. What I am trying to accomplish is that once the user enters a text message the SQL query is run. So depending upon the selection a number of records will be pulled. Please bear in...

Thanks for your inputs. But can I get some specifics about the display as to how do I transfer the contents to the sub form, especially when the number of records in the recordset is variable. Info

Hi All: I am in the process of developing a very simple search application. However, I have run into a few road blocks. Firstly, I was wondering as to how to include wild card characters to search for records. I know I can achieve that by using the LIKE criteria of SQL. Secondly, more...

Hi: Thank you for forwarding me the code. Just wondering, should it it be a SELECT statement or be an INSERT statement in the SQL code. Also, how does the statement rs![Field1] = Me.Controls(X).Value, help us? Regards, Info

Hi All: I am working on an Access form. The form has multiple text boxes. At the bottom of the from is a add button that transfers the data onto a underlying table. I want the contents of each of the text boxes to be appended to the underlying table as a separate record at the click of the add...

Hi: This is a continuous form. Also with some code, if Me.text0.value=svalue then me.text0.forecolor=vbred Now it is working. Thank you very much for your help. Many Thanks Info