Search results for query: *

Hello Change your rs.open statement to ssql = "Select * from QryTest" rs.open ssql, cn See if this works Anu.

Hello, I am trying to find the last set of children for a tree view control to change the image of the nodes for the last set of children. Can anyone please help me?

Hi Warren, Why don't you try this way.. in the Update query before you call the FindReplace function Declare a string variable Dim str as string str = [Table]![Address] FindReplace(str,"-","*") I hope it works

Hi Anna, Why don't you do a autofit in excel and then copy the word into word? Radha

Hi, If I have understood your question right you can get rid of the toolbar by going to View menu, select toolbars and deselect the standard. I hope this helps

Thanks for your reply but it hasn't really helped me. I have six tabs Membership History, Courses, Additional Information etc. When the form opens it is fine but when I click on Membership History tab the form moves to the left side of screen. To see the complete form I have to scroll down or...

Hi Thanks for the reply. I do have scroll bars on the form. I tried to change the width of the form but it does not accept it. After changing the Autoresize property to No, I still have no control on the width property of the form. Looking forward for a reply

I had this thread for some time in Access Forms but I had no reply. I have a main form in which there are 6 tab control pages with a subform each. When I click on the tab controls the whole form jumps. Can anyone please help me with this. Thanks a lot

Hi there, Depending on the field you are searching on create a recordset and use the seek method to locate the record. Use if statement and nomatch property to update the record in the table if not found. with the help of the input box get the information from the user and store it in a string...

Hi, I am in the process of creating a membership database for our company. My main form has 6 separate tab control each of which has a subform in it. The problem is when I click on the tab controls one at a time the main form moves up and down. Could you please help me to fix this problem...

Hi Nathan Thanks a lot for your help. Your suggestion about the debugging tools and your code has really helped me go a long way with my database. When I added the code Debug.Print the immediate window showed me 1. So I changed the code to Case 1 and Case 2 and it works now. Once again thanks...

Hi Nathan, Thanks for getting back to my question. Following is the copy of the code that I inserted into the Onclick property of the OpenReport command button. I named the list box list0 and currently I have two cases in my list box. (1) nutpan + Label Format.dot and (2) amylose.dot When I...

Hi Nathan I copied the code into the command button and named the list box as list0. Definetely I didn't forget to change the path of the file but still when I click the button theword template does not open. Instead if I comment out the select statement in the code it works. Can you please help...

Hi nathan1967 Thank a lot. I will try it and let you know how it goes aradha

Please help me. I have lot of templates in word which I would like to open when selected from a list box. I am new to access and would like help in writing the code for this. Thank you very much in advance.