Search results for query: *

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...

...the record type or the record source property of the list box? Is there soemthing else that I need to do? Please, your ideas are solicited. ****strafter, strbefore and strnull are different strings storing parts of the search text depending on the location of the wild card character(e.g...

...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 '" _ & strBefore & Forms!Form1!Text0 & strAfter & "'" in the row source it gives me an error and when I...

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?

...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 went ahead and did some thing like this...

...enter the search criteria for the directory search" Exit Sub End If End If If Not IsNull(Me.Text0) Then strSQL = "SELECT * FROM directory WHERE last_name LIKE '" & Forms!Form1!Text0 & "%';" 'display the strSQL that goes with the SQL MsgBox (strSQL)...

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

...' Mylen = Len(Customer) 'If Mylen >= 2 Then 'strsql2 = Mid(strtext, 2, 3) 'strtext = Mid(Me.Text0(1, 1)) 'If strtext = "*" Then strSQL = "select * FROM directory WHERE last_name LIKE " & Forms!Form1!Text0 & ";" 'display the strSQL that goes with the QL...

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

The default value for the text box is 12:00 PM.I want it to be highlighted in red when the default value is indicated in the text box. Once the user enters any other value the font color should be black. Regards, Info

Hello: I am trying to format a text box. Incase the time is bigger than a certain window (7:00 AM-5:00 PM), I want it to be indicated in some different color. How do I accomplish this using the conditional formatting made available in Access2k? Suggestions and ideas are solicited. Regards, Info

Hi: Thank you for your inputs. I am actually looking at two copies of the same form but each of the two copies includes different data. So how do I accomplish that? Regards, Info

Hi: Thank you for responding to my inquiry. Let me qualify my request little better. I have two forms, say form 1 and form 2. Form 1 houses customer records. As I select form 1 by clicking on a particular ID, I want form 2 to pop up with the ID transferred to form 2. Also as I select another...

Hi: I am working on a database to enter customer data. In my previous thread I had asked for information about ways to transfer information from one form to another. I did manage to figure it out. I was wondering as to whether there is a way by which I can have multiple instances of the same...