Search results

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

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

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

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

Probably doing something daft, I'm attempting to pull data in the following crosstab so that only one row of data (date) appears. All good when the data is in one year, problem occurs when data falls in eg both 2014 and 2015. Is there any way of adapting this query so that it simply...

Hi I've got one table called CompanyIndustry details comprising of ciID (autonumber) CompanyIndustry (food, agriculture and pharmaceutical) A second table called CompanyDetails has following fields: cdID (autonumber) CompanyIndustry Address etc I'd like to create a query...

Hi I've adapted the following code to email a report based on the values of a query. If an individual is ticked, they will receive an email with a report attached. All goes well.... if you have the patience of a saint. In the event that 1 person is being emailed, it takes approximately 5...

Hi all, I'd like to be able adjust the colour of a column chart (on a form) depending upon the series being graphed. ie Lab is blue, Office is green etc. There will only be 5 different series (areas) but the parameter query upon which the graph is based may have no data for the Lab in certain...

Hiya, been attempting to avoid #error values in a query when [expirytype] (a numeric field),[expiresmonths] (numeric) and [completed] (date) are blank Step1: IIf([expirytype]=2 And (DateAdd("m",[expiresmonths],[completed])>Now()),(DateAdd("m",[expiresmonths],[completed]))) My research has...

Hello all! Have set up a database as per one jdraw's recommendations in a previous post (see attached), I want to be able to query both 'EmployeeHasTraining' details at the same time as 'PostionTrainingRequirements'. In other words, how to show training completed to date plus what further...