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 the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
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 the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
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 [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
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 [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
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?
Answer Question
| April 1, 2009 2:19 PM
Access 2007, Access Custom Fields, Microsoft Access
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?
Answer Question
| April 1, 2009 2:19 PM
Access 2007, Access Custom Fields, Microsoft Access
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.
Answer Question
| March 29, 2009 6:11 PM
Access 2007, Access query, Microsoft Access
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.
Answer Question
| March 29, 2009 6:11 PM
Access 2007, Access query, Microsoft Access
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?
Answer Question
| March 20, 2009 7:25 PM
Access 2007, Access Database, Access Database Design, Access Database Format, Microsoft Access
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?
Answer Question
| March 20, 2009 7:25 PM
Access 2007, Access Database, Access Database Design, Access Database Format, Microsoft Access
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??)
Answer Question
| March 18, 2009 7:26 PM
Access 2007, Microsoft Access, Office 2007, VBA
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??)
Answer Question
| March 18, 2009 7:26 PM
Access 2007, Microsoft Access, Office 2007, VBA
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 set [...]
Answer Question
| March 12, 2009 8:58 PM
Access 2007, ComboBox, Microsoft Access, Microsoft Access 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 set [...]
Answer Question
| March 12, 2009 8:58 PM
Access 2007, ComboBox, Microsoft Access, Microsoft Access ComboBox
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 [...]
Answer Question
| March 13, 2009 3:18 PM
Access 2007, Access query, Microsoft Access, SharePoint, SharePoint 2007
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 [...]
Answer Question
| March 13, 2009 3:18 PM
Access 2007, Access query, Microsoft Access, SharePoint, SharePoint 2007
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. [...]
Answer Question
| March 17, 2009 4:11 PM
Access 2007, Microsoft Access, VBA, Visual Basic, Visual Basic for Applications
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. [...]
Answer Question
| March 17, 2009 4:11 PM
Access 2007, Microsoft Access, VBA, Visual Basic, Visual Basic for Applications
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?
Answer Question
| March 3, 2009 8:12 PM
Access 2007, Access Database, Microsoft Access
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?
Answer Question
| March 3, 2009 8:12 PM
Access 2007, Access Database, Microsoft Access
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
Answer Question
| February 20, 2009 1:00 PM
Access 2007, Access reports, Microsoft Access, 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
Answer Question
| February 20, 2009 1:00 PM
Access 2007, Access reports, Microsoft Access, Outlook
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!
Answer Question
| February 17, 2009 4:05 PM
Access 2007, Access errors, combo box, Invalid Outside Procedure, Microsoft Access
..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!
Answer Question
| February 17, 2009 4:05 PM
Access 2007, Access errors, combo box, Invalid Outside Procedure, Microsoft Access
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 edit form. My problem [...]
Answer Question
| June 8, 2012 3:44 AM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 permissions
: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 edit form. My problem [...]
Answer Question
| June 8, 2012 3:44 AM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 permissions
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 correctly with all calculations [...]
Answer Question
| February 10, 2009 5:08 AM
Access 2007, Access 2007 printing, Microsoft Access 2007 Reports, OutputTo, Rich Text Format
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 correctly with all calculations [...]
Answer Question
| February 10, 2009 5:08 AM
Access 2007, Access 2007 printing, Microsoft Access 2007 Reports, OutputTo, Rich Text Format
MS Access – Create Median Aggregate Function
Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I’m using 2007)? In particular, I want to create “Group By” queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it doesn’t work as a [...]
Answer Question
| October 27, 2009 5:30 PM
Access 2007, Access 2007 functions, Access Functions, Aggregate function, Median, Microsoft Access
Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I’m using 2007)? In particular, I want to create “Group By” queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it doesn’t work as a [...]
Answer Question
| October 27, 2009 5:30 PM
Access 2007, Access 2007 functions, Access Functions, Aggregate function, Median, Microsoft Access
Access 2007 – How to include option group on report
Hello, I’m new to Access so please consider this when forming your response. This has been driving me crazy and I’ve looked high and low on the ‘net for a solution. I look forward to your response. I have a form with an option group. I’ve wish to have this display on my report. Take [...]
Answer Question
| February 2, 2009 5:55 PM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports
Hello, I’m new to Access so please consider this when forming your response. This has been driving me crazy and I’ve looked high and low on the ‘net for a solution. I look forward to your response. I have a form with an option group. I’ve wish to have this display on my report. Take [...]
Answer Question
| February 2, 2009 5:55 PM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports
Monthly Average in Access 2007
Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible – my VB sucks Thanks Riaan
Answer Question
| January 30, 2009 11:53 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average
Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible – my VB sucks Thanks Riaan
Answer Question
| January 30, 2009 11:53 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average
Sum of Donations for current year
I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts — one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?
Answer Question
| January 21, 2009 5:42 PM
Access 2007, access 2007 preview and printing, Database programming, Microsoft Access 2007
I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts — one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?
Answer Question
| January 21, 2009 5:42 PM
Access 2007, access 2007 preview and printing, Database programming, Microsoft Access 2007
Crystal Reports can’t connect to Access 2007
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.
Answer Question
| January 8, 2009 8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.
Answer Question
| January 8, 2009 8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access
Minimize results in form.
I am trying to create an issue tracker for my company. The problem is that I have many contacts for each customer(Each contact will have their own record in the “customer” table). What I would like to be able to do is when I enter a new issue, I will select my customer from a [...]
Answer Question
| January 1, 2009 9:46 PM
Access 2007
I am trying to create an issue tracker for my company. The problem is that I have many contacts for each customer(Each contact will have their own record in the “customer” table). What I would like to be able to do is when I enter a new issue, I will select my customer from a [...]
Answer Question
| January 1, 2009 9:46 PM
Access 2007
