Search results

Hi, I have the following problem, I am trying to open an excel file from Access and then after is open going back to Access. I am able to open the Excel file but my database stays in the background while excel is in focus. I am using the following to open excel FollowHyperlink...

I need to output a query result as a text file. The format need it is the following "000005","12/18/70" (comma delimited)the first field is account # and the next is the Date account open, as you can see both need to be in text format. When I try to import the query result to a text file, when I...

I have a parameter query that feeds a form. I use 4 different fields that filter the records I want to show in the form. I am using a form (user will fill out criteria in form) to feed the criteria in the parameter query for the different fields used as filters using the format...

I have a form where I have two option groups. If I click one of the option groups it will make visible the second group option (set to not visible in properties). When I want to move to the next record I want to make the second option group not visible. I used the following...

Hi, I want to know if there is a way to change the mouse pointer to a hand when over a command button. I am using Access 97. Thanks

Hi, I am trying to merge multiple records from a subform to a Word document. I do not have any problems merging data from the form but when I tried to merge data from the subform only the first record is merged. I am using the following code: .ActiveDocument.Bookmarks("table").Select...

Trying to merge a field on a form to a word document using .ActiveDocument.Bookmarks("percentaccount").Select .Selection.Text = (CStr(Forms![freedeliver]![child86])) The field in question is a subform. I just get an error message. I want to know if there is any way to merge the...