Search results

Hello all: Thanks for all your numerous help. I posted this earlier, but got no response, your urgent help is required. I usually get 2 error messages on my form. When I set up the table, I made the date field mandatory. The first error message, error 3314, "The field 'Memo.Date' cannot...

Hi Scott, I don't even know why or how a linked table works. I don't know what a link table does. I did research the UNC but don't understand much of what was discussed. I do know my server name: Finance and share name: corp. \\Finance\Corp\CustomerFiles But the documents are all saved in...

Hello all: I have the following code to retrieve doucments: strPath = "G:\Corp\Customer Files\" Application.FollowHyperlink strPath & "\" & textbox1 & "-" & textbox2 & ".doc" This works fine from my computer because the shared drive on my computer is saved on the G drive. I tried using the...

Thanks guys, both worked.

Thanks. I have the tab order set. But to move to the next line in a text box, the hold shift key and enter does not work.

Hello all, Thanks to all the folks that have helped with my posts in the past. I have 2 questions. I have a form with textboxes. When I tab from one textbox to the other, the tab goes to one of the buttons on the page. How do I tab from one textbox to another. Also, I have a textbox for...

You're right again! Thanks John.

Hi Scott, Thanks a lot. I am getting a runtime error 490: Cannot open the specified file. And the Application.FollowHyperlink... is highlighted. My file is saved on my desktop as Novo Group-AA on my form, the 1st textbox name is textbox1, the 2nd textbox name is textbox2. Any idea why the...

Hello all, Do you have a code that would open a saved file based on the contents of 2 textboxes on my form. The saved files would be in: C:\Documents and Settings\100310257\Desktop I have a button on the form, but need a code that would pull up the savedfile using the name in textbox1 and the...

:) Thanks a lot John. This solves the problem!

Hi Alastair, It worked!!! I decided to use this: DoCmd.OutputTo acQuery, "qryFilterPostCodes", "MicrosoftExcel(*.xls)", "c:\ PostCodes.xls", True, "" Thanks so much for all your help, thanks for being patient!!!:)

Thanks Alastair, I am getting the same error: Microsoft Access can't save the output data to the file you've selected, any idea how to resolve this? The code you provided, does this save the xl file on the user's desktop? I don't want to use a temp file, is this possible, or do all the users...

Yes, I found the error, there was a space in my textbox name... One more question, if I wanted to have access put the file on the user's desktop, how would I change this line: ..................."c:\Temp\PostCodes.xls", True, ""

Hello, Thanks John and Alastair, the view code is working well now. Very grateful. One more question, if I wanted to have access put the file on the user's desktop, how would I change this line: ..................."c:\Temp\PostCodes.xls", True, "" I don't want a situation where the user...

Thanks again John, I don't know a whole lot in access but I will look at the query and the code to see if I can change the names e.t.c. The error I am getting with the export to excel is: Microsoft Access can't save the output data to the file you've selected, any idea how to resolve this? I...

Thanks John. I check the db you attached but it's not quite what I need. The query button on the form in your db ran fine, but the export to excel was giving a debug error or soemthing like that. On my form, there will be an account #. I don't want to have to create another form with a...

Thanks you so so much, it worked perfectly:)

What do I do in the case of this expression: Between Forms!QBF_Form!StartDate And Forms!QBF_Form!EndDate Or Forms!QBF_Form!StartDate Is Null What expression do I put in the newly created field? Thanks again.

What I mean is, when I click the button, it runs the Access Query, but then dumps the result in an Excel Spreadsheet.

Hello all, I am experiencing this error: "This expression is typed incorrectly or it is too complex to be evaluated….For example a numeric expression my contain too many complicated elements." I think the error is as a result of this expression in my query, I have 9 fields with the...