Access Database update question
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]
Answer Question
| April 28, 2009 2:50 PM
Access Database, Microsoft Access
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]
Answer Question
| April 28, 2009 2:50 PM
Access Database, Microsoft Access
Access Course/Student Database
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
Autopopulating following fields
I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. [...]
Answer Question
| April 16, 2009 5:22 PM
Access Database, Microsoft Access
I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. [...]
Answer Question
| April 16, 2009 5:22 PM
Access Database, Microsoft Access
AccessDataSource and ‘?’ parameters asp.net
I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an [...]
Answer Question
| April 14, 2009 6:46 PM
Access Database, ASP.NET, Microsoft Access
I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an [...]
Answer Question
| April 14, 2009 6:46 PM
Access Database, ASP.NET, Microsoft Access
Trying to learn – How to filter dates…
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]
Answer Question
| April 13, 2009 2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]
Answer Question
| April 13, 2009 2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access
Creating Ref numbers from two fields
I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.
Answer Question
| April 4, 2009 7:42 PM
Access Database, Microsoft Access, Microsoft Access Unique ID
I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.
Answer Question
| April 4, 2009 7:42 PM
Access Database, Microsoft Access, Microsoft Access Unique ID
Update Access Databse
How do I set up web application, using classic Asp to update access 2002 database?
Answer Question
| April 4, 2009 3:08 PM
Access 2002, Access Database, Microsoft Access
How do I set up web application, using classic Asp to update access 2002 database?
Answer Question
| April 4, 2009 3:08 PM
Access 2002, Access Database, Microsoft Access
Database Access 2007
Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can’t any hint? When I go into my design mode those new fields do not apper?
Answer Question
| March 20, 2009 7:25 PM
Access 2007, Access Database, Access Database Design, Access Database Format, Microsoft Access
Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can’t any hint? When I go into my design mode those new fields do not apper?
Answer Question
| March 20, 2009 7:25 PM
Access 2007, Access Database, Access Database Design, Access Database Format, Microsoft Access
Format a field
I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.
Answer Question
| March 16, 2009 12:20 PM
Access Database, Microsoft Access
I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.
Answer Question
| March 16, 2009 12:20 PM
Access Database, Microsoft Access
Date a specific record in Microsoft Access
I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I receive a [...]
Answer Question
| April 9, 2009 1:38 PM
Access Database, Access Records, Microsoft Access
I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I receive a [...]
Answer Question
| April 9, 2009 1:38 PM
Access Database, Access Records, Microsoft Access
Formatting a subform for printing in access 2000
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]
Answer Question
| March 9, 2009 8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]
Answer Question
| March 9, 2009 8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms
New Access user!
I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there’s about 12 -15 copies. [...]
Answer Question
| March 4, 2009 2:04 PM
Access Database, Microsoft Access
I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there’s about 12 -15 copies. [...]
Answer Question
| March 4, 2009 2:04 PM
Access Database, Microsoft Access
MS Access 2007 Author credit
I’m designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?
Answer Question
| March 3, 2009 8:12 PM
Access 2007, Access Database, Microsoft Access
I’m designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?
Answer Question
| March 3, 2009 8:12 PM
Access 2007, Access Database, Microsoft Access
access 03 sending emails
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]
Answer Question
| March 2, 2009 4:31 PM
Access 2003, Access Database, Microsoft Access
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]
Answer Question
| March 2, 2009 4:31 PM
Access 2003, Access Database, Microsoft Access
Adding Serial Number to an already existing access document
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh
Answer Question
| March 22, 2010 2:46 PM
Access 2003, Access Database, Microsoft Access
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh
Answer Question
| March 22, 2010 2:46 PM
Access 2003, Access Database, Microsoft Access
Iseries Queries.
Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it’s access in access database, but on Mondays I don’t get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I’ve set for YESTERDAYX. How can I [...]
Answer Question
| January 13, 2009 7:06 PM
Access Database, AS/400 queries, AS/400 scheduling, Microsoft Access
Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it’s access in access database, but on Mondays I don’t get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I’ve set for YESTERDAYX. How can I [...]
Answer Question
| January 13, 2009 7:06 PM
Access Database, AS/400 queries, AS/400 scheduling, Microsoft Access
Adding a password to a SQL Server 2005 database
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?
Answer Question
| January 14, 2009 4:32 PM
Access Database, Microsoft Access, Password management, SQL Server 2005, SQL Server databases
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?
Answer Question
| January 14, 2009 4:32 PM
Access Database, Microsoft Access, Password management, SQL Server 2005, SQL Server databases
Export Access to Outlook
Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?
Answer Question
| January 9, 2009 7:02 PM
Access Database, Export Access to Outlook, Microsoft Access, Outlook
Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?
Answer Question
| January 9, 2009 7:02 PM
Access Database, Export Access to Outlook, Microsoft Access, Outlook
Access Database – Colorize one word or letter
How do I colorize one character in a field in a table? I want the letter “O” to be in red for one customer and blue for another customer in the same column but different rows.
Answer Question
| January 6, 2009 5:25 PM
Access Database, Access Database Format, Microsoft Access
How do I colorize one character in a field in a table? I want the letter “O” to be in red for one customer and blue for another customer in the same column but different rows.
Answer Question
| January 6, 2009 5:25 PM
Access Database, Access Database Format, Microsoft Access
mixed 2000 db and 2007 mixed datepicker results
I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to [...]
Answer Question
| December 13, 2008 1:14 PM
Access 2000, Access 2007, Access Database, Access Date Picker, Microsoft Access
I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to [...]
Answer Question
| December 13, 2008 1:14 PM
Access 2000, Access 2007, Access Database, Access Date Picker, Microsoft Access
