Recent content by Motion

Opening a Word Document within CURRENT Word Application - SOLVED! Hi there I am using the following code to open a Word Document: Set oWord = CreateObject("Word.Application") Set oDoc = oWord.Documents.Add(strHeaderLocation) The problem is that each time a Word document is opened, it...

I have just checked and the accounting software does seem to recognise the row of commas as line (sorry should of checked this first). My problem is solved. Thanks for everyone's help. Richard

Sorry, I should have explained further. I am needing to export invoice data from an access database to an accounting account programme (see my thread here: http://www.access-programmers.co.uk/forums/showthread.php?t=147842 ) and am using the DoCmd.TranserText method. I need a blank row to...

Hi there I have data in a table that reads: 1 1 1 1 2 2 2 3 3 I would like to insert a blank row between each block of data ie: 1 1 1 1 2 2 2 3 3 I have a query (called qryDifferences)that counts the rows of each group, somehow i now need to use the recordset method to insert a blank row...

Thanks for that, that's the answer i was looking for - and there are no pk's in the data. Thanks!

Hi all I am using the DoCmd.TransferText command to export a query to a text file for the purpose of exporting invoice information from an access databse to an accounting programme. Everything is working fine except that after every invoice number there needs to be blank row so the accounting...

Hi all I am currently using the following code to reconnect linked tables in the back end but cannot seem to establish the correct method to incorporate a password into the code. The password is needed as the backend has a database password. I want to keep the same password each time and i...

Thanks for that Bob, problem solved.

Hey I am really stuck on this one: ?DCount("[HolidayID]", "tblHolidays", "[HolidayDate] BETWEEN #" & Format(dteTheDate2, "mm/dd/yyyy") & "# AND #10/31/2007#") dteTheDate2 is a variable. Has anybody got any ideas? Thanks in advance. Richard

My whole reason for needing data in that field was because i needed a record in the subform. If there is an easier way to do it i'm all for it. I will search DAO, ADO, and Append query and see how i get on. Thanks for your help. Cheers

Hi all I have just spent 2 hours on the search function trying to solve my problem and have tried 2 solutions that have half worked but still haven't worked properly. I have a main form with a linked subform. On my sub form i have a field 'Date of first appointment'. Currently users can just...