hehe yupp i knew that much :P :P
thx anyway =D
ashitaka65
Last Activity: Nov 2 '07, 07:16 PM
Joined: Jul 31 '07
Location:
-
so there is no way to have it default to a certain cell then from there append to empty cells?
i have it exporting to a form that i must use and it has info on the top of the page then the body is empty then a place for signatur and date at the bottom of the page, i need to have it start at the 16th cell if not it starts at the end of the page after all the blank body and after the signatureLeave a comment:
-
i have a question about code you made me, say i wanted it to start on like the 16h line, so 16,A in my excel sheet, what would i need to change?
rivate Sub export_btn_Clic k()
Dim appExcel As Excel.Applicati on
Dim wkbWorkBook As Excel.Workbook
Dim wksSheet As Excel.Worksheet
Dim rngOutputTo As Excel.Range
' creates Excel application
Set appExcel = CreateObject("E xcel.Applicatio n")...Leave a comment:
-
ohhh wow that simple =D, hehe thx so muchLeave a comment:
-
removing warning msgs when deleting reccords
Hello,
I’m using
DoCmd.DoMenuIte m acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuIte m acFormBar, acEditMenu, 6, , acMenuVer70
in a line of code to delete the current record but when I do ,it asks me if I’m sure I want to delete it. is there a way to get rid of that warning msg and just delete the record?
Thank you in advance =D -
now ive fixed that, thank you again for all your help, you have been very amazing and i cant thank you enuff =DLeave a comment:
-
omg it works =D +D =D =D
thank you very much, you have made me very happy,
only a small problem with the coloms not being in the right order and i'm working on that now =DLeave a comment:
-
working on that now, gona give ur code a tryLeave a comment:
-
no i havent tried it,
so there would be no cmd i could use to export a line in a form to an excel file?Leave a comment:
-
then what cmd should i be using,
ive tried a few and cant seem to get one to workLeave a comment:
-
what do you mean?
i'm alittle confused.
listen if it cant be done or you cant help me then please just say it =DLeave a comment:
-
kinda, whats happening is it does export the one line of data,
but each time i hit the button it exports ontop of the old data, it wont append,
or wite on the second line insted of the first,
it just keeps writting on the first line of the excel file and replacing the old info insted of appendingLeave a comment:
-
i have left it blank..?
Private Sub export_btn_Clic k()
DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel9, "orderQ", "C:\Documen ts and Settings\RCTO\D esktop\orders\c urrentorder.xls ", True, ,
End SubLeave a comment:
-
whats wrong with what ive done? does it not append? is there no way to make it append?Leave a comment:
-
i'm sorry. i guess what it is is i'm having problems with it appending..
or i shuld say not appendingLeave a comment:
-
now the problem i am having is i want to be able to export to that same file multiple times and have it add the new records but what its doing is just replacing the same record over and over again so i can never export more then oneLeave a comment:
-
ok i will try that, =DLeave a comment:
-
DoCmd.OutputTo or Docmd. or DoCmd.TransferText
I'm trying to exort a single field from a form to an excel sheet and was wondering what cmd to use -
i do, but what i would really like to know is if there is a way to do it with the current record only and not the entire form, i cant get it to export the current record only insted of the full form.
ex. Private Sub export_btn_Clic k()
DoCmd.OutputTo acOutputForm, ****me.CurrentR ecord*****, acFormatXLS, "C:\Documen ts and Settings\RCTO\D esktop\orders\c urrentorder.xls ", n, , MS - DOS
End Sub
i want...Leave a comment:
-
i cant get it to export the current record only, not the entire sheetLeave a comment:
No activity results to display
Leave a comment: