Search results

Morning.. I have two listboxes, both doing similar things (displaying commitments against properties/suppliers).. The first listbox is a list driven by a query and can be double clicked to launch a display/edit form.. This works without issue. The 2nd listbox within a form which is called...

Morning folks, hope Access is being kind to you today.. I'm mid build on a commitments tracking (pseudo Purchase Order system) project, but seem to have run into an issue with a loop I'm building to allow users to edit commitments. The idea is that an edit form is launched, values amended...

Morning folks, I'm delving into the world of Access again and have run up against a little issue.. I have a table of expenditure information against a number of accounts. The data is broken down on G/L code, Cost Centre and a number of other elements. I need to be able to suppress spend...

Forgive me, for I have sinned. It has been some time since my last post and an almost equal amount of time since my last piece of access development. (Enough of that melodrama, let's cut to the chase).... I'm building a form on which I want the end users to select a site reference from a...

Folks, any thoughts on this one? I need to find the position of the first alpha character in a string, the section of the string prior to the alpha character is variable in length, hence I need to be able to find the position to feed to a left/right/mid style expression to be able to break down...

Morning folks.. Having a little fun with rounding at the moment... I've made some progress but am running into an issue, purely due to the way that I want the rounding to work.. I have times output in decimal style (due to the originating data source) and need to retain the decimal style...

First Receipt : IIf(Min([dbo_ReportData].[Received Date])="",[Liveval].[Received Date],Min([dbo_ReportData].[Received Date])) I'm guessing that IIF doesn't play that way? Well, I know it doesn't, I'm getting aggregate errors when attempting to run the query.. I need to pull a value from one...

Folks, Have a quick nose at the following query... SELECT Engineers.Engineer_Name, Count(dbo_ReportData.[Job No]) AS [CountOfJob No], DCount("[Ret Call]","[dbo_reportdata]","[Ret Call]= 'N'") AS Expr1 FROM Engineers INNER JOIN dbo_ReportData ON Engineers.Engineer_ID = dbo_ReportData.Engineer...

I'm using an expression to concatenate results within a query (three text fields), but having, relatively recently, learnt of the "unsuitability" of the LAST function, I'm aware that I cannot trust the output of this particular part of the query.. The Expression is currently this ...

So, this query is dynamically built in VBA and added to a new query.. SELECT DISTINCT dbo_ReportData.DOCKET, dbo_ReportData.site_search, Priority_Grouping.Category, Priority_Grouping.Priority, Prod_ShortCode.ShortCode, Prod_ShortCode.HighLevelGroup, dbo_ReportData.Description...

Folks, hopefully you might be able to help with this one... I have a database to which I'm attempting to add some additional functionality. The database is already in use for building distribution lists of software upgrades to customers, based on the version of software that they're currently...

Morning folks, Just wondered if anyone had any thoughts on how I can get this query to be accurate! The LAST function doesn't appear to be finding the last entry every time, in fact having just refreshed the query a number of times it has presented a different priority value each time! I've...

Morning folks, First time poster, so apologies if I don't give you all the information you may need to begin with.. (give me a prompt if you need anything else).. I'm building my first real database to handle version information from a large number of servers and need to build a front end to...