Recent content by gdanalakshmi

I am using VBA to create a Word Document. I want to insert a hypertext string into the Word document. How Do I create a new file(a new Word document) with the string inserted into it?? Advanced Thanks Lakshmi

I am trying to send an email from Access application using VBA. I want to send a hyperlink in the body of the email. The Email goes through Lotus Notes. How Do i implement that?? Is there any special tag for that??

Thanks.....

I have a textbox control that has the data which is to be in the format nnn-nnn-nnnA including the dashes. The last field in the Mail Code may be 3 or 4 characters. How do I do that???

I am trying to do a validation for a text box control. I have written code in Private Sub Last_Name_Exit(Cancel As Integer) Dim TrimmedStr As String If Len(Me.Last_Name) > 0 Then TrimmedStr = Trim(Me.Last_Name) Me.Last_Name = TrimmedStr Me.Refresh If...

When I try your statment , I get the following error... The object doesnot contain the Automation Object Me.Group_ID

I am using a DLookup function in my code It is like this Dim varX As Variant varX = DLookup(GroupToGroupMember.GroupMember_ID, GroupToGroupMember, _ GroupToGroupMember.Group_ID = CDbl(Me.Group_ID) And _ GroupToGroupMember.GroupMember_ID =...

If I am declaring one by one, then I have to write a line for each assignment. Is there not any one line assignment separated by comma's???

Dim ProcessNames(1 To 10, 1 To 10) As String ProcessNames = {{"New Standard Churn","11"},{"Churn (No Voice)","11"}} I am getting a syntax error?? I am not able to figure it out??

I have done a dynamic crosstab report. But this case is totally different. I have a table generated dynamically in my program, and my I trying to feed the table to the report. After the report is printed ,, I then delete the table since I will need it no longer. I donot know how to print all...

I have a table whose data I want to feed to a report. I am doing it through the code since the table is generated dynamically. I am able to print only the last record, & not the previous records. How do i display all the records?

I have created a temporary table whose data I am feeding to a report. In the report_open method, I am doing like this Private Sub Report_Open(Cancel As Integer) Dim intX As Integer Dim DB As DAO.Database Dim qdf As Recordset Set DB = CurrentDb Set mrstReport =...

In our company, we have 40 users and we use replication to sysnchronize with the main database. One of the users is getting this message while synchronising.. Error Number is -2147467259 Error Description The field is too small to accept the amount of data you attempted to add. Try inserting...

DId you come up with a solution to do this?

I need to generate a report. But I know the number of rows that appear in the report. I need to run a different query to generate each row in the report. My question is should I create a temporary table and then feed the table to the datasource of the report or is there any another better way...