Need Help Importing Data
Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships...
Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships...
20 pts.
Access 2007 Report displaying the content of three different fields in one box?
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...
Modifying a module in Access 2007
I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly DoCmd.Close acQuery, "Query_1" DoCmd.OpenQuery "Query_2",...
I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly DoCmd.Close acQuery, "Query_1" DoCmd.OpenQuery "Query_2",...
Can't change Navigation Button Caption for subform
I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?
I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?
Highlight Query last executed
How do you modify Access 2007 access options to keep last query executed highlighted?
How do you modify Access 2007 access options to keep last query executed highlighted?
Access 07 Database to Import to Outlook 07
Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can't seem to find a way to do this. Can any help me? CC
Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can't seem to find a way to do this. Can any help me? CC
How to access and use subform data/calculations
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...
Can you help with the following DAO code explaining a step-by-step process?
I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...
I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...
How can I add Multiple Subdata Sheets to a single Table in Access 2007?
I'm attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata...
I'm attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata...
Rusty and Need Help
I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....
I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....
Access 2007 form from a query
I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by...
I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by...
Building A File Searching/ Tagging System
Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...
Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...
How do I Autopopulate a few field on my my form?
I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...
I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...
Split Databases - BE Structural Changes Version: 2007 (12.0)
Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?
Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?
Save Access 2007 format as 2000 format with VBA
how can i save the curent database as a 2000 format with vba
how can i save the curent database as a 2000 format with vba
access 07 help
i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help
i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help
MS ACCESS 2007 mass email list?
I was wondering is there a way to create a mass email from a query or table that would send out in MS OUTLOOK? I know of a way of extracting a table and importing it into OUTLOOK but my boss wants a more efficient way.
I was wondering is there a way to create a mass email from a query or table that would send out in MS OUTLOOK? I know of a way of extracting a table and importing it into OUTLOOK but my boss wants a more efficient way.
microsoft access 2007 & Outlook 2007
Hello, I am running office package 2007. I was wondering if anyone has found a way that i could set reminders in access 2007 and i would get a reminder email when the time comes closer. I was also wondering if access could auto pull from a date catagory and set it to have outlook send a message...
Hello, I am running office package 2007. I was wondering if anyone has found a way that i could set reminders in access 2007 and i would get a reminder email when the time comes closer. I was also wondering if access could auto pull from a date catagory and set it to have outlook send a message...
CSV data into Excel 2007
Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a...
Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a...
Microsoft Access - Find and Replace Issue
In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...
In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...
