Search results for query: *

Thanks for the reply, Yes I tried that but same result The strange thing is If I remove the [enter Id] from the criteria in the query then the word doc opens and the first record is merged, I can then search from Word and get the address I want. That is a workaround but I would like the...

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

Thanks ChiTownDiva I'm not really sure about First, Pass-Through but I will give it a good go I dont have access to the sequal server but dohavethecode that was used to get the data I will work at it till it works Thanks

Thanks ChiTownDiva I'm not really sure about First, Pass-Through but I will give it a good go I dont have access to the sequal server but dohavethecode that was used to get the data I will work at it till it works Thanks

Sorry for the double post accident!

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

Thank you very much Katerine I am working with it but so far not much is happening Trouble is Im just beginning to lear n access and I think my ideas surpas my skills by a lolng way but I'm keen willing to learn and best of all enjoying it thanks again :)

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