Access 2007

Access 2007 removing completed data

I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?

Open Access 2007 files with Windows 2000 OS

Is there a reader that that will read .accdb files using a Windows 2000 operating system?

Access IIF Statement Not Returning All Records based on Option Group

I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is: ...

DateAdd Function

I have a dateadd function in a query Cdate:DateAdd("yyyy",[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that's not the problem. Now I need to run the query with...

Microsoft Access 2007 starting errors, tries to setup on each staring

I have install Microsoft Office Pro. on a computer. Everything opens up fine except for Access. When i click on access to open it wants to install not open.

MS Access Report modifications

I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field

Access Course/Student Database

I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with...

Access 2007 table versus forms

I use Access for contact mgmt. database. I have my "main" table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the main table?

printed out in Access to populate the box

I want to have a field where the date the form was printed out populte that box in Access 2007. How do I set this up?

How to use lookup query to return only entries matching the related field of active record

I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

Database Access 2007

Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can't any hint? When I go into my design mode those new fields do not apper?

Application.FileSearch no longer exists (in 2007)

My company is migrating to Office 2007 - I have VBA code that works wonderfully in "older" versions of Access, but will not work in 2007. One in particular is "Application.FileSearch" - what can I use instead? (And why was it removed??)

Subject: Limiting information in combobox

I have two comboboxes, one shows a list of customers, the other shows a list of contracts. One customer can have mutliple contracts, but a contract can only have one customer. I want to limit the contracts in the second combobox to only the contracts of the customer in the first combobox. I have...

Windows Sharepoint Servs 3.0 - Linking existing Access 2007 Database with new list.

Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting....

MS Access 2007 Author credit

I'm designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

Sending more then 1 Access Report to Outlook

Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

Combo search box - "Invalid Outside Proceedure"

..and before you ask, no I don't use anything linked into Access 2007 to program my database. So, I've been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my "search box" gets this error in my normal form. HELP!

Microsoft Access 2007 - Code for connecting two related forms, bringing up same record?

:sigh: My database suddenly requires me to have my forms appear as read-only's (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I've created a second form, mirroring the original, to be my...

Access 2007 Report OutputTo Print

Please help. This is driving me around the bend. I have a report that I OutputTo Rich Text format but my Percentage calculations do not survive the conversion from the report to the saved document. Please see: Has anyone encountered this before? I have many other reports and they all save...