Search results

Oh, whops sorry :0) The Employee File has the Page Tab control on it. So when ever the user clicks the "Transaction" tab I want it to run the query and bring back all transactions that have the same EmployeeID.

Hello, I need to make a query that runs every time a record is opened. Basically I have: Transaction: Conversion (Contains an EmployeeID field) Employee File: (Prim. Key is EmployeeID) Events: User is on the Employee File Form. They Select the tab that is Listed "Transactions" Query runs...

I'm going to bump this - I'm still stuck. :(

Hehe sorry! Okay, so I think my tables may be setup incorrectly... I've been reading about database theory. This is how I have it setup now though: The table has three main sections: 1. Tracking Transactions 2. Tracking Requisitions 3. Employee File These are then broken down into types...

No - they're two different types of transactions that require differen't information. It's best if they are seperated. I only showed you that those to tables exsisted to illustrate that once this is solved, I'll have to apply it to another table. :0) My intention is to have the user select...

Hello! I've been reading books and searching the net for an answer to my question.... and I've only been confusing myself more. I'm trying to design a part of my database and it breaks down like this: Tables: Transaction: Conversion * Contains a lookup field that pulls from the...

Oh.. I see it thanks! :0) One more question.... is it possible to disable the ribbon? Thanks!

Where can I find this in Access 2007? I'm just not seeing it :/

Okay, so for some reason it isn't working still. I have 73 Req's that have the status of "Approved" - Most of which are addition. When I run my query based off of the parameter of "Addition" it pops up with only 10 requestions. This just isn't right.... and I'm not sure what is happening. Here...

Oh! "IN" was what I needed. Thanks a ton :0)

Hello! So, I would like to create a query that asks for a parameter, and runs that parameter against specific types. Let me give you an example: Status: I have a total of four status types that a Requisition can have. For this particular query, I want it to be ran for only 2: Pending and...

Hello! I want to name my reports based off of the parameter that the user picks. So for a Status Report I would like it to say: Requestion: Closed ... with Closed being the parameter. Is there anyway to do this? If so, how? Thanks!

So, here's some stupid questions: 1. Make sure the form is bound to the table How do I do that? I've taken the controls from the table and "dragged / dropped" them onto the form. Does that equate to the same thing? 2. Why do I want to stop it from being a modal form? 3. If you want to then...

Hello! I was hoping someone could help me solve my problem. I may just be having a stupid day. :0) I've created a modal to basically work as a quick add for an employee into the database. Essentally, it'll have two buttons (OKay and cancel). How do I tell the Okay button to add the...

Oh! Wow..... I would of never of figured that out! Thanks you two :)

How do I get to the form's properties? I can get to the Form Header, Detail and Footer... However, I"m not seeing the option on either of those 3. Is there a form Property for the form as a whole? Thanks!

Hello! So, I have a situation. I have 7 different tables (Types of Transactions) that I want to be able to view in a single form. (via the page feature). I know that I can create a subform, however when I do that it has the little scrolly Record thing at the bottom of the page. Is there...

Hello! I was wondering if anyone knows of a Query Formula cheat sheet? Thanks!

Nevermind, I found it! Thanks so much :)

I have the code working for when the combo box is updated... I just need to have it check the code when the record is loaded. Stupid question - How do I get to the "on Current" event for the record? :) Thanks!