Recent content by odun

Thanks Jatz, I included the code you suggested, and it works great on one computer, but I am still getting error 3051, "the file already exists or you do not have permission to access the file", when I try it on another computer. Would you suggest reinstalling excel on the computer that is...

Hello all, I have this code that deletes a record from one of my forms, so I tried copying the code into another button to delete records on another form, but it's not working. The new button name is DeleteMgr I am not really sure how the code works. I tried using the wizard to create a...

Thanks, I tried that code, and I am getting error 3051 or something like that "the file already exists or you do not have permission to access the file"...so, not sure what is going on. But the code works perfectly on one computer but not on another computer, that's the dilema and both pcs have...

If you will be kind enough to explain what you mean, that will be great, otherwise, please don't bother to help if you're not willing to help all the way. Thanks again!

thanks Ian. I tried the code, but no excel file comes up and then I ran it again and it says the file already exists, but can't find it.

I hope someone can really help me with resolving this problem. Initially, I was having a runtime error 2302, "can't save file to the output selected", with the following code: Private Sub Export_Click() If IsNull(Me.CustNo2) Then MsgBox "You must have a valid Ship to Customer Number above"...

Hello all, I have the following code that exports my access query into an excel spreadsheet, but it does not open the excel file, it only saves it in my folder, how do I make the excel file open from that folder? Thanks for your help! DoCmd.TransferSpreadsheet acExport...

Hello, I just tried the formatxls and I am getting a runtime error 13: type mismatch. here is the code I used: Private Sub Command53_Click() DoCmd.OutputTo acFormatXLS, "QueryDetails", "MicrosoftExcel(*.xls)", "c:\Query Details.xls", True, "" End Sub

Thanks. Can you please help with the code for the transferspreadsheet function? Thanks again.

Hello all, I am getting this error when I use another machine, but it works fine on another machine, how do I ensure this code works on all machines: Private Sub Command53_Click() DoCmd.OutputTo acQuery, "QueryDetails", "MicrosoftExcel(*.xls)", "c:\ Query Details.xls", True, "" End Sub the...

Hi Fraser! Wow, this is one huge code for me. But thanks a lot. I am going to try to play with it and probably get some help. But just in case there is someone that can help me modify this code so that it suits my purpose exactly, my table name is: Address my query name is: Q1T1 my qbf form...

Hi thanks a lot, Do I write this in my query, or in a code? and how do I setup on the code? Thanks again!

Hello all, How do I write a QBF query such that when a check box on the form is clicked, the name of query runs based on the name of that checkbox. I have a form called, QBF_Form, which has a series of checkboxes. Each checkbox has a name. I have a table, "Type", and I would like to run a...

Hello all, I have a table in access and one of the fields (date) has a default value of =now(). I have an excel spreadsheet that has all the fields in the access table inlcuding the date column (but the column is not populated). When I import the spreadsheet into access, I get some...

Thanks again: Here is the sql in the textbox: select * from customers Where Ship_to_ In ("ca","fl") When I type in: ca or fl I copied and pasted: In ("ca","fl") in one of the queries and it worked, but it's not working through my form, so I think I should backtrack a little. I have a...