Search results

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.

I've been building a database which will be used on a large archaeology project to store and analyse data on shipwrecks. I built the database in Access 2013 and am hosting the backend on a Windows Azure SQL Database. I converted the database to SQL Azure using SSMA for Access. I currently have...

Thanks CJ_London I needed to do that and didn't realise it was necessary, I still had the issue afterwards though. This is what I needed to do to fix it completely in case anyone else has the same issue: The list of countries I used was taken from a Wikipedia table and had some god awful...

I'm encountering a problem with the AutoExpand feature in a ComboBox. I've got a table of Countries (tblCountries) which is linked to a junction table called tblWrecks via it's primary key tblCountries CountryID (Primary Key) Country Name tblWrecks WreckID (Primary Key) VoyageID (Foreign Key)...

Thanks, going over your edited post: Ownership doesn't change mid-way through a voyage, it only changes once a voyage is completed. You make a good point about about merging owners/captains to prevent repeated data - I'll have a think of the best way to go about it since I need to capture...

Hi Namliam, A ship could have had up to three captains on any one voyage (they tended to die fairly regularly). Ships were owned by up to 16 owners for any single voyage and ownership could change from voyage to voyage. A captain could also be a part owner of the ship. Captains and owners can't...