Replace data in a text file using Access 2007
I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!
Answer Question
| February 28, 2012 7:22 PM
Access 2007 functions, text files
I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!
Answer Question
| February 28, 2012 7:22 PM
Access 2007 functions, text files
Access 2007 creating a menu
I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access functions. What do [...]
Answer Question
| March 31, 2012 5:41 PM
Access 2007, Access 2007 forms, Access 2007 functions
I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access functions. What do [...]
Answer Question
| March 31, 2012 5:41 PM
Access 2007, Access 2007 forms, Access 2007 functions
Access 2007 database query question
I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd [...]
Answer Question
| August 17, 2011 11:39 AM
Access 2007, Access 2007 functions, Access Database, Access query, QuerySave
I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd [...]
Answer Question
| August 17, 2011 11:39 AM
Access 2007, Access 2007 functions, Access Database, Access query, QuerySave
Access 2007 button addition
Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up [...]
Answer Question
| March 24, 2011 1:43 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access forms
Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up [...]
Answer Question
| March 24, 2011 1:43 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access forms
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
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
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
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
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
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
Access 2007 printing
I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.
Answer Question
| October 13, 2010 12:21 AM
Access 2007, Access 2007 functions, Access 2007 printing, Access errors, Microsoft Access printing
I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.
Answer Question
| October 13, 2010 12:21 AM
Access 2007, Access 2007 functions, Access 2007 printing, Access errors, Microsoft Access printing
MS Access 2007 IIF expression
I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it’s pulling all records with all court dates that is greater than today’s date. I want the report to show just the next court date for each client. Is there an expression can I use [...]
Answer Question
| October 20, 2010 8:17 PM
Access 2007, Access 2007 functions, Access query, IIF function
I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it’s pulling all records with all court dates that is greater than today’s date. I want the report to show just the next court date for each client. Is there an expression can I use [...]
Answer Question
| October 20, 2010 8:17 PM
Access 2007, Access 2007 functions, Access query, IIF function
Visual Basic Email Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
Outlook 2007 templates in Access
I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I [...]
Answer Question
| September 13, 2010 4:52 PM
Access 2007, Access 2007 functions, Export Access to Outlook, Outlook 2007
I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I [...]
Answer Question
| September 13, 2010 4:52 PM
Access 2007, Access 2007 functions, Export Access to Outlook, Outlook 2007
