IF and then statement in query
I’m having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don’t know VBA
Answer Question
| May 15, 2013 6:03 PM
Microsoft Access 2007, VBA
I’m having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don’t know VBA
Answer Question
| May 15, 2013 6:03 PM
Microsoft Access 2007, VBA
Access 2007 query with null values
I am currently creating an Access 2007 database for calculating salesperson commissions. I have a table with 5 fields I’m working with: SalesRep, SOWRep, TerritoryRep, Period and Commission. I am trying to build a query that will calculate commission for a salesperson for each record where their name appears in one of the first three [...]
Answer Question
| April 17, 2013 6:29 PM
Microsoft Access 2007, Microsoft Access query
I am currently creating an Access 2007 database for calculating salesperson commissions. I have a table with 5 fields I’m working with: SalesRep, SOWRep, TerritoryRep, Period and Commission. I am trying to build a query that will calculate commission for a salesperson for each record where their name appears in one of the first three [...]
Answer Question
| April 17, 2013 6:29 PM
Microsoft Access 2007, Microsoft Access query
MS Access 2007 functions
Can someone please help me with the expression for the IFF function?
Answer Question
| April 17, 2013 10:26 AM
Microsoft Access 2007, Microsoft Access function
Can someone please help me with the expression for the IFF function?
Answer Question
| April 17, 2013 10:26 AM
Microsoft Access 2007, Microsoft Access function
Access 2007 – All Access Object Forms Section – Collecting data using email
In the forms section under the All Access Objects section, I am trying to collect data by using e-mail messages. I am trying to send this form out to a group of individuals and then I would want them to return that information to my email. From there I want to export that information from [...]
Answer Question
| April 3, 2013 8:45 PM
Microsoft Access 2007, Microsoft Access forms
In the forms section under the All Access Objects section, I am trying to collect data by using e-mail messages. I am trying to send this form out to a group of individuals and then I would want them to return that information to my email. From there I want to export that information from [...]
Answer Question
| April 3, 2013 8:45 PM
Microsoft Access 2007, Microsoft Access forms
Need help writing query-I’m stumped!
I have a table that looks like this: ID EEID DR CR 1 333 30 2 333 50 3 333 30 4 333 30 5 444 60 6 444 60 7 444 70 ID is my primary key column and it auto numbers the records. EEID is a person, and there are many records per [...]
Answer Question
| April 1, 2013 7:37 PM
Microsoft Access 2007, Microsoft Access query
I have a table that looks like this: ID EEID DR CR 1 333 30 2 333 50 3 333 30 4 333 30 5 444 60 6 444 60 7 444 70 ID is my primary key column and it auto numbers the records. EEID is a person, and there are many records per [...]
Answer Question
| April 1, 2013 7:37 PM
Microsoft Access 2007, Microsoft Access query
How do you create an order form where you can enter multiple product line items?
I am trying to make an order form in the data base for product. I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form. I am [...]
Answer Question
| April 1, 2013 6:29 PM
Microsoft Access 2007, Microsoft Access forms
I am trying to make an order form in the data base for product. I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form. I am [...]
Answer Question
| April 1, 2013 6:29 PM
Microsoft Access 2007, Microsoft Access forms
MS Access 2007
How we add 26 years in today date and answer will be 19-03-2039?
Answer Question
| March 19, 2013 12:20 PM
Microsoft Access 2007, Microsoft Access features
How we add 26 years in today date and answer will be 19-03-2039?
Answer Question
| March 19, 2013 12:20 PM
Microsoft Access 2007, Microsoft Access features
Access 2007 before update option
For an input form, how to create a simple code for the before update option and notify user that the new entry number in already in the database.
Answer Question
| March 18, 2013 7:27 PM
Microsoft Access 2007, Microsoft Access database
For an input form, how to create a simple code for the before update option and notify user that the new entry number in already in the database.
Answer Question
| March 18, 2013 7:27 PM
Microsoft Access 2007, Microsoft Access database
Microsoft Access database design question
I created a database. I am in the middle of populating with data but see some records that were inputted are no longer there. How can this happen?
Answer Question
| March 5, 2013 6:06 PM
Microsoft Access 2007, Microsoft Access database
I created a database. I am in the middle of populating with data but see some records that were inputted are no longer there. How can this happen?
Answer Question
| March 5, 2013 6:06 PM
Microsoft Access 2007, Microsoft Access database
Form in Access 2007
How to build a demand form which will draw grocery items from main inventory table with related data and quantity ordered will be filled up manually?
Answer Question
| March 5, 2013 9:08 AM
Microsoft Access 2007, Microsoft Access forms
How to build a demand form which will draw grocery items from main inventory table with related data and quantity ordered will be filled up manually?
Answer Question
| March 5, 2013 9:08 AM
Microsoft Access 2007, Microsoft Access forms
Database deletion
How do I delete a database from Access 2007?
Answer Question
| February 6, 2013 8:22 PM
Microsoft Access 2007, Microsoft Access database
How do I delete a database from Access 2007?
Answer Question
| February 6, 2013 8:22 PM
Microsoft Access 2007, Microsoft Access database
Linking tables in databases that change each month
The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?
Answer Question
| January 17, 2013 5:42 PM
Microsoft Access 2007, Microsoft Access database
The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?
Answer Question
| January 17, 2013 5:42 PM
Microsoft Access 2007, Microsoft Access database
Incrementing a key field without autonumber
I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?
Answer Question
| January 10, 2013 11:36 AM
Microsoft Access 2007, Microsoft Access 2010
I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?
Answer Question
| January 10, 2013 11:36 AM
Microsoft Access 2007, Microsoft Access 2010
Security
Can someone tell me how you handle user security since it is no longer available in Access 2007 or 2012. I have a database that I need to pick and choose who can edit certain forms.
Answer Question
| November 9, 2012 6:09 PM
Microsoft Access 2007, Microsoft Access 2012, Security
Can someone tell me how you handle user security since it is no longer available in Access 2007 or 2012. I have a database that I need to pick and choose who can edit certain forms.
Answer Question
| November 9, 2012 6:09 PM
Microsoft Access 2007, Microsoft Access 2012, Security
Access 2007
I have a database that is supposed to generate the min, max & ave for two different sets of numbers. I have it actually working, but only up to a certain date of figures, I have no idea why these fields do not update when I enter new data. Please help
Answer Question
| September 6, 2012 3:08 AM
Microsoft Access 2007, Microsoft Access database
I have a database that is supposed to generate the min, max & ave for two different sets of numbers. I have it actually working, but only up to a certain date of figures, I have no idea why these fields do not update when I enter new data. Please help
Answer Question
| September 6, 2012 3:08 AM
Microsoft Access 2007, Microsoft Access database
Creating a form in Access 2007
i have a customer table with the following fields : name code : this should be generated automatically domestic export I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the [...]
Answer Question
| August 27, 2012 8:04 AM
Microsoft Access 2007, Microsoft Access forms
i have a customer table with the following fields : name code : this should be generated automatically domestic export I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the [...]
Answer Question
| August 27, 2012 8:04 AM
Microsoft Access 2007, Microsoft Access forms
Extra Page Printing
When I print a form I select a record but it gives me an extra page with part of the header printed with it.
Answer Question
| June 22, 2012 2:26 PM
Microsoft Access 2007, Microsoft Access printing
When I print a form I select a record but it gives me an extra page with part of the header printed with it.
Answer Question
| June 22, 2012 2:26 PM
Microsoft Access 2007, Microsoft Access printing
How to refresh page when leaving the field
In my form I have a calculated field, this field is based on two other fields in the table. The field updates only when I page up or down or manually refresh. How can I get it to refresh once the other two fields are populated?
Answer Question
| June 2, 2012 4:19 PM
Microsoft Access 2007, Microsoft Access fields
In my form I have a calculated field, this field is based on two other fields in the table. The field updates only when I page up or down or manually refresh. How can I get it to refresh once the other two fields are populated?
Answer Question
| June 2, 2012 4:19 PM
Microsoft Access 2007, Microsoft Access fields
linking data
I need to enter the same “data” in two forms how can I enter it just once
Answer Question
| May 31, 2012 2:47 PM
Microsoft Access 2007
I need to enter the same “data” in two forms how can I enter it just once
Answer Question
| May 31, 2012 2:47 PM
Microsoft Access 2007
Generate automatic report number in Access 2007
I’m creating a db to track reports for my organization in Access 2007. We have a unique report numbering system. For example, a report number would be GR-50-12-002, where GR and 50 are constants, 12 is the year, and 002 is the second report issued that year. I want to create a form to add [...]
Answer Question
| May 22, 2012 5:42 PM
Microsoft Access 2007, Microsoft Access reports
I’m creating a db to track reports for my organization in Access 2007. We have a unique report numbering system. For example, a report number would be GR-50-12-002, where GR and 50 are constants, 12 is the year, and 002 is the second report issued that year. I want to create a form to add [...]
Answer Question
| May 22, 2012 5:42 PM
Microsoft Access 2007, Microsoft Access reports
