Search results

Problem solved. I had a calculation that was being conducted regardless of whether or not a field was blank. Sorry folks! Typing out my problem helps!

I almost always do. So I understand whats going on. But as of yesterday I started just building everything as a query and copy and pasting the sql it produces when Im ready.

SBWolfe54, Thanks. After much battling, I got it sorted out. I don't why I try to manually code these things, Access design mode makes my life so much easier!

Hi folks, So I've been looking around both my code and online to see if I can figure out whats causing this little irritation. I have a form with a tab control with a subform on each page. The subforms are continuous and display subtables to the master record held on the main form. If the...

Until someone corrects me I will handle this with WHERE: SELECT tblGuidelines.pedGuide, tblGuidelines.pedTitle FROM tblGuidelines, tblCourseRecordPedMarking WHERE tblGuidelines.pedGuide=[tblCourseRecordPedMarking].[pedGuide] AND tblCourseRecordPedMarking.CourseRecordID = 1; EDIT: Wait...

Hey folks, So access doesn't take outer joins I take it. I have three tables. tblGuidelines which contains the primary key pedGuide tblCourseRecords which contains a list of courses with the primary key courseRecordID and tblCourseRecordPedMarking which is related to tblCourseRecords...

Hi folks, So I'm trying to combine data from 4 tables, but to start im just trying to make sure my joins are set up properly. The idea is to have all the rows from the first table regardless of whether data is present on the other tables and join the other tables where there is data. So...

Right form good to go, works well. adds a record for each line, looks cleaner than the old one and i can still maintain the code relationship by having the subform in continuous view. Now the challenge is getting this bad boy to export coherently to excel.

Okay so I think I got it. I removed the field CourseRecordPedID that you suggested earlier. And I made tblCourseRecordPedItems the junction table joined to tblCourseRecords by CourseRecordID and to tblGuidelines by pedGuide These fields are all PKs. Seems to do the trick in table view. Going...

Thanks Bob, Going to do some reading on junction tables. I'll let you know when I figure it out!

Hmm how would I go about creating single line record entries for each courserecord then? I have related all the tables to get all the info I need, but I still end up with a record for each pedagogical item. I'm assuming there's no way to do this in SQL and I'm going to have to code the export...

I expect so. I'm just playing with the SQL now to see what a joined record would look like.

Ok so I like these recommendations in terms of table structure. However, this would mean having to create an add pedagogical item button to the form, rather than have all available pedagogical items displayed. It's a design I don't think is the most user/time friendly but doable. The next issue...

Thanks a lot Bob.

Bob, Here it is. Forgive my interface, it's still crude and needs a lot of refinement, a lot of whats there is placeholder. Also, the black bar has the program logo in it so its not as terrible as it seems. I can see creating another table linked to the tblcourserecord primary key for each...

I was just thinking that. Whats the best way to go about that? Post the database?

I'm not entirely sure that would work for my purposes. If there are 4 pedagogical items and the user creates a fifth, I still need a new row to be automatically created. Also, as each course can have multiple sections within one semester, and the same section across multiple semesters the...

So its better to create a maximum number of items, say 10-15 rows of textboxes for each category, hide them all, and use lookups and loops to cycle through them, assign them names, bindings, and visibility?

Bob, when you say "lifetime" of the form, you mean the current instance? As in if I were to add remove/add controls once each time the form is loaded there should be no problems. What am I losing by not being able to compile the db?

just use a dlookup to check to see if the username matches the password and if it does update the record.