Search results

Awesome, got it to work! I didn't have to write any SQL code :) thanks for the help

Okay, I'm confused. I tried to create the query from scratch and Access is telling me I need to use SQL? I don't know SQL and don't know where to write that code even if I was given the correct code. I also don't know how to fix my joins, because I have a junction table connecting my two...

Oh man... I was just using the Query Wizard...I guess I'm going to have to design the query from scratch. I'll read through that link and try to figure it out. Thanks!

Hi Guys! I solved my forms problem with the help of Gina here: http://www.access-programmers.co.uk/forums/showthread.php?t=267116 I'm off to the query group to get some help with that :) Thanks again for all the help

Thanks so much for your help! I'm on to the query discussion group, I'm having trouble pulling the all the data from my All Applicants table and Awarded Grants table. The query filters out the unsuccessful applicants in the All Applicants table, which I don't want it to do. I just want it to...

Hi Guys, I'm trying to create a query that will pull data from several tables without filtering data from those tables at the same time, and I don't know how to do this. I'm working with a grant database that holds information of successful and unsuccessful applicants. I have a table...

Based on my post #21, I don't think I'll remove the new junction table, unless I'm completely wrong and you think there might be a better way to solve my problem on the form.

Oh, wait, I remember why I thought I needed it. Its because of the way the two table are related. The Awarded Grants table and the Fiscal Funding table were related by a one-to-many relationship using AwardedGrantID (in the Awarded Grants table) as the primary key and then using that number as...

Okay, sorry but your last reply may have a typo in it, did you mean to write "it would NOT be required" ? I think I'm going to remove the new junction table and see if everything still works. Thanks again :) Maria

"Project Ttiles - But wouldn't those be attached to the different Grants. It seemed to me that belong attached to the Grants and not the Applicaant because it's many Project Titles to one Applicant." The only thing with Project titles is if I only have them listed with the successful grants...

Also, why is ProjectTitle in the Junction Table (tblapplicantgrants)? I'm not sure if I indicated this anywhere, but All Applications will have ProjectTitles associated with them, but all those Projects may not be funded, and so only a portion of the Project titles end up associated with...

Okay, thank you so much! I do have some questions though. So, in the meantime I did use a combo box with subform to solve one of my problems, but I am still having an issue with the grantID (as you noted). I've attached a word doc with the error message I get, which I'm sure you are aware of...

lol yes it is, I think the excel file that you opened should help, I gave that to the guys in the other group discussion

Thanks Gina, I don't know a lot about Junction tables, and no it didn't come up in the other group discussion. My only concern is that when users fill out the form they don't have to use GrantID or InstitutionID's. I want them to be able to input InstitutionName's and I want the database to...

Okay, sorry about that, had help creating the databse in the "database design" group and can't link to that discussion, so I'll just answer your questions here. Fist, I've attached an excel file that holds some sample data, each sheet relates to a corresponding table in the database. 1. What...

Hi Gina, I already populated the entire database with private info, so can't upload the entire database. I was able to use the form wizard to create the form that I want, I've attached a new screen shot of the form. In form View I can select "new blank record" and it clears all fields, but...

Hi Guys, I'm in the process of creating two forms, each with a subform, that will be used to populate my tables. I've attached a screen shot of the relationships that exist between my tables and I've also attached a screen shot of one of the Form/subform's I created. The problem I'm having...

Nope, I didn't change the Data Entry property. I'll leave a note and link once I figure it all out.

Alright guys, Thanks so much for all of your help, I think I'm going to move on to the forms forum. For my purposes, Plog you were right, and I guess Rain you are as well, I'm creating a form to populate my tables, so I will need separate forms for each table. I did do that, I created a...

Also Rain, staying up till 2am and taking the time to help me out - did not go unnoticed...just saying thank-you to you and Plog for all of your help doesn't seem enough, but it's all I can do :) You guys are great people :)