1
Pass data from Access subform to another form
In Access – How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form
Answer Question
| February 10, 2011 4:11 PM
Access, Access form controls, Access forms, Access Forms Database, Microsoft Access subforms
In Access – How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form
Answer Question
| February 10, 2011 4:11 PM
Access, Access form controls, Access forms, Access Forms Database, Microsoft Access subforms
Creating Access Form
I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.
Answer Question
| January 10, 2011 7:37 PM
Access Database, Access forms, Access Forms Database, Access query
I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.
Answer Question
| January 10, 2011 7:37 PM
Access Database, Access forms, Access Forms Database, Access query
How do I keep the original value of a field in Access 2010?
Hello, I have an inventory with varying prices (which may change weekly). I need to compare the current price with the original price. However, I only want the users to input one price value in a form. I’ve tried to do this with a datamacro and the “old” command, but every time i update the [...]
Answer Question
| November 29, 2010 12:28 AM
Access 2010, Access Database, Access forms, Access Forms Database, office 2010
Hello, I have an inventory with varying prices (which may change weekly). I need to compare the current price with the original price. However, I only want the users to input one price value in a form. I’ve tried to do this with a datamacro and the “old” command, but every time i update the [...]
Answer Question
| November 29, 2010 12:28 AM
Access 2010, Access Database, Access forms, Access Forms Database, office 2010
Data Changing when closing an Access 2003 form
I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine – If I close the form not on the first name in the combo box, then [...]
Answer Question
| August 17, 2010 6:51 PM
Access 2003, Access forms, Access Forms Database, ComboBox, Microsoft Access 2003 subforms
I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine – If I close the form not on the first name in the combo box, then [...]
Answer Question
| August 17, 2010 6:51 PM
Access 2003, Access forms, Access Forms Database, ComboBox, Microsoft Access 2003 subforms
How to use the data from other table into the main table in Access 2003 and 2007
I’m trying to use data from other tables to make a sum and then display the result in a “Total” text. For example: I have in table1 3 qty’s, in table2 2 qty’s and in table3 5 qty’s. I want to sum all those qty’s and display them into the Main Form. I use MS [...]
Answer Question
| August 19, 2010 4:02 AM
Access 2003, Access 2003 forms, Access 2007, Access 2007 form creation, Access Forms Database
I’m trying to use data from other tables to make a sum and then display the result in a “Total” text. For example: I have in table1 3 qty’s, in table2 2 qty’s and in table3 5 qty’s. I want to sum all those qty’s and display them into the Main Form. I use MS [...]
Answer Question
| August 19, 2010 4:02 AM
Access 2003, Access 2003 forms, Access 2007, Access 2007 form creation, Access Forms Database
Changing Access form properties within your program.
I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.
Answer Question
| July 27, 2010 4:41 PM
Access, Access form controls, Access forms, Access Forms Database
I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.
Answer Question
| July 27, 2010 4:41 PM
Access, Access form controls, Access forms, Access Forms Database
Index with page numbers in Access
We have created a form that we use for a directory in Access. We have created an index as well, but how can I add page numbers that correspond to the correct person/record?
Answer Question
| July 8, 2010 2:07 PM
Access Forms Database, Access Functions, Document management
We have created a form that we use for a directory in Access. We have created an index as well, but how can I add page numbers that correspond to the correct person/record?
Answer Question
| July 8, 2010 2:07 PM
Access Forms Database, Access Functions, Document management
Access 2007 form creation
[strong]KVS: [/strong] [strong]Q: [/strong]Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i’m not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button [...]
Answer Question
| January 28, 2010 9:19 PM
Access 2007, Access 2007 form creation, Access Forms Database
[strong]KVS: [/strong] [strong]Q: [/strong]Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i’m not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button [...]
Answer Question
| January 28, 2010 9:19 PM
Access 2007, Access 2007 form creation, Access Forms Database
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: Form to input dates
Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur [...]
Answer Question
| May 12, 2009 1:42 PM
Access forms, Access Forms Database, Microsoft Access
Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur [...]
Answer Question
| May 12, 2009 1:42 PM
Access forms, Access Forms Database, Microsoft Access
1
