Search results

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

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

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

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

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

I have a main form with a listbox and text controls. Based on the selected item in the listbox, the text controls gets updated. I can go to a subform form by clicking a button in the mainform. After i return form the subform, for whatever record I select in the listbox, the textboxes show only...

we have used a lot of main forms and sub forms in our application. So, all the loaded forms appear in the task bar. The users are always tempted to switch between the forms using the form names in the task bar leading to disasterous results. How do I hide the main form when subform opens and I...

I have a MainForm that is associated with a table. The form has 15 control and most of them are text boxes and a few combo boxes are also there. I have a button that taked me to another form (Form2) My question is if I am adding a new record to the main form when will the data be updated...

I have a combobox in a form. If I select a value from the list, I check a checkbox. But when I delete the word that appears in the combobox by hightlighting and pressing delete, then the checkbox should be unchecked. SO, I wrote a change event associated with the combobox and did If...

I have a listbox that gets the data from a query. It is possible that the query doesnot return any rows. But when I double click the listbox, I need to check if there a row in the listbox. How do I check if a listbox is empty??

I have a form whose record source is a query. The form has a list of textbox and listbox controls. When I create a row in the listbox, I add a empty record in 2 tables. One is the table attached to the form itself and other TableB. When I type the data in all the textbox controls, I need to...

Dim CurDB As DAO.Database Dim MoveWorksheetTB As DAO.Recordset Set CurDB = CurrentDb() sqlQry = "SELECT * FROM MoveWorksheets WHERE MoveRequest_ID = [Forms]![EditMoveInfo]![MoveRequest_ID]" Set MoveWorksheetTB =...

In my company, the users use the MS access application. Sometimes, the users get the following error "You cancelled the previous operation". After I see such error, then I have to reinstall the GUI and the problem gets fixed. I dont know if it is the sequence in which they open the form causes...

I want to print the m/c name in the report's footer so that the users know to whom it belongs when they go to collect the print outs at the printer Is there a standard function to print the m/c name in the report footer? Thanks

I am getting an unrecognized database format once in 2 weeks. In my company around 45 users access the database that is replicated in each user's m/c. Then I have to Repair and compact the master database to fix the problem. Any ideas of why it is happening??

I am having a listbox in the report footer. I would like to change the row source of the listbox dynamically. Where should I add the code to specify the listbox rowsource. I tried adding the row source property in the reports's detail print and report footer print.. Nothing worked out...