Recent content by namliam

  1. N

    Sample of VBA to export inventory table.

    How about creating a report and printing it to a PDF printer?
  2. N

    Export button

    allowing the month to be chosen and forcing the year to NOW, will not always work. I.e. on Jan 1st you will want to see last year's december data.... I suggest allowing the year to be chosen as well or atleast think about it. How did you fair implementing this?
  3. N

    Export button

    Almost, you cannot make a full X = Y in one where clause like that. Instead you create an (invisible) field X and put Y in the where clause. i.e. put Year([Request]) as a field Year(now()) as the where clause
  4. N

    Export button

    What else would you need but to TransferSpreadsheet? In your qryRequirements you can easily "where QueryMonth = Yourform!SelectedMonth" and all you need is to export it?
  5. N

    Daily Water consumption calculation

    Inner join is the same as a join, depending on if access accepts it or not... You can add -2 -3 -4 -5 to the join(s) to ensure you find results... Or even do a Max(readin) join date between today -1 and today -7 I do agree, performance probably wouldnt be an issue on such a small set.
  6. N

    Daily Water consumption calculation

    With all due respect to the suggestions posted, but No no no and once again no.... Dmax and Dlookup should be avoided like the plague and inline subselects are as bad as those two. Assuming you take a measurement EVERY DAY, a simple self join can do the trick. Building on what @MajP posted, it...
  7. N

    Solved retrieve text file content into listbox but not retrieve after comma

    Total gamble, the comma is the column seperator. try replacing out the comma for a semi column or pipe simbol, see if that helps.
  8. N

    Interface with REST API

    Yes it can using the HTTP object ... One example can be found here: http://excelerator.solutions/2017/08/28/excel-http-get-request/ If you prefer Youtube:
  9. N

    Run-time error 3075 (syntax error (comma) in query expression...)

    mid&([Site].[map_ref_numbers],6,5)) Shouldnt that be mid$([Site].[map_ref_numbers],6,5)) or even mid([Site].[map_ref_numbers],6,5))
  10. N

    Run-time error 3075 (syntax error (comma) in query expression...)

    why create a table in the first place, you seem to be able to get the data in a query duplicating the data by way of a create table query is a seriously bad idea...
  11. N

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    You can also make things relative.... i.e. Your db exists: C:\Program\DB\FrontEnd\YourDB.accdb Your BE exists C:\Program\Tables\Backend\YourBE.accdb assuming the relative path stays the same ..\..\Tables\Backend\YourBE.accdb you can relink them as wel. Assuming you have the BE on a server...
  12. N

    Solved Delete current record

    Strike that reverse it.... Make your form unbound and add a "save" button, prior to saving your data you can check what you are adding, if nothing then ... dont save it. Also you can add a "cancel" button this way the user can opt not to save at all.
  13. N

    Summing total values in aform

    Thank you for essentially retyping my earlier post :)
  14. N

    Summing total values in aform

    main form or subform shouldnt make a difference. Likely you skipped a NZ someplace for your subform.
  15. N

    Summing total values in aform

    Months should not be columns, they should be rows as a result you wouldnt have this problem. What you are doing is seriously flawed in design.... re-design should be a real option. Given your problem though, You are doing probably JAN + FEB + MAR, eventually one of the fields is blank (AKA...
Top Bottom