Search results

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...

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...

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()...

Hello, I've been having a few problems with sending emails from access. I've a form which has all the info on it about a particular guest. I have a button that I press to email this guest using info from the form. I think it works fine when outlook is already open. If though outlook is...

hello, I've a it of a head scratcher here. I've been going at it for a good while without avail! I have a bookings database for ski chalets. There is a table tblBedSpace, and there are 4 fields being ID, chalet, roomnumber and bednumber. The idea is each guest gets placed in, for example...

Hello, I'm currently in the process of gutting and redoing a bookings database (access 07). I built it last year, and it was the first database I've built. As such, it's not great! I'm re-doing it to make it more efficient and faster for me to use (I'm the only user so it doesn't have to be...

Hello, I am using access 07 and have some VBA code which puts some text into a memo field for me. It gets the text from various columns of a table. Currently it produces text that looks like the below: phil - hire - advanced jonathan - lessons - beginner claire - lift pass - local area etc...