Recent content by Aoife

Thanks for all the feedback. Tried opening as a Dialog form and the VBA was unresponsive after the initial code was run. The form froze thereafter and I had to bomb it out. I'll attempt to post a slimmed down version of the database later in the week. BTW impressive database Colin.

Thanks for the reply. I did see the potential Daisy Chain solution but my understanding is that this would serve to hide my background form (make it invisible) and therefore you would see more of the MS Access interface?

Hi I’ve got a background form with modal and popup properties both set to yes that opens when the application is opened – it serves to hide the MS Access application on startup. I call further forms all with modal and popup properties both set to true, all works great until any of the forms...

Thanks for the link JDraw - opened my eyes to the Yes/No field that Cronk also kindly highlighted along with the method I'll probably attempt to progress tomorrow. Example code was also very useful MajP, would still appreciate your subform example Cheers All

Hi I'm attempting to use 2 listboxes to book out listings of pupils to various activities. In my code below, List11 is the list of all pupils, whereas List79 is based on a query where the activities are logged. The code below iterates though the selected pupils in List11 and populates List79...

Hi Was going to feed back to Colin and hadn't realised that there were other posts... Now storing URL references in the table with the pictures stored separately on the server as per Colin's recommendation. I've used a Pass Through query to obtain the underlying data from the MySQL back end...

Thanks Colin, sounds promising

Thanks Colin Excuse my ignorance on the MySQL front, do you know if it's feasible achieving this using MySQL? I'd like to store images on a server rather than locally

Hi I've linked Access, using Unicode ODBC driver, to a MySQL backend that collates images using a third party app. Accessing the underlying table is very slow, as is a simple 'passthrough' query on the same table. By removing the 'Image' (yes, I know it's a reserved word but I don't have...

Hi I've downloaded ChrisO's sample database from https://www.access-programmers.co.uk/forums/showthread.php?t=228003 Ultimate goal is to update a SQL Server BE with attachments (Migration Assistant flags up the issue with attachment fields) - however I'm unable to even double click the OLE...

Thanks for the tip Paul, will give it a go

Many thanks Cronk, don't think I would ever have got there

Hi Been struggling with this for several hours - anything obviously wrong with the code below. I've used a DLookup to find valueSignInFastTrackID5, it returns 4851. However the code appears to find a match but the MsgBox "true" line doesn't kick in and the record isn't altered. I can't...

Thanks for your response. If I don't have an order on eg 25/9/16, there will be a missing column for that date. So if I've got orders on the dates either side the crosstab columns will be: 24/9/16.......26/9/16. Is there an easy way of generating the 25/9/16 column, and any other dates where...

Hi, I've successfully utilised the following from the 'FMS' website to create a crosstab query that generates sequential monthly column totals irrespective of whether a month contains data or not. I'd like to manipulate the query so that I can eg enter a start date of #01/10/16# and obtain...