Search results

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

Hi all. I would like to have a way to build recipes and see the nutritional content for both each ingredient and the overall recipe, live, as the numbers are being entered. The small figures in pink are bound to the MasterFoodList table that has its values stored at the 'per 100g' rate and will...

I didnt know that either, thanks for the update. I have a form to view the settings, but sometimes I want to change them using VBA as side effect from a completely different action, much like the link that describes how to return to the last viewed record in a form... hang on !!.. Duh ...

Its mentioned at the bottom of this post https://www.everythingaccess.com/tutorials.asp?ID=Return-to-the-same-record-next-time-form-is-opened Out of interest, the description in Step 1 of the link is incorrect. It says to have a Field Name as 'Value', which isnt allowed, its now a reserved...

That might be worth playing with, thank you kindly. Im guessing something like (and I havent tried yet so excuse the errors and give me chance to debug myself :) ) ... Currentdb.Execute "update tblMySys set [MySysValue] = '" & MyFaveFruit & "' where [MySysVariable]=FaveFruit I use this...

Sorry if this has been covered many times, I just cant get to grips with it using others data and syntax... I never know what is a table, field name or the name of a control. I want to update a particular record in a particular table with the results from a VBA variable. In the table tblMySys...