Search results for query: *

I have a problem with a database which I cant understand for the life of me, no tsure if anyone has experienced this, any suggestions woul dbe welcome. My database is not large its not complicated and there is nothing unusual It consists of a table and one query with names and addresses A...

HI I have a button on a form that will attach open outlook and attach a report. stDocName = "Report1" DoCmd.SendObject acReport, "Report1", "name@domain", , , "This week's report" how can I also attach a different file from my hard drive to the same...

I am building an Access 97 Database, The data I want is on SQL Server An SQL Query is run to extract the data I want The data is output to excel, I edit to suit and upload to Access I want to be able to have a query in Access that will get the data directly from SQL server. I copied the SQL...

I am building an Access 97 Database, The data I want is on SQL Server An SQL Query is run to extract the data I want The data is output to excel, I edit to suit and upload to Access I want to be able to have a query in Access that will get the data directly from SQL server. I copied the SQL...

HI I have partitioned my hard drive using WIn XP I have 4 partitions, what I want to do is merge 2 of the partitions. Can nthis be done without losing data? Thank you

Hi I send reports by email using outlook, everything works fine BUT When I send the report, the outlook email window opens, but, my default signature is not there At the moment I have my name coded as part of the message: DoCmd.SendObject acSendReport, "MyReport", acFormatXLS...

HI I have a macro that will set the print area and also print but, what if anything can I add to the code to set the printing to Manual Feed? Sub Macro1() ActiveSheet.PageSetup.PrintArea = "$A$1:$Q$44" ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True End Sub

Hi Can the code behind the dupliate button be modified to produce the following? What I would like to do is, once the duplicate button is clicked, duplicate the record a number of times depending on 'Quantity' field. Is it also possible that when the record is duplicated that the field...

HI Id it possible to ge the sum above other that = sum(A1:A20) for example?? My problem is this I have three columns that are used for calculation I J K and L if the word 'total' is typed in column I then column L will total whats above (L1 to L27 or what ever) if not then column L will...

HI I wonder if this can be done I hope so but I tried and tried without any joy the code is behind a button that outputs a report to excel what I want to do is squeeze a bit of code in that will change the excel page setup page to landscape here it is Private Sub Command5_Click() On...