1
Create Button to Open Specific Form
I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am [...]
Answer Question
| May 22, 2013 2:27 PM
Access 2007, Access 2007 forms
I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am [...]
Answer Question
| May 22, 2013 2:27 PM
Access 2007, Access 2007 forms
Tie Access Query results to Form Entry
I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.
Answer Question
| February 28, 2012 5:39 PM
Access 2007 forms
I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.
Answer Question
| February 28, 2012 5:39 PM
Access 2007 forms
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 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
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
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
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
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
Increasing text in Access 2007 without losing info
I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters [...]
Answer Question
| May 19, 2011 11:47 PM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters [...]
Answer Question
| May 19, 2011 11:47 PM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
Access 2007: Create a form for both display and data entry purposes
How can I create a form that is autofilled with data from a query (such as a client’s ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a [...]
Answer Question
| August 4, 2010 2:23 AM
Access 2007 form creation, Access 2007 forms
How can I create a form that is autofilled with data from a query (such as a client’s ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a [...]
Answer Question
| August 4, 2010 2:23 AM
Access 2007 form creation, Access 2007 forms
How to enter a field with number increments in Access 2007
How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)
Answer Question
| August 6, 2010 10:01 PM
Access 2007, Access 2007 forms, Access 2007 functions
How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)
Answer Question
| August 6, 2010 10:01 PM
Access 2007, Access 2007 forms, Access 2007 functions
Access 2007 Recurring Jobs
How can I create a form that allows a user to create recurring (eg: weekly, daily, monthly) appointment/job in access 2007?
Answer Question
| July 14, 2010 2:05 AM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
How can I create a form that allows a user to create recurring (eg: weekly, daily, monthly) appointment/job in access 2007?
Answer Question
| July 14, 2010 2:05 AM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
How to eliminate double-entry in Access
I’m using Access as a scheduler to schedule clients for my business. Each client has a unique and customized schedule. How can I eliminate extra work for myself everytime I schedule/cancel a client. Is there an easier way to do this? Also, clients sign up online and then I enter into Access. Is there a [...]
Answer Question
| May 12, 2010 8:09 PM
Access 2007 forms, Microsoft Access, Microsoft Access import/export
I’m using Access as a scheduler to schedule clients for my business. Each client has a unique and customized schedule. How can I eliminate extra work for myself everytime I schedule/cancel a client. Is there an easier way to do this? Also, clients sign up online and then I enter into Access. Is there a [...]
Answer Question
| May 12, 2010 8:09 PM
Access 2007 forms, Microsoft Access, Microsoft Access import/export
Is it even possible to store calculated data in access 07
my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx
Answer Question
| February 4, 2010 3:32 PM
Access 2007, Access 2007 forms, Microsoft Access 2007 Reports
my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx
Answer Question
| February 4, 2010 3:32 PM
Access 2007, Access 2007 forms, Microsoft Access 2007 Reports
Access Tab Control Problem
I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” and it would open the form I wanted. I have however changed the form to put my subforms into tabs. Now “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” will not work. [...]
Answer Question
| July 28, 2010 6:30 PM
Access 2007 forms, Access Forms Database, Microsoft Access 2007
I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” and it would open the form I wanted. I have however changed the form to put my subforms into tabs. Now “[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]” will not work. [...]
Answer Question
| July 28, 2010 6:30 PM
Access 2007 forms, Access Forms Database, Microsoft Access 2007
Access 2007: VB code to make a button press link to a specific record in another form
The database is for a set of components. One of my forms shows details about each component on a separate record (the property “Default View” is Single Form). The other form is a list of all components by component number displayed all together (the property “Default View” is Continuous Forms). The list of components has [...]
Answer Question
| November 25, 2011 9:59 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
The database is for a set of components. One of my forms shows details about each component on a separate record (the property “Default View” is Single Form). The other form is a list of all components by component number displayed all together (the property “Default View” is Continuous Forms). The list of components has [...]
Answer Question
| November 25, 2011 9:59 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
1
