Recent content by MichaelSmith

Thanks for this, I really appreciate it! Having trouble with the subformcontrolname part - the sub forms name is jctVoyagesSources subform and I've tried every iteration I can think of to set it. [jctVoyagesSources subform].Form.RecordSet jctVoyagesSources_subform.Form.RecordSet...

Right - seem to have got it partially working by doing this: Dim strRcset As String strRcset = " SELECT jVS.*, tV.*, tS.* " & _ " FROM ([swpdatabase.jctVoyagesSources] AS jVS " & _ " INNER JOIN [swpdatabase.tblVoyages] AS tV ON jVS.[VoyageID] = tV.[VoyageID]) " & _...

Hi, Wondering if anyone can tell me where I'm going wrong with this piece of VBA code in my form: Dim strRcset As String strRcset = "SELECT jctVoyagesSources.*, tV.[VoyageID], tS.[SourceID] " & _ "FROM ([swpdatabase.jctVoyagesSources] " & _ "INNER JOIN...

A rather lovely friend of mine just spent 3 hours on TeamViewer with me helping me figure this out - with a fairly decent amount of progress. For forms where there's only two tables involved it's now working perfectly using this code: Set Me.Recordset = BEdb.OpenRecordset("SELECT ts.*, tv.*...

Tried this as an example of what I'm trying to do: Set Me.Recordset = BEdb.OpenRecordset("Select * from [swpdatabase.jctVoyagesSources], [swpdatabase.tblSources], [swpdatabase.tblVoyages] WHERE jctVoyagesSources.[SourceID] = tblSources.[SourceID] AND jctVoyagesSources.[VoyageID] =...

Ah, sorry - no. I had a problem with some combo boxes that I've now fixed but still not sure how to only show the related datasets in the forms. My posts are becoming progressively less clear sorry!

Oops! Spoke too soon :banghead: It's very nearly there I've just encountered a few bugs with the forms. I did some combo boxes in a few of the forms which are linked to queries - these are now not working properly. Example rowsource for a combo box which isn't working: SELECT...

EDIT: Fixed my Run-Time Error 91 problem - code is below for anyone else experiencing the same problem: Private Sub Form_Load() Dim connectString As String 'connectString = "ODBC;Driver={SQL Server Native Client 11.0};Server=GAXGPSQ05UA;Database=TRIPS;UID=trimsuser;pwd=trimsdata"...

I live out in Ealing so I was thinking a little further west. If you are ever out this way though drop me a PM. I've been playing around with this for a day or two now and unfortunately I'm still struggling a little bit - hoping you can help me out again if that's ok? Seem to have most things...

If you're ever out in west London and want me to buy you a beer/cake/coffee (depending on preference) I'd be happy too. This is really useful - thank you!

Awesome, thank you. I have to admit this is completely over my head - I have some experience in LUA for coding but VBA I'm completely new to - I usually just copy/paste examples and tweak them if I understand the code - this I kind of understand but I'm definitely out of my depth. I've got...

Hmm, that's a really good idea - thanks! Quick question though, how do I get around the fact that if they open the main database file from an untrusted location they'll be able to view restricted data in the tables? My current thinking is I package up both the small database you suggested and...

Hi, I'm a relative beginner to Access, I've only been working with it for a couple of months and I've run into a snag. I'm developing a database for a university research project - the database was built in Microsoft Access 2013 with the back end being stored on a Windows Azure SQL Server. It...

Quick update to this: The weirdest part for me is that the tables display in the correct order (i.e. sorted by primary key) when I look at them in the Windows Azure management portal.