Writing to multiple fields with one text box
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]
Answer Question
| February 28, 2012 2:20 PM
Access Database, Access query, Access Tables, MS Access 2007
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]
Answer Question
| February 28, 2012 2:20 PM
Access Database, Access query, Access Tables, MS Access 2007
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
MS Access 2007 Date Query Question
My question is 2 parts: 1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 [...]
Answer Question
| March 31, 2012 3:17 PM
Access Database, Access Database Format, Access query
My question is 2 parts: 1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 [...]
Answer Question
| March 31, 2012 3:17 PM
Access Database, Access Database Format, Access query
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
FAQ Database
how do you build a FAQ database using Microsoft Access?
Answer Question
| June 29, 2011 2:14 PM
Access, Access Database, FAQ
how do you build a FAQ database using Microsoft Access?
Answer Question
| June 29, 2011 2:14 PM
Access, Access Database, FAQ
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 2010 database query
I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the employee [...]
Answer Question
| June 16, 2011 5:11 PM
Access 2010, Access Database, Access Database Attachments, Access query
I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the employee [...]
Answer Question
| June 16, 2011 5:11 PM
Access 2010, Access Database, Access Database Attachments, Access query
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
MySQL Replication I think!
Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front [...]
Answer Question
| May 5, 2011 8:35 PM
Access Database, MySQL, MySQL Replication, MySQL Restore
Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front [...]
Answer Question
| May 5, 2011 8:35 PM
Access Database, MySQL, MySQL Replication, MySQL Restore
Dynamic SQL query
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]
Answer Question
| May 5, 2011 5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]
Answer Question
| May 5, 2011 5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET
Back-up copies of the database
We have an access dbase that has multiple users for data entry. without fail, we end up with several “back-up” copies. Is this the result of the different users “saving” or is it from having shortcuts on their individual laptops?
Answer Question
| May 2, 2011 6:12 PM
Access Database, Database Backup, Database Backup Strategies
We have an access dbase that has multiple users for data entry. without fail, we end up with several “back-up” copies. Is this the result of the different users “saving” or is it from having shortcuts on their individual laptops?
Answer Question
| May 2, 2011 6:12 PM
Access Database, Database Backup, Database Backup Strategies
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
Active Access Database on Sharepoint
How can I load an active Access Database onto a Sharepoint Site? I need to make it open a new page and have each individual be able to enter information into it when they click on the link.
Answer Question
| March 15, 2011 7:52 PM
Access Database, Access Database Sharepoint, SharePoint
How can I load an active Access Database onto a Sharepoint Site? I need to make it open a new page and have each individual be able to enter information into it when they click on the link.
Answer Question
| March 15, 2011 7:52 PM
Access Database, Access Database Sharepoint, SharePoint
Access 2003 report printing
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
How to count data in Access 2003 stored database
hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you
Answer Question
| February 17, 2011 12:21 PM
Access 2003, Access Database, VB 6.0, Visual Basic, Visual Basic 6.0
hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you
Answer Question
| February 17, 2011 12:21 PM
Access 2003, Access Database, VB 6.0, Visual Basic, Visual Basic 6.0
How do you change user password for a separate Access database than you are working in?
I’ve built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don’t have to use Access’ login. I’m trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I’ve been working with the following [...]
Answer Question
| January 28, 2011 4:00 PM
Access 2003, Access 2003 Security, Access Database, VBA
I’ve built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don’t have to use Access’ login. I’m trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I’ve been working with the following [...]
Answer Question
| January 28, 2011 4:00 PM
Access 2003, Access 2003 Security, Access Database, VBA
Cumulative totals in Access 2003
I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative [...]
Answer Question
| July 12, 2011 1:01 PM
Access 2003, Access 2003 forms, Access Database, Access query
I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative [...]
Answer Question
| July 12, 2011 1:01 PM
Access 2003, Access 2003 forms, Access Database, Access query
Converting from Access 2003 to Access 2007
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]
Answer Question
| January 17, 2011 5:05 PM
Access, Access 2003, Access 2007, Access Database
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]
Answer Question
| January 17, 2011 5:05 PM
Access, Access 2003, Access 2007, Access Database
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
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
