Recent content by vbvbvbvb

I have developed an access DB for our organization. After completion I wanted my users to test the database(which have data entry forms, reports etc). Some of the users didn't have Access and some had an older version. So, my supervisor got the people to install the Access 2003 in all the...

Thank you for the response,Trevil. Its working fine if the control is a Text box. But I have a control which is a combo box. It doesn't has a "Can Grow" property . So, could anyone please tell me how to wrap the text for the combo box control on a report. Thank You

Hi, I am designing a Report in MS Access and it is having a lot of fields to fit in a page. I have a field called Location Name, whose length could be large for few records. But, I cannot set its width so long. Is there any way to wrap the text into next line (if it doesn't fit in its width)...

Hey Tony, You are superb. I was trying to achive this since yestersday morning. Thank you so much.

I am building the query at run time. If it were a stored query, I could build a form based on the query. But I am constructing the query at run time, and getting the required records in a recordset. Now, I need to show that records in datasheet view, just as we see the records when we click a...

Thanks for the response, Smith. Actually I do not mean Excel worksheet for datasheet view. I am talking about datasheet view of records in Access table/query. My requirement is - when a user fills in some date in Text boxes, and clicks a button, I use that data to create an SQL select query...

I am having a recordset containing result of a query. Could anyone please suggest a way to view that recordset in datasheet view. i.e., say, rs is the recordset object which contains the result of my query. I want to show the records in datasheet view, so that the users could see the records...

Thank you earthandfire. I am able to get the recordset for my query. Can you sugest a way to view that recordset in datasheet view. i.e., say, rs is the recordset object which contains the result of my query. I want to show the records in datasheet view, so that the users could see the records...

PHV, Thank you for responding. I have been trying to extract records using Recordset, but couldn't find a way to run select query. The only method I found to run select query is DoCmd.OpenQuery. But, it could be used only to run a stored query. I am taking input from user, and using those...

Hi All, I am unable to find out how to run a select query in VBA. I am building a select query based on the input given by the users through Text boxes on the Form(at run time). Then assigning it to a string variable, say strSQL. When the user fills in the Text boxes and clicks a button, I...