Recent content by pteare

thanks for that. Okay if a list box in a subform is all that's realistic I'll go re-think the data structure. Alas it's not quite what I need in this case, but thanks still for the time, good to know what's possible. Thanks, Phil.

Hello, thanks for that. I'm trying to avoid the subform system, thanks though. I'm looking for a checkbox UI. For example the built-in system for allowing multiselect would be okay: The problem with that would be that you can only do it with internal tables - I cannot get it to work when...

Thanks for the reply. That videos just shows me how to setup the junction table. I'm happy with all that side. My problem is what to do next - how to use that data structure to make a checkbox type UI? Thanks.

Hello, Just a quick question on the best way to attack many to many joins. I've a table of Tour Operators, and a table of Countries. I'd like a many-to-many join between them. I'm using access only as a front end, the tables themselves will be on a SQL server. I'm struggling to get a decent...

It's 2013 that's causing the issue (not sure if that was just a typo) Yes I've tried it on 3 machines running 2013, all have the same issue.

thanks for that. Alas no luck! This is a strange one with it being inconsistent. There are lots of places it sets the Text value of the TextRange. Sometimes the first one fails, sometimes a few succeed then it fails, and very occasionally it runs all the way through successfully.

Hello, I tried declaring new_row as object and as variant, still the same error persists. The PowerPoint objects are declared as Global Variables: Public oPPTApp As PowerPoint.Application Public oPPTPres As PowerPoint.Presentation then the below code opens the powerpoint template &...

Hello, thanks for that. I can't upload the file sorry, this database belongs to a client you see. I didn't build it, just trying to de-bug, fun fun! There's a powerpoint template it uses - it just looks at the slides on this template file then finds the table it needs. This happens in a...

Thanks for the reply. That would be wonderful if you could look over it and amend, thanks. Here's the code: Private Sub AddRowInFilterTable(current_table As PowerPoint.Table, current_category As Integer) Dim new_row As PowerPoint.Row Dim str_cat As String On Error GoTo...

Thanks for that. I'm running the code from within Access 2013 I tried putting .Text on the end of that line - that made it work just once, and 2nd time I tried to run it the error came back again.

Hello, Thanks for the reply. It compiles all okay both ways. Issue comes when the code runs later on: e.g. Dim new_row As PowerPoint.Row new_row.Cells(1).shape.TextFrame.TextRange = "something" It will give me an error - -2147417851 : Method 'Text' of object 'TextRange' failed Please...

Hello, I'm struggling with some VBA code Take this line: Dim new_row As PowerPoint.Row If I right click on "PowerPoint" and go to "Definition" then it finds it all okay in the object browser (I've included the reference to the Powerpoint 15.0 Library) If I do the same for "Row" then it...

thanks for the reply. I've put in that where 1 = 0, good idea there thanks. my other problem turned out to be a typo. so sorry to take your time with that. I'd spent ages working on it as well! When I was putting in the "where 1 = 0" bit the typo caught my eye. thanks again for your help.

Hello, I'm strugging with recordsets. I have two tables - a table of People, and a table of correspondence messages. When I'm trying to do is go through each person and add a new correspondence message for each one: Dim db As Database Set db = CurrentDb()...

hi pat, thanks for that. Just got rid of those News as per your advice thanks. it still loves to send lots of emails! I have discovered though it keeps sending emails until I click on one of the pop up email display windows (in outlook) then it stops?!? strange. Any ideas?! Thanks...