Search results

Hey all, I'm just looking at the QBE window in Access 2007 and noticed that there is Criteria which is where I would normally put things like >100. However, if you activate the Totals row, you can use the drop down menu to select "Where". Can anyone tell me the difference between Criteria...

No, I have one table with courses linked to one table with course detail (so I can define years, cohorts etc for each course) then I am attaching modules to the applicable record in course detail. Hope that makes sense! -NS

Many thanks pbaldy. I actually found a different way of doing it without having to sue junction tables. I just added a Course Detail table for each instance of a course and made a 1-to-Many relationship with Modules. Thanks, -NS

Hey all, I have table tblCourse, tblJunction, tblModule. This is to break up the many-to-many relationship between Course and Module. However, i'm not creating the forms that would allow the user to "attach" modules to a course but i'm stuck! I am trying to use a form/subform (form being...

Many thanks for your answer rodmc. I'll use forms/subforms!

Hey all, I'm attempting to create a database and a little help :) I understand how to create tables, PKs, FKs etc. However, in the past I have used Access's Lookup Function to enable me to populate the tables with data in a datasheet view. I've read (and been told) that this is not ideal...

Hi, I've tried the junction table and it seems to work. I would now like to build on this and enable the users to "attach" modules to each course. I already have populated courses and modules tables with data. What I'd like is a combobox within a subform that will let me select a module code...

Many thanks Mr B. I'll have a go with your suggestion. -NS

Hey all, I'd like to create a database that stores college courses and associated modules. I have the basic layout of a Courses table and a Modules table but here is the issue....I'd like to be able to create a predefined list of Modules that I can then "attach" to a particular Course...

OK, thanks for your help :)

Sorry Paul, I didn't mean the results to be PUT in a table but rather to just be displayed (similar to when you run a basic query, the result is just displayed in a table view). thanks, -ns

Thanks for that pBaldy. Do you have a technique if I don't want the results to be in a report bu rather just in a table? -NS

Hey all, Really hope someone can help on this! I have a database with cars listed, each car having its specific details. What I would like is a way to select on a menu form multiple cars and then to click a button to run a query on the cars selected (which would return the cars details). I can...

Hey all, Just wondering if anyone on here has experience of creating their own MS Outlook forms? I'm basically after 2 answers... 1) I'd like to complete a form and send it. When the recipient opens the email, I'd like them to see the form straight away (not the form as an attachment). Is this...

Thanks for your reply. I've had a look and I dont really want to do anything as complicated as a search form. All I really need is to be able to select an Employee Number from a combo box and have the related employee details be displayed (not even in a subform or anything). Thanks, -NS

Hey all, This is probably very simple but I cant seem to figure it out!... I have 1 form (Employee Details which is based on one table of same name). On this form I have employee number, forename, surname, grade etc. The form works fine and I can search thru the records. However, all I want...

Thanks for the reply. I am using Access 2007. What I mean is, when you turn totals on in the QBE screen, you get a new row called "Total" just beneath the "Table" row. In this "Total" row, you can select things from the dropdown menu for example, Sum, Count etc. One of the options in WHERE...

Hey all, I'm currently learning Access and have created a little bit confusion for myself! Basically, when creating a query to find every person in my database with a surname of "Smith", I would put this in the criteria field. This works great. However, if you turn totals on, you get the WHERE...

lol funny you should mention that. The username on this comp is actually Admin, so it may not work after all! I will try and get your way working....I checked the module, should it be a normal module or a class module?

Not that I know of, the extension is .accdb and I havn't touched any security settings. Very strange.