Search results

  1. S

    Open and update Excel Workbook and saveas Question

    Hi Minty, many thanks for your help! Question: So if I open the existing file with "oldName.csv" and saveas will then I work with the new file automatically so to say? Cheers
  2. S

    Open and update Excel Workbook and saveas Question

    Hi again guys! it hast been a while and I hope all of you are very well. However now I am back in the game and like to work on following where I like to get some advice please. I have a form where I can either open an CSV File in Excel.. for viewing purpose. Update and Save the file into new...
  3. S

    ChildCarePlan

    Hi Larry, many thanks I will look into it and let you know! Cheers Albert
  4. S

    ChildCarePlan

    You are funny :) you are full into it it is nice to see!! It is in hourly rate(s) based on weekly hours and paid monthly. Cheers Albert
  5. S

    ChildCarePlan

    Hi Larry, wow it looks pretty good so far!! As I think of it, it should be both. For Employee: To be able to track holidays, overtime compensations, sick leave, and so on. But to record a day for perhabs leaving the care centre for sport activities or theirlike (Employee(s) ->kids) would be...
  6. S

    ChildCarePlan

    All good Larry as I said it is much appreciated and no stress!! Cheers
  7. S

    ChildCarePlan

    Hi Larry, thanks for your reply! Did not believe that I would hear about this again ) I see you did put more infos into each table compared to my shema. If it is simpler and achive better result than it is fantastic ) Really appreciate that you are so kind to take a look at it! It is very much...
  8. S

    ChildCarePlan

    Hmm Sorry not entered that part of the table. Just thought I get that db to you quickly. Not sure what you mean by that? The issue I have is that I am not sure how this suppose to be set up correctly. If in that case should I have an update Query to send dates to a sperate not linked table as...
  9. S

    ChildCarePlan

    Hi Eberhard, thanks for your reply! I have attached a file inkluding a small Form. Would be nice if you could take a look at it for me! Many thanks Albert
  10. S

    ChildCarePlan

    Hi guys, just wondering if someone had already something similar to get me on the right track with following. I create a small Database for my little sis she works with kids in a ChildCareCentre. The Datastructur is attached what I got at present. Tables: Employees, Employment...
  11. S

    Solved Compiler Error CS0050 (C#)

    Hi guys, sorry was not here but yes I did manage to get it to work! @sonic8, Yes that was the issue the Class was not defined as public but did not spot it at first. Many thanks for replies and hints! Cheers
  12. S

    Solved Compiler Error CS0050 (C#)

    Hi guys, I am running into a problem in C# and hope someone could let me know how I would need to change following Code. incosistent accessability: return type List<Person> GetPeople is less accessable then method 'DataAccess'.GetPeople. This is a code Tim Corey did profide on a You Tube...
  13. S

    Solved VBA loop issue

    Hi, strFileName = “Test.xls” strTFullPath = strFileName Workbooks.Open filename:=strTFullPath strTFullPath = " Test.xls" there is no full filepath.
  14. S

    Import excel spreadsheet to table and keep underscore in data

    Mr. Stiefel from Germany ) Not sure if he is on this forum. But he has got some pretty good content on his website.
  15. S

    Solved Display Filtered Range in Report

    Hi DB Guy, That did the tricke many thanks to you!! Cheers Albert
  16. S

    Solved Display Filtered Range in Report

    Hi, I got a query and a form to filter and display a report. The Query has one date field wich I filter with Between [Forms]![frmPrintTimeSheet]![txtDateFrom] And [Forms]![frmPrintTimeSheet]![txtDateTo] What I like to do is to display that date range in the Report. I placed a textfield in...
  17. S

    Import excel spreadsheet to table and keep underscore in data

    Hi, I am not sure how you import Excel to Access but maybe this will give you an idea of how to.
  18. S

    Project Correspondence Structure

    Ok, it is 3:30 in the Morning at my end and I did change as Pat suggested at least I hope so .) Pat is not here anymore but I was hoping that someone could please take a look at it as I need to have it done in the Morning. Hope I am on the right track now.. Many thanks to all and again...
  19. S

    Project Correspondence Structure

    So a role table is nothing else then Company table and Group Table with a junction table CompanyGroup or is that not correct? So each company can be one or more of whatever is in the group. As I had it in my sample or not? And then where would you link from there? Thanks for your sample I...
  20. S

    Project Correspondence Structure

    It is just a small part of it what I showed here. And again a new different way of doing it again different lol. I like to have it simpler as you suggest but not sure how to do it. So I put all "Companies into one table regardless of suppliers our companies or individuals. Than link a contacts...
Back
Top Bottom