Search results

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

Thanks Minty.

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...

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

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...

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...

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...

thanks for all the useful info. (y)

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,

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...

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...

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...

Yes it is.

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

Hi, Any suggetions on this concatention issue? Thanks.

Thanks ‼ :)

Yes, that's correct, the default value got solved, but concatenation didn't work anymore after that, since DBguy, knew the background having look at the database, I asked him for help to avoid posting the whole story once again in a new post....

Hi Jdraw,👋 Thanks for offered help. :) (y) I'm trying to concatenate the comboboxes: CurrencyID and ExchangeRateID. They are working fine when I open the form and select a currency in the CurrencyID combobox field. However, when I open the form and select the ExchangeRateID for another value...

hi, Thanks for looking at my dbse once more. I was trying to solve the below problem which happens when I open the form and select the exchangerateID field. Only when I select the CurrencyID field and select a currency and then go to the ExchangeRateID, it will show the selected currency...

Thanks, I've attached the dbse. It's in the same form as we discussed the default value for the ExchangeRateID field. .When I scroll between the records, the ExchangeRateID field remains empty when USD is selected in the above CurrencyID field, when I select the field I can select the exchange...