Recent content by Kiwiman

=iferror(vlookup(E2,range-a,5,0),iferror(vlookup(E2,range-b,3,0),"")) Sent from my SM-G900F using Tapatalk

Thanks for your reply I will look into your suggestions The ultimate goal is to produce a trade route file (1 line per parent record) showing all child records across the page - each child record will have at least 30 fields. So the final output per parent record will be the parent fields +...

Thanks. Parent 3 only has 1 name (Andy) but 3 destinations (Albany, Malaga and Texas) in the child table. The examples I have given is rather simplistic as each route (the child record) will have at least 30 different fields, not just the ones shown (ID (autonumber - not required for output)...

Afternoon I am trying to denormalise a child table in a query for a specific task so that all child lines show on one line but the fields are not concatenated. Table1 - Parent PID Desc 1 Danny 2 Jonny 3 Andy Table2 - Child ID CID PID Destination 1...

Howzit You can also use dlookup: Mysheetpath = dlookup("Tracker_Link","Tbl_Tracker_Link_Details")

Howzit Sorry been rather busy. What I have always done is taken a dump of the data you want exported into excel (saved as a CSV file) first and "IMPORT" it into the database - in order to create an import specification (you can use this same import specification to export it out). Steps -...

Howzit I had a similar problem when using the TransferText method - all the dates were coming across as dd/mm/yy hh:mm - but I only wanted dd/mm/yy - and there was no time factor in the date. I got round this by changing the datatype in the import \ export specification I was using to export...

Howzit Qry1 simply adds the records fromtblRecords2 table to tblRecords1 - to ensure you can then populate the tblHistory1 table with the details in tblHistory2 relating to the newly added header record (tblRecords1), you map the RecID from tblRecords1 to a new field called Record2Id. Qry2...

Howzit Sorry been away all day. Attached is a simplifed version of what I would do. THis has your 4 objects plus 2 queries that first populate the tblRecords1 table then the tblHistory1 table with the data from the second set of tables.

Howzit What I would do is First and foremost take a back up Add a new column to tblRecords1 called Record2idAppend records from tblRecords2 to tblRecords1 but map the PK of tblRecords2 to the new field Record2Id this will cause the appended records to get their new PK number in line with...

Howzit I have a problem trying to add an Addin to an Addin ribbon, but the code will not remove the existing button first - so I end up with multiple buttons on the ribbon doing the same thing. I therefore have to manually delete these buttons. This is the code I have in the "ThisWorkbook"...

Howzit It looks like you have the grand total in the detail section of your subform not the footer or header section as Mimadocken said. As your subform is a datasheet the grandtotal will not be visible when you place it in the header/footer section. This is OK, as you will have a control on...

Howzit I am away on business and have limited access at the moment. Depending on how onerous it is on performance you can use multiple lookups to build the name. Something like strFName = DLookup("[Dlr_Code]", "99 - Dealer Email") strFName = strFName & DLookup("[orderno]", "99 - Dealer...

Howzit Yes you can retain whatever datatype that you want for your fields. In your form you specify which column in your lookup is bound to the field in your table and which field(s) are visible (by using the column width property) - you have pretty much done this already in your tableas you...

Howzit Personally, I never have lookups in tables (and a lot of users of this forum are of the same mind) as it makes it a lot harder to troubleshoot potential problems - such as these. I only put lookups in forms that will show exactly the same data as you want to see in the table. But iat...