Recent content by widemonk

Thank you for prompt responses. All makes sense. My own FE is actually local anyway. Its the FE for the others that is server-based. Explains why I've not experienced any latency but still good to know. Thanks @Pat, that's almost the same thing I was going to do with version check, although...

I realise this in an old post. Found it while trying to justify to a colleague about multi-users not using the same front end. @The_Doc_Man I notice you mentioned about "giving out individual copies for use on local machines." and @Pat Hartman, you've include a nice batch file example. Those...

Using Access 2013 I have a form of continuous records with a custom search/filter text boxes in the form header . In the date fields I have purposefully formatted the display of the dates as dd-mmm-yyyy for the avoidance of any doubt so 01/10 shows as 01-Oct instead of 10-Jan. However when...

Awesome and thank you (y)

I will apologise in advance - perhaps this is the wrong time of night, wrong frame of mind... my head is just mush - I should know this!! How do I get this query to return the number of people that attended each event? The Expr = number of people (eg MemID #7 had a 'plus 2' of non-registered...

Hi CJ and thank you kindly. Yes the query includes Left Joins, however a new unjoined query that calls the original and the new table works a treat.

Hi, Also make sure you have chosen the correct data type for this field. If its set to a Short Text or something else is converting this info in to a String, it may sort the data like this 1 10 11 2 20 21 3 30 31

Hi All. I have a query and one of the fields is an expression that returns a number. This number represents number of days between 2 dates and is called ExprDaysDiff The query draws fields from many different tables and the Report on which its based already includes a first level of grouping by...

Hi - I just want to update and close the thread. Workaround was like this... RecipeList revised to include fields for actual values for each nutrient for each ingredient - not ideal because its storing data that is just a simple calculation of data found in other tables. The form includes...

Sorry, I have to admit Im struggling with that. I'm not sure which query to put it in, and it appears to need extra syntax; both an expression and a domain (or from what I understand, the source query). Because I dont know where to put the DSum, at the same time I dont know which source query...

Fantastic, thank you arnelgp. Now I just need to fiddle with them to make the recordset updateable when the number of grams is changed, or a different ingredient is selected.

OK I've stripped it down to a bare bones with minimal info. Its the footer of frmRecipeBuilder. Total calories should be 859cal (100g @ 142cal/100g + 133g @ 261cal/100g + 200g @ 185cal/100g = 859cal) The key is that this figure in the footer should instantly change if the...

Hi and thanks again. Have tried both, both still return the #Error The Expr in the Query is called 'QryCalc'. This is referred to on the form in the yellow box. If I remove the Sum part of that and just say =[QryCalc] then I dont get an error, but it returned the value of the first record only...

Hi and thanks for looking. All the txt prefixes are for Text Box controls (eg txtThis, lblThat, cmdTheOther etc - my own personal 'rule' so can see at a glance and never confuse a control from a source.) That appears to be the case, but this table doesnt have those actual numbers stored, in...

The control for the blue (unbound) text is txtCals Control for the pink 100g rate bound to the food table is txt100Cal The one called txtSize is under Grams.. i should probably change the source to 'Grams' so the control can be called txtGrams