Search results

  1. H

    Solar panel power up!

    I live in Adelaide in South Australia. I installed 5KW of panels 8.2 years ago They cost about $6K AUS at the time. The Government and Power retailer were offering a rebate of 23c per KW hour which later reduced to 12 cents then 9 cents and is currently at 16 cents. So cost wise it is hard to...
  2. H

    How Can I Share Access DB in a LAN for multiple users?

    Thanks for this and other weekly postings. I have always linked to a Drive letter for my backend dBases, so I had to reserve that same drive letter on each user's PC. I had not used the UNC connection methodology before. It is fantastic and would have saved me hours over the years when I have...
  3. H

    Problem with keys

    FWIW:- I seem to remember having this problem about 15-20 years ago. I wanted to have a database on the main PC in the office and a copy on my laptop that could be used on customer visits. The intention was that when they would re-connect on the network they would synchronize with each other...
  4. H

    Solved What to do with employees if supervisor is inactive

    Thank you it looks good and appears to work as you indicated you wanted it to.
  5. H

    Solved What to do with employees if supervisor is inactive

    Hi, I would like to see your end result please!
  6. H

    Solved Addition not working in a Query

    Hi typing Currency in the format field solved another problem for me. I didn't see that option which is why I formatted the calculated fields. Once again a big thank you!!
  7. H

    Solved Addition not working in a Query

    Many thanks Arnelgp that did the trick! I probably wasted 2-3 hours trying to find out what I was doing wrong. I really appreciate all the help you give to myself and others
  8. H

    Solved Addition not working in a Query

    Thanks I missed your edit so will try same!
  9. H

    Solved Addition not working in a Query

    Thank you for your prompt reply but it doesn't seem to work as totl = 0
  10. H

    Solved Addition not working in a Query

    Hi There, I am trying to understand what I am doing wrong with the attached Query. I extract and calculate a number of fields from two tables. When I multiply one field by another it works perfectly. See field "CubeCost" However when I try to add a number of fields the result is that the fields...
  11. H

    Solved Query based on combo box

    Hi Bob, Thanks for your input. I used the following which directly referenced the correct table:- Nz([Forms]![Allcrete-Report-Date-Range]![Employee],[WorkOrder Labor]![EmployeeID])
  12. H

    Solved Query based on combo box

    Hi arnlgp, Many thanks I simply prefixed the field name with the table name and the problem was solved. Thanks ever so much.
  13. H

    Solved Query based on combo box

    Thanks for replying ARNLGP This what I received back after installing the code. The date picking works well standalone but the employee selection is not working
  14. H

    Solved Query based on combo box

    I am having a mental blank I am trying to pull payroll records in a query based on a popup form that asks the user to enter StartDate, EndDate and EmployeeName The employee field on the form is based on a combo box tied to the employee file which brings back fields EmpID and Employee Name As...
  15. H

    ...

    Hi Arnelgp, FWIW This is what I am seeing from your latest version. There is no multiple pages with separate heading for each month.
  16. H

    ...

    Try this. I haven't put them on separate pages but they are in separate sections so you should be able to proceed from here
  17. H

    Solved Using DLookup in an access query

    Hi Minty, I did the compact and repair and no difference. I then checked to see what version of access I was saving the database as and found I only had 2000, 2002-2003 or 2007. I am running Office 2010 on Windows 10. Decided to move to Windows 365 which allowed me to save it as Access...
  18. H

    Solved Using DLookup in an access query

    Hi There I seem to be unable to do a DLookup in a query. I have a separate database to the one shown and was experimenting on using DLookup in a query. Unfortunately it failed with a message "Undefined function 'DlookUp' in expression" This has had me stumped for a few days after checking...
  19. H

    How do i mark a thread as SOLVED?

    How do i mark a thread as SOLVED?
  20. H

    User Defined Function help please

    Hi Bob, Many thanks for the quick turnaround and a great solution. I had to modify code to accept Period key if I wanted to default back to todats Date. (Thanks MajP) Cheers Public Sub DateAdjKey(KeyAscii As Integer) 'Subroutine to Adjust Date Field up or down. Const conPlus = 43 'the +...
Top Bottom