Search results

  1. A

    Update query criteria compare a field in another table and update accordingly

    Yes, you are right. I am only working for my team, I am not managing the whole company level database (I didn't mean to say that). I am not that important yet! I am barely a college graduate and trying to fix some of the issues in the team. But, the data I am working on is horrifyingly giant, no...
  2. A

    Update query criteria compare a field in another table and update accordingly

    Thanks jdraw for suggesting and providing the guide. I am excited about programming, especially I have worked with C++, MatLab, HTML and CSS. My studies have been focused on math, physics and engineering, that's why probably I missed Access. But now in a corporate world, I am working with Access...
  3. A

    Update query criteria compare a field in another table and update accordingly

    I do need to know the solution to create such type of query where the criteria is a field from another table instead of just a value and updating according to the match (criteria) through inter-table relationship. This is important for my coding knowledge. I may run into such problem in future...
  4. A

    Update query criteria compare a field in another table and update accordingly

    I had mentioned earlier that I am aware that my database is not normalized, because I was under the following impression: I was working earlier when I tried to link two tables (those were the only two objects that existed in DB at that time) via an ordinary field, but an error message showed...
  5. A

    Moving question to different folder

    That was so dumb of me to think that you made the code. But throught that especially since it showed inside your signature. Since I am so busy with codes and Access all day long, that's all I can think about. Of course, that kind of message would be autogenerated in a forum! Anyway, thank you...
  6. A

    Moving question to different folder

    Thanks spikepl. I need the answer so badly that I will try second time, before going to somehwere else. By the way, I noticed your signature. Under Access Joy, you wrote about when members can have signature and photos. But, the next lines "You currently have _ posts." When I had not logged...
  7. A

    Moving question to different folder

    I have asked two questions: one in query and one in forms, but got no satisfactory asnwer. Is there any way, I can move those to Modules and VBA folder instead as someone might be able to solve my problem there? Or shoudl I just create new questions in that folder with the same problem? Thanks.
  8. A

    Regular form from multiple table without subform

    Combo box will not work, since info will be prefilled in upper section. Also, the form does not even display information from the main table, when fields from related table are included in the form. Yes, this is a form that edits and enters data in more than one table. I thought you create...
  9. A

    Regular form from multiple table without subform

    Form: field taken from various related tables I am trying to build a database. And, I want a form that pulls in info from different tables. I build this form from scratch only to discover afterwards that this form would not show any records since fields are from more than one table. So...
  10. A

    Update query criteria compare a field in another table and update accordingly

    OMG, I just tried to link table via fields that are not primary keys and it worked. So, I was able to link WindowName in those two tables with one to many relationship. But I do need to know the solution of this situation. One time, I was filling in table info with combo box in forms. I did...
  11. A

    Update query criteria compare a field in another table and update accordingly

    Hi Markk, Thank you for your reply. At least somebody replied! I am dealing with confidential material for my company and I am an intern. Tech people are not allowed to discuss things outside their department, only media people can do that. So, I just wanted to be on the safe side. I know...
  12. A

    Update query criteria compare a field in another table and update accordingly

    I am programming an Acess Database, the primary data come from an excel sheet. Since Access one to many relationship only works for primary key and another field in another table as foreign key, I can't have normalized database. I will explain what I mean with a hypothetical situation. So...
Top Bottom