1
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
Best way to set up longitudinal database
Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester – but on a larger scale – who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and some [...]
Answer Question
| March 14, 2013 2:25 AM
Microsoft Access, Microsoft Access database
Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester – but on a larger scale – who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and some [...]
Answer Question
| March 14, 2013 2:25 AM
Microsoft Access, 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
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
TIME String using Variable H (0 to 23) & M (0 to 59)
Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO “IBNserv”.”ChkMe”(“Clt”)>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST(’12:14:00′ AS TIME) STATUS INSERT INTO “IBNserv”.”ChkMe”(“Clt”) VALUES CAST(’12.14.00′ AS TIME) Updated 1 rows. Query execution time [...]
Answer Question
| January 14, 2013 10:37 AM
DB2 10.1, Microsoft Access, Microsoft Access database
Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO “IBNserv”.”ChkMe”(“Clt”)>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST(’12:14:00′ AS TIME) STATUS INSERT INTO “IBNserv”.”ChkMe”(“Clt”) VALUES CAST(’12.14.00′ AS TIME) Updated 1 rows. Query execution time [...]
Answer Question
| January 14, 2013 10:37 AM
DB2 10.1, Microsoft Access, Microsoft Access database
Access 2010 Field Design View, how to set up for multiple names
I am using Access 2010 and I am setting up a training database to show trainers names against various training modules. Now some of these training modules have many trainers against these modules, how do I set this up? I have made a table with the modules and now I need to put trainers names [...]
Answer Question
| December 12, 2012 4:13 AM
Microsoft Access 2010, Microsoft Access database
I am using Access 2010 and I am setting up a training database to show trainers names against various training modules. Now some of these training modules have many trainers against these modules, how do I set this up? I have made a table with the modules and now I need to put trainers names [...]
Answer Question
| December 12, 2012 4:13 AM
Microsoft Access 2010, Microsoft Access database
MS Access query
I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate [...]
Answer Question
| September 7, 2012 6:33 PM
Microsoft Access 2003, Microsoft Access database
I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate [...]
Answer Question
| September 7, 2012 6:33 PM
Microsoft Access 2003, Microsoft Access database
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
Access Find the previous checkout record and add a return time
I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID [...]
Answer Question
| November 8, 2012 7:44 PM
Microsoft Access 2007, Microsoft Access database
I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID [...]
Answer Question
| November 8, 2012 7:44 PM
Microsoft Access 2007, Microsoft Access database
MS Access database
I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It [...]
Answer Question
| May 9, 2013 9:59 AM
Microsoft Access, Microsoft Access database
I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It [...]
Answer Question
| May 9, 2013 9:59 AM
Microsoft Access, Microsoft Access database
1
