Search results

  1. D

    New Database

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

    New Database

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

    New Database

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

    New Database

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

    New Database

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

    New Database

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

    2 Syntax Error cant see :(

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

    2 Syntax Error cant see :(

    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 & "', '" &...
  9. D

    New Database

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

    New Database

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

    New Database

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

    New Database

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

    New Database

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

    League of Legends

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

    ProjectNumbers with ProjectGroups

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

    ProjectNumbers with ProjectGroups

    Hello, Thanks for answering to me. I will send my database. a-) I deleted some Contents. Because it is forbidden and these are not important now. b-) There was more than 2000 Projects and Projects with Milestone more than 30000. I deleted them either. Otherwise the DB was more than 100Mb...
  17. D

    ProjectNumbers with ProjectGroups

    Hello My Friends, I have 2 Type of Fields. First one is : "ProjectNumber" other one is : "ProjectGroups". I will write here sort : "ProjectNumber" as a PNr. "ProjectGroups" as a PGr. What do I need : (I really do not know how can i explain my wish basically.:confused:) At Pictures as you...
  18. D

    chart not sorting alphabetically

    Hello my friends; I made a "Stacked Column Chart" and there is 5 different Axises. When I was creating my query, first of all built a new table. Because I do not want to see Axis as an alphabetically. On my query it is working perfectly. But when I create new Chart, Access is sorting...
  19. D

    with Text Box tring to choose a specific Row

    This is my English level. if you don`t like that, I can write with my main language and you can try to translate all day. Or you can ignore it. Doesnt matter.. I don't like to use English forums but if I can not find any other options, I am writing here. Now I'm repeating my question again...
  20. D

    with Text Box tring to choose a specific Row

    Hello My friends, If you check to Picture i have 3 Records. i have 2 questions here : 1- How can i show on screen Bus > Budget Total with text box ? 2- Please IGNORE Total and how can i sum For example Truck Budget AA + Budget BB shall i write for every 3 records different Query or is...
Top Bottom