Search results

help Hi, I was trying to run your example but when the form opens to ask me for the password I get the error message undefined getusername function. If I press ok I can go to the form but no User Name is fill and I can not update the field, if I try the password, I get incorrect password...

Hi, The problem is that I need to import a file from excel and it has more that 16000 rows. I have Access 97 and when I import the file, the file gets cut in 16000 records, this is a bug with access 97 and the only way to overcome this is by having the excel file open. So I wanted to open excel...

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

Thanks for the help and I will stop using Date as a field name. It works great the problem was that I was using Output to instead of TransferText. Take care

Here is the sql SELECT JAM.[Account #], Format([first day activity],"mm/dd/yy") AS [Date] FROM JAM; Thanks

Hi, I tried that but in the ouput file still shows up as date field

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

Thanks, works great

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

Thanks works great

Do I need to put the same code in the On current event in the Form properties. I used the code in the On click event in the properties of the Next buttom

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

Thanks for the help, works great.

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

Now I have another problem. I have multiple records in the subform but when I merge it to Word only the first record is merged. How I can show all the records from the subform

Thanks for the help.

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