Search results

  1. P

    Import Data and Validation

    Thanks for the replies. The spreadsheet name will change so I would need to link in the spreadsheet each time. I was trying to avoid using a temp table if possible (no particular reason other than just trying to see if it's possible to do it without it). Thank you
  2. P

    Import Data and Validation

    Hi All, I hope everyone is keeping well! I am trying to import an Excel file into Access. The trick being, I only need to import certain fields. I have a spreadsheet named 'Data.xlsx'. It has data I need in the range D:F but I only need columns D and F. Column D in my spreadsheet contains...
  3. P

    Solved ADO ListBox and Filter

    Thanks for this, I actually have identical code for the UDF. Something I done right! appreciate all your help getting me over the line
  4. P

    Solved ADO ListBox and Filter

    I didn’t quite get at the time what you meant by making the form non-updateable, however, I do now! This is quite problematic, I only illustrate the results of the duration in one field on the main form. From researching online, the only solutions I have come across is to either make a...
  5. P

    Solved ADO ListBox and Filter

    The query runs fantastically smooth as an Access query. I reinterpreted the SQL as a UDF and I noticed a performance hit. There's is one unexpected outcome from the query. The 'Hols' field will go to zero if I filter on 'wdays' when there are holidays to discount. This means that the 'wdays'...
  6. P

    Solved ADO ListBox and Filter

    Thanks once again CJ! I have run the SQL and I’m amazed at the speed of filtering the data.
  7. P

    Solved ADO ListBox and Filter

    Just one question if I may, would it be possible to put the above code into a function and pass the dates as parameters? I’m conscious that I will have to use the code frequently, it might be handier to put it in a function as opposed to copying the sql code frequently. Note that the source...
  8. P

    Solved ADO ListBox and Filter

    CJ, I am lost for words at your commitment to helping others in the community. I will try your solution when I get a chance and report back to you on the performance. Many thanks for your time once again.
  9. P

    Solved ADO ListBox and Filter

    The answer to my question all along was the index..... I had ignore nulls set to yes when in fact it should have been set to no. Unbelievable I've spent 7 days and the answer was right in front of me. Appreciate all your time. Stay safe and enjoy the weekend.
  10. P

    Solved ADO ListBox and Filter

    Thanks for the reply - I've indexed the required fields and removed the ordering by and it has improved the speed of my database. However, it's still very sluggish. Is the problem that the UDF is too complex? Perhaps it's my lack of understanding but I thought that the function would return...
  11. P

    Solved ADO ListBox and Filter

    Hi All Firstly, thank you all for your contributions. This site truly has a wonderful community. Unfortunately, none of the proposed solutions have worked so far. I have attached a working example of the UDF with a larger dataset. As you will see, the 'SampleQueryData' query runs quickly...
  12. P

    Solved ADO ListBox and Filter

    Thanks for the reply. I have a UDF in my actual database. Would you be able to suggest any examples, forum posts or any code to get me started. I have literally searched 100’s of websites trying to get this to work. Appreciate your time.
  13. P

    Solved ADO ListBox and Filter

    Hi All I'm having some serious problems that I'm just unable to solve which I hope you can be of assistance with once again. I have a listbox that I am trying to filter a subform with, the problem is when I use queries the filter just hangs as I have a user defined function and it just stops...
  14. P

    Solved Listbox and SubForm

    Majp, thanks for the response. my question is could I achieve the same functionality with using just one query on the main form? so in essence summarise the data in the list box (currently a group by query) and filter on specific records in the continuous form (currently a separate query). I...
  15. P

    Solved Listbox and SubForm

    Thanks Majp, works as intended. Appreciate your time with this. I have a follow on question if I may. Is there any way you can have the same functionality without doing the query with the group by on it? I’m wondering if it would be possible just to have the record source on the main form feed...
  16. P

    Solved Listbox and SubForm

    Hi All, Its arguably not the most aesthetically pleasing database you have ever seen but hopefully it conveys the purpose I am aiming for. the parent form will have text boxes that are bound to "SampleData". I want to be able to click on the listbox and filter SampleData thanks
  17. P

    Solved Listbox and SubForm

    Many Thanks for the replies. I will post a sample db shortly.
  18. P

    Solved Listbox and SubForm

    Thanks DBGuy for the response. Basically the Subform contains "summary statistics". The source of the listbox is a query with a group by on it and it contains roughly 15 rows. Subform2 contains the data behind these "statistics" and may contain 1000 rows. What I want to do in the most...
  19. P

    Solved Listbox and SubForm

    Hi All I have a parent Form with two subforms. SubForm1 is a listbox and is unbound. Subform2 is bound to the parent form. What I want to do is click on the listbox and it filters subform2 by column(0) which is the same in both subforms. Any suggestions/tips/good programming etiquette are...
  20. P

    Stop clock on Working Days

    I was hoping to gain some knowledge/assistance as I'm not experienced with Access. I've simplified the code but I'm getting a type error. I was hoping I could pass all 4 parameters through the function but if not, if you can explain why I'm getting a type error when I try and subtract...
Top Bottom