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
Report design Access 2010 / 2007
I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. [...]
Answer Question
| August 3, 2012 3:46 PM
Access, Access 2007, Report format
I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. [...]
Answer Question
| August 3, 2012 3:46 PM
Access, Access 2007, Report format
Access 2007 type mismatch
Why is Access 2007 macro getting type mismatch error message for a simple macro to pop-up a message box when a form field is left blank upon exiting the field?
Answer Question
| June 6, 2012 8:59 PM
Access 2007
Why is Access 2007 macro getting type mismatch error message for a simple macro to pop-up a message box when a form field is left blank upon exiting the field?
Answer Question
| June 6, 2012 8:59 PM
Access 2007
Access 2007 DB Project
Hello, I am setting up a database for a small airline. I have an ‘Aircraft_Table’ with the fields:
Answer Question
| February 28, 2012 10:41 PM
Access 2007, Database, SQL
Hello, I am setting up a database for a small airline. I have an ‘Aircraft_Table’ with the fields:
Answer Question
| February 28, 2012 10:41 PM
Access 2007, Database, SQL
I would like to know all the commands fired by all my users using command line, is it possible.?
I keep a track of all my users when they login and logout, i have very few interactive users on my system who use command line. I would like to know all the commands fired by all my users using command line, is it possible.? This is required from an audit perspective.
Answer Question
| March 17, 2012 12:57 PM
Access 2007, Command line, iSeries
I keep a track of all my users when they login and logout, i have very few interactive users on my system who use command line. I would like to know all the commands fired by all my users using command line, is it possible.? This is required from an audit perspective.
Answer Question
| March 17, 2012 12:57 PM
Access 2007, Command line, iSeries
Access 2007 – Controlling Master ID when launching detail form from master form
Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition =”[Master ID]=” & [...]
Answer Question
| March 6, 2012 5:44 AM
Access 2007, Access forms, access master form
Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition =”[Master ID]=” & [...]
Answer Question
| March 6, 2012 5:44 AM
Access 2007, Access forms, access master form
Return nth record
I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.
Answer Question
| November 10, 2011 4:59 PM
Access, Access 2007, Database, Microsoft Access, Microsoft Access 2007
I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.
Answer Question
| November 10, 2011 4:59 PM
Access, Access 2007, Database, Microsoft Access, Microsoft Access 2007
how to show register with CrystalReport using Access2007
I want to make reports using CristalReport for Visual Studie 2008 and Access 2007 as basetables, and the report not show the register. I did all the step for make a report, but it is imposible to show it. but, it is posible with acces 2003. What I can do for it.
Answer Question
| October 20, 2011 8:31 PM
Access 2007, Crystal Reports, Visual Studio 2008
I want to make reports using CristalReport for Visual Studie 2008 and Access 2007 as basetables, and the report not show the register. I did all the step for make a report, but it is imposible to show it. but, it is posible with acces 2003. What I can do for it.
Answer Question
| October 20, 2011 8:31 PM
Access 2007, Crystal Reports, Visual Studio 2008
Access 2007 database errors when using Access 2010
I have a database built with Access 2007. Some of our customers are upgraded to Access 2010 and cannot open the database anymore. Error is “The expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events”. Anyone experienced similar problem and [...]
Answer Question
| March 31, 2012 6:03 PM
Access 2007, Access 2010, Access Database
I have a database built with Access 2007. Some of our customers are upgraded to Access 2010 and cannot open the database anymore. Error is “The expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events”. Anyone experienced similar problem and [...]
Answer Question
| March 31, 2012 6:03 PM
Access 2007, Access 2010, Access Database
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
Record Locking in Access 2007
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?
Answer Question
| March 31, 2012 8:48 PM
Access 2007, Access Database, Record lock, User Interface
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?
Answer Question
| March 31, 2012 8:48 PM
Access 2007, Access Database, Record lock, User Interface
Access Filtering
I have a database which has multiple Product fields ( Prod Name, Prod Name 1, Prod Name 2, Prod Name 4). It is set up this way because one customer can order more than one product up to about four. The products are listed by number and the users can enter a product number into [...]
Answer Question
| March 31, 2012 5:37 PM
Access 2007, columns, Design, filter, formulas, Search, SORT, totals functions
I have a database which has multiple Product fields ( Prod Name, Prod Name 1, Prod Name 2, Prod Name 4). It is set up this way because one customer can order more than one product up to about four. The products are listed by number and the users can enter a product number into [...]
Answer Question
| March 31, 2012 5:37 PM
Access 2007, columns, Design, filter, formulas, Search, SORT, totals functions
Link Access automated form to separate outlook mailbox
I want to email a form from access to 5,000+ indiviudals. This form contains sensitive data so I want to encrypt an outlook mailbox (we’ll call it mailbox B) for the purpose of this correspondance. The outlook mailbox is separate from my personal mailbox (mailbox A). The problem I’m having is that when a form [...]
Answer Question
| March 31, 2012 3:02 PM
Access 2007, Encryption, Outlook 2007, Outlook Encrypted Path
I want to email a form from access to 5,000+ indiviudals. This form contains sensitive data so I want to encrypt an outlook mailbox (we’ll call it mailbox B) for the purpose of this correspondance. The outlook mailbox is separate from my personal mailbox (mailbox A). The problem I’m having is that when a form [...]
Answer Question
| March 31, 2012 3:02 PM
Access 2007, Encryption, Outlook 2007, Outlook Encrypted Path
Access 2007 Query Help
I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc…) where it [...]
Answer Question
| July 5, 2011 8:57 PM
Access, Access 2007, Access query, SQL Query
I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc…) where it [...]
Answer Question
| July 5, 2011 8:57 PM
Access, Access 2007, Access query, SQL Query
Book example – Building table entries from two combo boxes
I have a DB for recording safety information. I have a form to document individual accidents. Each accident can cause multiple types of harm to multiple assets. In the accident form, I have a combobox where I can select a single asset and another where I can select its associated types of harm. Once I [...]
Answer Question
| June 27, 2011 7:44 PM
Access 2007, ComboBox, Visual Basic
I have a DB for recording safety information. I have a form to document individual accidents. Each accident can cause multiple types of harm to multiple assets. In the accident form, I have a combobox where I can select a single asset and another where I can select its associated types of harm. Once I [...]
Answer Question
| June 27, 2011 7:44 PM
Access 2007, ComboBox, Visual Basic
Access Database Splitting
I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. [...]
Answer Question
| June 20, 2011 8:07 PM
Access 2007, Access Database, Access Database Design
I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. [...]
Answer Question
| June 20, 2011 8:07 PM
Access 2007, Access Database, Access Database Design
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
“Automation Error Invalid Advise Tags” What is an advise tag?
I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages. However, within my Access form, when I try to click the button associated with this module, I receive the error message, “Automation Error. Invalid Advise [...]
Answer Question
| May 17, 2011 5:00 PM
Access 2007, VBA, Visual Basic
I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages. However, within my Access form, when I try to click the button associated with this module, I receive the error message, “Automation Error. Invalid Advise [...]
Answer Question
| May 17, 2011 5:00 PM
Access 2007, VBA, Visual Basic
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
help with access database
Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists various property details [...]
Answer Question
| March 16, 2011 6:03 PM
Access 2007, Access Database, ComboBox, Parameters, Refresh Report parameters
Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists various property details [...]
Answer Question
| March 16, 2011 6:03 PM
Access 2007, Access Database, ComboBox, Parameters, Refresh Report parameters
