Access 2003 report printing
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
Password in Delete Button in MS Access 2007
How to set a password in command button “Delete” in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !!
Answer Question
| February 22, 2011 12:43 PM
Access 2007, Access 2007 functions, Access 2007 security
How to set a password in command button “Delete” in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !!
Answer Question
| February 22, 2011 12:43 PM
Access 2007, Access 2007 functions, Access 2007 security
How to make Access 2007 database GUI
i need help.. i have created a small database, now my problem is i would like to build it in a more software-like interface, no more tools or any options of some sort from ms access to display but only the navigation form which i designed is there any developer tools required? thank you in [...]
Answer Question
| February 18, 2011 8:12 AM
Access 2007, Access 2007 functions, GUI, GUI developers
i need help.. i have created a small database, now my problem is i would like to build it in a more software-like interface, no more tools or any options of some sort from ms access to display but only the navigation form which i designed is there any developer tools required? thank you in [...]
Answer Question
| February 18, 2011 8:12 AM
Access 2007, Access 2007 functions, GUI, GUI developers
Hyperlinks in forms sent from Access 2007 to Sharepoint 2007
Hi, I send files from Access 2007 to Sharepoint 2007 daily. The first column of data in the Access file is a hyperlink, and appears as one(htt:…..). When I send the file to our Sharepoint sight I would like it to appear as an image of our logo in that field, instead of the url. The link [...]
Answer Question
| January 28, 2011 3:52 PM
Access 2007, Access 2007 functions, SharePoint, SharePoint 2007, SharePoint 2007 interoperability
Hi, I send files from Access 2007 to Sharepoint 2007 daily. The first column of data in the Access file is a hyperlink, and appears as one(htt:…..). When I send the file to our Sharepoint sight I would like it to appear as an image of our logo in that field, instead of the url. The link [...]
Answer Question
| January 28, 2011 3:52 PM
Access 2007, Access 2007 functions, SharePoint, SharePoint 2007, SharePoint 2007 interoperability
Converting from Access 2003 to Access 2007
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]
Answer Question
| January 17, 2011 5:05 PM
Access, Access 2003, Access 2007, Access Database
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]
Answer Question
| January 17, 2011 5:05 PM
Access, Access 2003, Access 2007, Access Database
Multiple user login in one Access 2007 database
I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. [...]
Answer Question
| January 3, 2011 10:55 AM
Access 2007, Access 2007 functions, Access Database
I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. [...]
Answer Question
| January 3, 2011 10:55 AM
Access 2007, Access 2007 functions, Access Database
In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups
How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved? How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?
Answer Question
| March 11, 2011 12:00 PM
Access 2007, Backup and restore, Backup server hardware, Excel 2007, Windows XP Professional
How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved? How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?
Answer Question
| March 11, 2011 12:00 PM
Access 2007, Backup and restore, Backup server hardware, Excel 2007, Windows XP Professional
Progressive Incident ID number in Access 2007
I have a db that records each security infraction at a library. The desired ID number for it is year/month/day/number of event that particular day (example, 2010/12/01-1 for the first event, 2010/12/01-2 for the second, etc.) My question: I have this — 0000/00/00-0;_;;_ — as the format for people to enter, but is there a [...]
Answer Question
| December 3, 2010 9:36 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access Functions
I have a db that records each security infraction at a library. The desired ID number for it is year/month/day/number of event that particular day (example, 2010/12/01-1 for the first event, 2010/12/01-2 for the second, etc.) My question: I have this — 0000/00/00-0;_;;_ — as the format for people to enter, but is there a [...]
Answer Question
| December 3, 2010 9:36 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access Functions
Need project plan for Access 2007 database migration to SQL Server
project plan with steps outlined
Answer Question
| January 12, 2011 5:36 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration
project plan with steps outlined
Answer Question
| January 12, 2011 5:36 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration
Find Due Date From X months in Access 2007
I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date? Please use [...]
Answer Question
| November 18, 2010 5:35 PM
Access 2007, Access Database, Access Database Design, Access Database Format
I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date? Please use [...]
Answer Question
| November 18, 2010 5:35 PM
Access 2007, Access Database, Access Database Design, Access Database Format
Putting object description in Access 2007 navigation panel
how do i get the object desc. to show in the navigation panel?
Answer Question
| November 15, 2010 4:12 PM
Access 2007, Access 2007 functions, Access Functions, Access Navigation Pane
how do i get the object desc. to show in the navigation panel?
Answer Question
| November 15, 2010 4:12 PM
Access 2007, Access 2007 functions, Access Functions, Access Navigation Pane
Query by character length in Access 2007
I am wanting to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?
Answer Question
| October 29, 2010 1:36 PM
Access 2007, Access 2007 form creation, Access query, Query Calculation
I am wanting to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?
Answer Question
| October 29, 2010 1:36 PM
Access 2007, Access 2007 form creation, Access query, Query Calculation
ACCESS 2007 setting up repetitive entry form
I’m doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?
Answer Question
| November 19, 2010 6:24 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
I’m doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?
Answer Question
| November 19, 2010 6:24 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
Creating Automatic Notifications in Access 2007
I am building a volunteer database. I have a table tracking hours that each volunteer has put in, and would like to be notified when they reach certain milestones, (eg, 25 hours, 50 hours, 100 hours), so that we know who to thank appropriately. I believe that I will need a query totaling the hours [...]
Answer Question
| October 27, 2010 5:47 PM
Access 2007, Access 2007 functions, Access query, Automated notifications
I am building a volunteer database. I have a table tracking hours that each volunteer has put in, and would like to be notified when they reach certain milestones, (eg, 25 hours, 50 hours, 100 hours), so that we know who to thank appropriately. I believe that I will need a query totaling the hours [...]
Answer Question
| October 27, 2010 5:47 PM
Access 2007, Access 2007 functions, Access query, Automated notifications
Create a Flat File from Access 2007 Database
How do I create a flat file from a MS Access database. Also, there are some other requirements, (1) a numeric data field must have a “sign (+ or -)” in the first position and the data field must be “right justified” and (2) another numeric data field must be “zero filled” and right justified.
Answer Question
| October 27, 2010 1:16 AM
Access 2007, Access Database, Flat files, Windows 7
How do I create a flat file from a MS Access database. Also, there are some other requirements, (1) a numeric data field must have a “sign (+ or -)” in the first position and the data field must be “right justified” and (2) another numeric data field must be “zero filled” and right justified.
Answer Question
| October 27, 2010 1:16 AM
Access 2007, Access Database, Flat files, Windows 7
ACCESS 2007 setting up repetitive entry form
I’m doing a database for our transportation company. I need help with setting up expenses for multiple vehicles. We want to be able to enter for reporting monthly gas, repairs, license, etc.. Want to be able to enter 50 gas receipts for one vehicle a few times a month. Reports will be monthly with a [...]
Answer Question
| October 27, 2010 9:17 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access Database Design, Windows XP
I’m doing a database for our transportation company. I need help with setting up expenses for multiple vehicles. We want to be able to enter for reporting monthly gas, repairs, license, etc.. Want to be able to enter 50 gas receipts for one vehicle a few times a month. Reports will be monthly with a [...]
Answer Question
| October 27, 2010 9:17 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access Database Design, Windows XP
Access 2007 database design question
I am designing a database for our transportation company and want to track per vehicle expenses, ie gas, repairs, license fees, etc
Answer Question
| October 26, 2010 5:41 PM
Access 2007, Access 2007 form creation, Access 2007 functions, Access Database Design, Windows XP
I am designing a database for our transportation company and want to track per vehicle expenses, ie gas, repairs, license fees, etc
Answer Question
| October 26, 2010 5:41 PM
Access 2007, Access 2007 form creation, Access 2007 functions, Access Database Design, Windows XP
Green Boxes in Access 2007 form after deleting O’s & 1′s from database
I have a database tracking the information turned in on a hard copy form. If a patient triggers specific questions the data must be input: so if someone triggers the depression, I in their suicide rating, treatment plan, etc… I have the access form use check boxes but the data base use -1′s. I need the [...]
Answer Question
| October 27, 2010 2:54 PM
Access, Access 2007, Access 2007 forms, Access 2007 functions, Access Database
I have a database tracking the information turned in on a hard copy form. If a patient triggers specific questions the data must be input: so if someone triggers the depression, I in their suicide rating, treatment plan, etc… I have the access form use check boxes but the data base use -1′s. I need the [...]
Answer Question
| October 27, 2010 2:54 PM
Access, Access 2007, Access 2007 forms, Access 2007 functions, Access Database
Multiple identical relationships in one Access 2007 table
I am building a volunteer contact management database. I have a table titled “Volunteers” that contains contact information fields and links to other databases with information about hours accrued. The Primary Key in this table is “VolunteerID”. I want to somehow be able to associate different volunteers with each other in “Households”, another table. My [...]
Answer Question
| October 26, 2010 10:09 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions
I am building a volunteer contact management database. I have a table titled “Volunteers” that contains contact information fields and links to other databases with information about hours accrued. The Primary Key in this table is “VolunteerID”. I want to somehow be able to associate different volunteers with each other in “Households”, another table. My [...]
Answer Question
| October 26, 2010 10:09 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions
Look up values from a table that refers to a range of records in Access 2007
My company is converting the account codes and I am verifying that each code has been assigned a new one. I was given 2 tables: 1 with current account codes, and the other provides the new code by range of current account codes. For example, if the current code is 1225, the conversion table would [...]
Answer Question
| October 18, 2010 3:16 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions
My company is converting the account codes and I am verifying that each code has been assigned a new one. I was given 2 tables: 1 with current account codes, and the other provides the new code by range of current account codes. For example, if the current code is 1225, the conversion table would [...]
Answer Question
| October 18, 2010 3:16 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions
