Search results

Hello, I’m using Access database to track projects and checks. Projects and checks have a many-to-many relationship joined through a juncture table. Tbl_Projects (PK ProjectID) Tbl_Checks (PK CheckID) Tbl_ProjectChecks (PK ProjectCheckID) I have a main form/subform...

Hi, I am using Access 2007 and need to create a query that returns projects containing “BT” in their Project ID field. The Project ID has a set format. How would I construct the query to return all of the following Project IDs? TG-BT-01 JJ-BT-09 HGF-BT-12 The dashes and the varying number of...

My 2007 database stores projects and the contracts on which they go. Each contract has several options, one for each fiscal year that the contract spans. Here is my table structure: Tbl_FiscalYear (lookup for fiscal years) FiscalYearID FiscalYear Tbl_Projects ProjectID ProjectName...

My Access 2007 database tracks projects which get obligated onto contracts. Projects and obligations have a many-to-many relationship, since one obligation can obligate multiple projects and one project may require multiple obligation actions to be fully obligated. The projects and obligations...

Hello all, My Access 2007 database is growing quite large (although well below Access's 2 GB limit). I am aware of the dangers posed by corruption and am taking steps to reduce that possibility. But can a database's sheer size ever threaten the integrity of the data? Thanks!

Hello, I used Access 2007 to build a database that tracks projects. All projects are listed in tbl_Projects: tbl_Projects ProjectID (PK) ProjectTitle Each project has three types of agencies associated with it. One type of agency works the actual projects. The second type approves the work...

Working in Microsoft Access 2007. I have two tables, a table listing projects and one listing POCs. tbl_Projects Project Number Project Manager Resource Manager tbl_POC POC ID POC First Name POC Last Name The Project Manager and Resource Manager fields from tbl_Projects are set as Lookup...

I am using Access 2007. My database tracks contracts spanning across multiple years, and data about these years are stored in tbl_Contract Years. Fields include Contract Number, Fiscal Year, Year Number (whether it’s the 1st, 2nd, or 15th year), and Year Cost. Therefore, if Contract A was...

Hi all, I am using Access 2007. I am using a query by form to specify a parameter for a report (the year). The form has two controls, a combo listing the years and a button to call the report. I really want the form to close automatically once the user presses the button and calls the...

I am using Access 2007 and have created a juncture table to accommodate a many-to-many relationship between projects and checks in my database. The juncture table contains foreign keys of both the ProjectID PK from tbl_Projects and the CheckID PK from tbl_Checks. I use a data-entry form to...

Using Access 2007, I need a report that serves as a ledger. The database tracks a bank account used to pay for projects. The account receives deposits, and I write checks against the account to pay for the projects. The account has a one-to-many relationship with the deposits (the credits of...

Hi all, I am using Access 2007 and I am trying to create a tabbed report. I tried doing this by adding a Tab Control in the Design section and then inserting a report on each of the tabs. Both of the reports are based on parameter queries, and when I try to open the form in Form View, Access...

I am using Access 2007. I have two tables, tbl_PROJECTS and tbl_CHECKS. Tbl_PROJECTS has a ProjectID field and Project Name field. Tbl_CHECKS has a CheckID and Check Number field. These tables are connected in a many-to-many relationship through a juncture table called tbl_Projects Checks mm...

Hi all, I have a table, tbl_Account Years, which stores annual financial data for several bank accounts. I have a primary key ID field (AutoNumber), an Account Number field, a Year field, and an Amount field. This allows the user to store what each account had for each year. I want a form...

I have a form to enter bank info, and a combo on this form (cbo1) lists bank directors. The combobox is based on tbl_Directors containing three fields: DirectorID (AutoNumber), LastName, and FirstName. Cbo1 has two columns, DirectorID (the bound column, not shown) and an expression that displays...

Hello all, I am using Access 2007 and have a form to enter debit and credits for a bank account. I have an unbound combo box named "Transaction" and it contains 2 options, Debit and Credit. There is also an "Amount" text box in which to enter the debit or credit amount. When the user selects...

Hello! I have a main form based on a “Projects” table and a subform based on the related “Funding Documents” table. The main form has three comboboxes: Year, Management Office, and Project Number. Values displayed in the Project Number combobox are limited by what the user selects in the Year...