Search results

Thanks again, as I mentioned this code runs well, except I get all the subtable records with each primary table record in a 1 to many relationship.:) Private Sub cmdPrint1_Click() Dim objWord As Word.Application Dim docm As Word.Document Dim db As DAO.Database Dim rstLandSales As...

Thank you for your response to my exporting problem. Sometimes I just need a direction or broad evaluation of my issues, so I can research further. I believe my issue in this case is the query design as you mentioned. I will study Chapter 10 from "MS Access Inside Out" Building Complex...

All seemed to be working well, however, I noticed that all my subtable records in the database are exporting with each Primary table record. In my output, i'm looking to see each primary table record followed by one or more subtable records from a one to many relationship. Thanks in advance...

JHB - Explain what you are trying perform. Hdata What I am trying to do is export data from the access database to a word document. Also, Problem solved. the ".Close" is the evil doer here. Once I moved this line outside the loop I was exporting the remaining subTable data. Thank you...

I have succeeded with retrieving subTable data from a One to many relationship, however, I'm stuck in an infinite loop processing the first record of the subtable and not moving to the next one. Any Help, Thanks in advance. Dim db As DAO.Database Dim rstLandData As DAO.Recordset Set db =...

My fix was to create a query based on the two tables (primary & subordinate table) then look at the SQL view and copy this code into my procedure and it worked fine. Thanks Paul. Next I want to export the multiple records from the sub table with a loop and eof clause. I may need help but I...

Paul, Thanks for your information and direction regarding joining my two tables in order to export my text. I tried to accomplish this yesterday and not sure why it did not work. I did not get an error, just no text was exported. I have Microsoft's Access 2010 Programmer's Reference book and...

I am trying to export text to a 2010 word document from an access 2010 database with DAO. I have successfully been able to export text from the main table tblLandSales via variables (below) and then subsequently a document. I used the following code: Dim objWord As Word.Application Dim docm As...

No, I cannot switch to a report, I am working with an access form, along with other text. The text data exports well, not the attachment.

I am trying to export an attachment item (Picture .jpg) to a word document. I have been exporting text to a word document successfully with below syntax " With rst strLandSalesID = Nz(.Fields("LandSalesID")) strPhotograph = Nz(.Fields("Attachments")) However, attachment do not work...

I am trying to retrieve the county name I keep in a lookup table. However, I can only get the number code for that county name and not the actual county name. I'm using the following syntax. strCounty = Nz(.Fields("fk_CountyID")) I use a main table with a lookup table called tblCounty...

I'm trying to run a word 2010 sub routine from the Access 2010 module. So far I have been able to launch a word document with attached word template from the Access module. I have many subs located in an attached word template which I have not been able to launch from Access. Any suggestions...

Greetings, (Access 2010) ON 9/10/13 I requested help with an embedded macro in a Microsoft sample database called the Student Database. In design view of the Student list form, I deleted the provided embedded macro on the ID field, and also the txtOpen field on this form so I could try to...

Thanks for your Welcome and input on this issue, and I believe I have done what you are saying. However, I must have missed something because when I view the form in design view, I don't get the txtOpen field with the function or the Open/New field from datasheet view. So the Embedded Macro...

Hello (Access 2010) My question relates to the sample database (Student Database) provided by Microsoft. Upon opening this database, a datasheet view of the student list appears and the first column includes an Open field which opens a detail form for input or a blank detail form for new...

I am an experienced commercial real estate appraiser with an interest in technology. I have used Microsoft office for many years, but fairly new to Access database.