Recent content by DaRTHY

Hi again and thanks for your response Normally you are right but we are small group and Emails are unique for us. That's why I can use them as an PK and FK. Also For device Information, we have our Numbers and as a PK I'm using them and Auto-number is not useful. I just need to think simple...

Hi Pat Hartman, (I uploaded with new Relationships.) Thank you for your response. I'm using auto-number only in "Device_Informations". If it is not necessary, I deleted it. Actually I created "Category, Status and Vendor" tables only for Information. But should I see in relationship. No I...

And Also When i write this Criteria to my query : Like "*" & [Forms]![frmDeneme]![Srching] & "*" I'm getting this error : Enter Parameter Value Forms!frmDeneme!Srching why is that happening ? This Srching is a Text-box.

Thank you for your help. It works... but works only one time, if I click again, then code is passing by first IF and continue Else statement and adding empty box. I guess somehow i have to add While Statement. Private Sub btnAdd_Click() If IsNull(Me.txtMail) Then MsgBox "Mail...

I also wanna ask how can i check 3 text boxes "cant be empty" If IsNull("Me.txtMail" Or "Me.txtName" Or "Me.txtSurname") Then MsgBox "Mail Name or Surname can not be EMPTY!" Else If i write onlx Me.txtMail ..... then works.

Hello again Everyone, I almost finished my DB ver1.0. You can find it in attachment. But I need your help again. If you open my DB, automatically comes Form Employees. I created 2 different Forms. One of them "Employeelist" It works so simple. If you want to add new Employee, you need to...

thank you for your advice. I will change the field name. Than i will try it.

Hi everyone, I wrote some VBA Codes but I become errors. :banghead: Private Sub btnAdd_Click() If Me.txtMail.Tag & "" = "" Then CurrentDb.Execute "INSERT INTO tblEmployees([E-Mail], [Name], [Surname], [Title], [City], [Phone_Number]) VALUES ('" & Me.txtMail & "', '" &...

Thank you very much. I can focus my other things on DB now. :) Hope so I can do them alone :))

Good afternoon everyone, I updated my Database. (Uploading here again.) I have same problems. I want to choose easy way, but also I want to create more useful. I'm really bad for coding but I guess with VBA, I can get better results. I'm of course open better ideas. 1- I want to start search...

I understood, after check this DB-Example. It saves me from over tables. I'm updating now and send it again. Thanks.

Thank You jdraw. I was thinking also same. I just created like that but I do not need those tables in Relationship: Category. Vendor. Status. (I will not delete. Because I'm looking them. But I can remove from relationship.) But i had not thought every devices in one table. I will check...

Hello Everyone, I have several questions. I was not sure, which sub forum shall i use, that's why I'm writing in General. I created new DB,(this DB is for our IT-Equipment) and also tables and relationships. I have also Forms. My main Form name is "Personal_Info". This Form has also 4 (5...

i am playing LOL too. But im really unlucky person, everytime find me really noobs or troll players.. I am playin mostly Support line. And i am really good as a sup. But for ranking up i have to play top line, i cant carry the game when i play sup. last 2 or 3 months i could not play because of...

I can understand what do you mean. But i did not choose those names and tables. They are coming from the server. I am just exporting to excel and importing to our department DB than trying to do their jobs. And every week to change DB Tables its not possible... ps : The MS names are not real...