Search results

ooooohhhhhhh :D tx!

Where, the link did not seem to display but thanks so far anyway, I thought it was a reference myself but not sure which side and where to set it

Yes, to put the employee number as fk in the availability table would be better, cause one availability can be shared by many employees. You can have a form that looks just like a spread sheet, or you might want something else, give me 10, we did something like that a couple of years ago, I'll...

You store name, address and everything that is unique to one employee in one table - employee name, address, phone availability gets stored in another table with a link on the employee number to the employee table - for this you need a course in relational databasis I would suggest. It is an...

You can do the same in access as in excell. Make a textbox next to the name and code the background property to change color on availability, if you want some code, just ask we can send

One of our users runs MS access through citrix. On all the other environments the database gives no probs but on citrix we get errors that some of the functions cannot be understood or read. Is there anything I can do about this? Thanks!!!

I am using a query in my code ssql5 = "select * from [my table] " _ & "where [my field1] = " & rstmyrecordset![my field1] _ & " and [my field2] = " & rstemyrecordset![my field2] I then open the recordset like this Set rsttemp = dbscurrent.OpenRecordset(ssql5, dbOpenDynaset) My problem is...

I am using a query in my code ssql5 = "select * from [my table] " _ & "where [my field1] = " & rstmyrecordset![my field1] _ & " and [my field2] = " & rstemyrecordset![my field2] I then open the recordset like this Set rsttemp = dbscurrent.OpenRecordset(ssql5, dbOpenDynaset) My...

Thanks for the answer, no, my data read EPE(R) and was retrieved through a combo box. Everytime the client picks the EPE(R) it changes to the trademark and gives an error that the item is not on the list. There is however a setting in Access called autoreplace. One can pick the trademark value...

Access understands my data (R) as the trademark registered. When trying to pick this from a combo box, it gives me an error that it doesn't exist in the list....sigh.... :D What can I do about this?