Recent content by jamie_b

Solved by @Minty. Thanks mate. You make it look so easy. Your solution worked since all the records now exports to the docx table - but only if the docx table has enough pre-formatted (pre-defined) number of rows to hold the number of records it will receive from access. Which of course is...

Thank you. That makes perfect sense. Looking into it now. Will post back when I have found a solution.

Hi, In my Word docx file is an existing table, formatted with a header row. The code below works correctly (to a point) by transferring the recordset to the already opened docx and populating the the table with the SQL from vba, starting in the 2nd row onwards. No errors are shown, but the...

Thanks for this. I will give it a try or see how I can incorporate it in my situatation. Will post back with results.

Hi, just looking for ideas if anyone is interested... In Access 2013 I export certain form fields to a Word docx file which has predefined Bookmarks. This works perfectly well. Like so: 'code for Dims and Strings etc 'code for defining path, docx name etc 'then this: With myDoc...

SOLVED by @JHB Your solution worked perfectly. Thank you very much.

Good day. I have the following function that does this: - Opens a MS Word Template with form fields. - Fills the Word form fields with the data from the access form. This works as expected: Function FillReport() Dim appword As Word.Application Dim doc As Word.Document Dim path As String...

Yes, I was going to get around to storing the client detail in a separate table. Thanks for your help.

Thanks. I'm not sure I understand but here goes: Table structure: PK clientName question response Example: Table_Row_1 = 1 | John | Q1 | ABC Table_Row_2 = 2 | John | Q2 | ABC Table_Row_3 = 3 | John | Q3 | DEF Query result: John ABC = 2 John DEF = 1 Is this what you mean ?

Hi, I know this should be so easy, yet I have a mental block on this at the moment. Please help. tbl_myTable: Columns/Fields: - pkID (primary auto), - clientName (text), - q1 (text) - can only be "ABC" or "DEF" (from form's radio button group), - q2 (text) - can only be "ABC" or "DEF" (from...

Thank you. The hint I was looking for is "left join". I did have the Join, but in Join Properties I had Option1 selected - (fields from both tables is the same). Instead of Option 2 (all records from 'related table'). I should have checked that. I'm just having one of those days... Thanks again.

Greetings, Forgive me for being lazy today. Lack of sleep coupled to age... One to Many tables: tbl_Doctors - Main Table : PK is doc_ID tbl_Patients - Related Table : PK is pat_ID and 'related key' is docpat_ID Dr. John has 3 Patients Dr. Sam has 7 Patients Dr. Andrew has "No Patients" IE...

Hi, I have tested this http://access.mvps.org/access/tables/tbl0009.htm and with some changes to suit my needs, it works as it should. The above is obviously the better (and fail-safe) option, as pointed out by CJ_London: However, on my network, in the users' Logon Script, it will always map...

Or just a usb drive with it's drive letter changed to X: - and the appropriate folders. So easy. Absolutely Brilliant mate ! Thank you big time. This is all I required. I tested spikepl's solution on network and it works as expected. Thanks again. Kind regards, Jamie.

So what you are saying is, IF I was to use the linked table manager function, then I can only do so from my development pc, and choose the option "always prompt for new location". This means the user will be prompted for the backend location, right ? This is exactly what I DO NOT want. I do...