Search results

I figured out another method. What I did was create a query for each department. Because I created the departments table as a lookup, the primary key was pointing to tbl DepartmentsID field and not the DepartmentName field. So what I did for the expression was made the criteria a number that...

Im completely stumped. :mad: :mad: I see no typo what so ever. I've changed the expression to [Specific Department Query]![Department] and after that, I get a complete list of all departments and data ports but still unable to figure out how to get a drop down list to prompt me what...

Sorry opps :) Came up with Enter Parameter Value Forms!Department Form!DepartmentName With an empty box to enter info Regardless or what I type, after clicking ok, I get 2 fields of Data Port & Employee but with no records displaying Hope this helps

Ok, now Im a bit confused. This is what I put: Where DepartmentName = [Forms]![Department Form]![DepartmentName] Or IsNull([Forms]![Department Form]![DepartmentName]) and that didnot work. Here is some more info I have a total of 12 departments. 2 are called "ARCH" & "Administration" I...

I've got a db on the go and am stuck on one thing. Its an inventory db with PC hardware, dataports, employees and departments. Im able to make querys with all departments and dataport but how do I create a query that prompts me for which department I want listed and then shows the results by...

Great...Thanks alot. Just what I wanted.

Can anyone link me to a site that has examples of control source expressions? I've created a db with several reports that sum up total number of parts but because I used the Yes/No format in my table, all the yes's equal -1 and I have negative numbers that I want displayed as positives. Please...

haaaaa. ... Great..I got it. Thanks

I have a question regarding background pictures. I'm doing a data base with 410 records. Without any background picture the file is 400KB. As soon as I add the picture, it jumps up to 36MB. When I first started the database, even with like 10 records, the file jumped up to 72MB until I ran...

OK, looks like I'll have a look under the help file now that I know what it's called Im looking for. Thanks

I want to make a switchboard that opens up to another switch board that contains 5 different departments for a database at work. Can anyone help me create one? Is there also a website that I could use with sample graphics I can use in a switchboard? Thanks Im using Access 2003

Hi, Im new to this so please bear with me. :) I hope this is the right section to post this. Im trying to create an inventory database for PC's at work. Is there a way I can total the number of yes/no values to determine the total number of pieces of hardware? I'd also like to be able to...