Search results

  1. B

    Access randomly asks me for a data value that no longer exists

    Yeah.. It seems to be referenced at the add existing field tabs. Is there a way to referesh that tab so the variable dissapiers or do I have to make the whole form all over again :confused:
  2. B

    Access randomly asks me for a data value that no longer exists

    My main table which leads to all the other tables had a variable which I deleted. It was of no significant importance it was more there for a visual improvement of the table. Now that I deleted it most forms and queries keep asking for its value.Even if i put in blank it still works.How do i...
  3. B

    Multiple relationship betwen 2 tables how to force a query to use a specific one

    It works! Thank you a lot man! I have been grinding my teeth with this error for a good 2 hours.
  4. B

    Multiple relationship betwen 2 tables how to force a query to use a specific one

    Well I know it should but i dont know how to achieve that........
  5. B

    Multiple relationship betwen 2 tables how to force a query to use a specific one

    I have 2 relationships between 2 tables .First table is called "Personnel" the second one is called "Equipment". "Personnel" has 2 connections to "equipment". One being the person who rented it and a second one being the person who added the equipment. Every time I try to make a query about the...
  6. B

    How Do I make a Login screen

    You are right but I dont have the time to learn Visual Basic to its whole considering we will be using SQL in the next semester. Is what I am trying to achieve possible with only expression builder or macro builder ?
  7. B

    How Do I make a Login screen

    thank you for the advice but this is a college project for Data base I. It wont be really used in a live environment so the credentials thing wont be of any use to me. I am just looking for a simple effective way to do this so I can get bonus points from my prof. :D
  8. B

    How Do I make a Login screen

    Hello. I am a beginner with VAB . I have a login screen that has 3 text boxes( NAME,SURNAME,PASSWORD) and one button.I want to make it so that when you fill the 3 fields in and press the button it searches a table and if it finds the right combination it should look into a fields in that table...
  9. B

    Checkbox Subfrom please help!

    Can you please elaborate. I am not very proficient with access. We only started databases in my It college.
  10. B

    Checkbox Subfrom please help!

    The relationship between "reports" and "occurrences" needs to be a many to many relationship . I think I cant put a yes or no because one "occurrence" can and will be used in more reports
  11. B

    Checkbox Subfrom please help!

    Greetings. I have 2 tables " reports" and " occurrences " . I need to in the form for " reports" to have a subform in which the user selects a number of record from " occurrences " via a checkbox to be used further in the report made for "reports". Please help me I looked everywhere but I have...
Back
Top Bottom