Recent content by Siegfried

  1. S

    Search not working

    Thanks Jon, working fine now! And thanks for hosting this great site (y):)
  2. S

    Search not working

    Thanks Minty.
  3. S

    Employment end date

    Dear CJ, Thanks for your help, I have implemented your suggestions to my database. Still have a question though. How would you go about with updating the employee's absence? In below example of the Employee Overview: if Peter returns to the office, do I put a button behind each record in...
  4. S

    Search not working

    Hi, Whenever I want to search something I get "A server error occurred." I tried Google Chrome, Microsoft Edge Chromium and Internet Explorer. Had cleared all cache and browsing history. Tried both on my laptop and desktop. Best regards, Siegfried
  5. S

    Employment end date

    Hi CJ, Thanks for the tips! (y) The DOB I'm using to set up a code, we have this desktop application which connect to the land line telephone. At setup you have to change the default code to a new individual user 6-digit-code, I've opted to use the data of birth for that. So now and then the...
  6. S

    Employment end date

    Hi everyone, thanks for the many response. I designed my table like this: being: H hired, T temp, S student, C contracted for a period of time but not full time. I don't need any wages info in this database, I need the employee info as IT to be able to assign assets to users and create...
  7. S

    Employment end date

    Dear experts, In all the examples I came across on the internet so far for an Employees Table, I notice that only a hire date and, at times, the date of birth are mentioned? Is it incorrect to add an employee end date in that table? EmployeeT EmployeeID_PK EmplFirstName EmplLastName...
  8. S

    Default value in Form field

    thanks for all the useful info. (y)
  9. S

    Default value in Form field

    Hi jdraw, Yes, that a much more clever approach then what I was trying. It indeed makes more sense this way, less complicated than my approach. Thanks I'll try this out. (y) :) Best regards,
  10. S

    Default value in Form field

    Hi jdraw, Yes, you are correct, I'm trying to setup my own database to get rid of my dozens of excel files and simplify my work. At my company I'm the IT coordinator (only me: 69 staff), I report to our head office and get all directives and instructions from them to implement. Unfortunately...
  11. S

    Default value in Form field

    Actually that's a good remark. I didn't consider showing the rate and the date for this currency... I somehow wanted to combine this in one field. I'm not associating the exchange rate with the receive date as I want to be able to select a currency rate manually. An order I place on the 25th of...
  12. S

    Default value in Form field

    Hi jdraw, Thanks againg for helping out and spending your time on this. "Yes it is", sorry that was a bit short indeed. I haven't created the subform yet on the Main form PurchaseOrderF. Form PurchaseOrderF will indeed get a subfom: PurchaseOrderItemsFSub. However I was first coverting the FK...
  13. S

    Default value in Form field

    Yes it is.
  14. S

    Default value in Form field

    Hi DBguy, Any suggetions on this concatention issue? Thanks.
  15. S

    Default value in Form field

    Hi, Any suggetions on this concatention issue? Thanks.
Top Bottom