Access 2007 printing
I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.
Answer Question
| October 13, 2010 12:21 AM
Access 2007, Access 2007 functions, Access 2007 printing, Access errors, Microsoft Access printing
I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.
Answer Question
| October 13, 2010 12:21 AM
Access 2007, Access 2007 functions, Access 2007 printing, Access errors, Microsoft Access printing
MS Access 2007 IIF expression
I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it’s pulling all records with all court dates that is greater than today’s date. I want the report to show just the next court date for each client. Is there an expression can I use [...]
Answer Question
| October 20, 2010 8:17 PM
Access 2007, Access 2007 functions, Access query, IIF function
I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it’s pulling all records with all court dates that is greater than today’s date. I want the report to show just the next court date for each client. Is there an expression can I use [...]
Answer Question
| October 20, 2010 8:17 PM
Access 2007, Access 2007 functions, Access query, IIF function
Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows
How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?
Answer Question
| February 17, 2011 5:19 PM
Access 2007, Data transfer, Data Transfer Function, Excel 2007, Excel Database
How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?
Answer Question
| February 17, 2011 5:19 PM
Access 2007, Data transfer, Data Transfer Function, Excel 2007, Excel Database
Trying to Design a Split Database Access 2007/SQL Server Express
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]
Answer Question
| September 30, 2010 5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]
Answer Question
| September 30, 2010 5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Visual Basic Email Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?
Answer Question
| September 21, 2010 11:13 AM
Access 2007, Access 2007 functions, Access Database, Access database permissions, Visual Basic, Visual Basic Script
Outlook 2007 templates in Access
I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I [...]
Answer Question
| September 13, 2010 4:52 PM
Access 2007, Access 2007 functions, Export Access to Outlook, Outlook 2007
I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I [...]
Answer Question
| September 13, 2010 4:52 PM
Access 2007, Access 2007 functions, Export Access to Outlook, Outlook 2007
docmd.sendobject – “FROM” variable
I am trying to get Access to send an email from an email address, “response folder”, other than mine or anyone else who might be sending an email from the database.
Answer Question
| September 9, 2010 6:22 PM
Access 2007, Access 2007 security, Access Database, Access database permissions
I am trying to get Access to send an email from an email address, “response folder”, other than mine or anyone else who might be sending an email from the database.
Answer Question
| September 9, 2010 6:22 PM
Access 2007, Access 2007 security, Access Database, Access database permissions
DB Table/Query Layout for Ranking System
Hello, I’m building a Membership DB where Members can achieve certain ranks (Rank1 – Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them. [...]
Answer Question
| September 2, 2010 10:09 AM
Access 2007, Access Database, Access query, Database, Query
Hello, I’m building a Membership DB where Members can achieve certain ranks (Rank1 – Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them. [...]
Answer Question
| September 2, 2010 10:09 AM
Access 2007, Access Database, Access query, Database, Query
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones?
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks
Answer Question
| September 2, 2010 11:14 PM
Access 2007, Access 2007 functions, Access Tables, File locks, Windows 7, Windows 7 in 2010
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks
Answer Question
| September 2, 2010 11:14 PM
Access 2007, Access 2007 functions, Access Tables, File locks, Windows 7, Windows 7 in 2010
Client Loves User-Level Security, But Needs Access 2007
Hey Guys, I have a Client for whom I have remodeled an access database. The database was initially created in Access 2003, and has been updated in 2007, though it is still in .mdb format. I showed the client a few simple user-level security options, and they worked like a charm. The only problem is [...]
Answer Question
| August 23, 2010 8:10 PM
Access 2003, Access 2003 Security, Access 2007, Access 2007 security, Access Database, Access Database Design, User-Level Security
Hey Guys, I have a Client for whom I have remodeled an access database. The database was initially created in Access 2003, and has been updated in 2007, though it is still in .mdb format. I showed the client a few simple user-level security options, and they worked like a charm. The only problem is [...]
Answer Question
| August 23, 2010 8:10 PM
Access 2003, Access 2003 Security, Access 2007, Access 2007 security, Access Database, Access Database Design, User-Level Security
SQL problem: Adapting code fragment
How do I adapt the fragment of code below to show: a) Two columns – the Filipino Population and the Total Population b) The Filipino Population as a percentage of the total population SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(*)FROM POPDATA WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC;
Answer Question
| August 23, 2010 10:56 AM
Access 2007, SQL, SQL commands, SQL Server
How do I adapt the fragment of code below to show: a) Two columns – the Filipino Population and the Total Population b) The Filipino Population as a percentage of the total population SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(*)FROM POPDATA WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC;
Answer Question
| August 23, 2010 10:56 AM
Access 2007, SQL, SQL commands, SQL Server
Increasing text in Access 2007 without losing info
I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters [...]
Answer Question
| May 19, 2011 11:47 PM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters [...]
Answer Question
| May 19, 2011 11:47 PM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
Create SQL statement in VBA Access 2007
How can I create a select Group BY SQL statement inside a VBA module? I’ve ran actions queries and they seem to take an effect in my tables but I’m having a difficult time creating a Select statement. Please display a couple of samples
Answer Question
| August 18, 2010 5:15 AM
Access 2007, Access VBA, SQL, SQL statement, VBA, VBA Access 2007
How can I create a select Group BY SQL statement inside a VBA module? I’ve ran actions queries and they seem to take an effect in my tables but I’m having a difficult time creating a Select statement. Please display a couple of samples
Answer Question
| August 18, 2010 5:15 AM
Access 2007, Access VBA, SQL, SQL statement, VBA, VBA Access 2007
Query that uses input data from another form
OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need…but my question is what is the syntax [...]
Answer Question
| August 16, 2010 4:42 AM
Access 2007, Access query, Access Tables, Data Extraction, Query Parameters
OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need…but my question is what is the syntax [...]
Answer Question
| August 16, 2010 4:42 AM
Access 2007, Access query, Access Tables, Data Extraction, Query Parameters
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
How to enter a field with number increments in Access 2007
How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)
Answer Question
| August 6, 2010 10:01 PM
Access 2007, Access 2007 forms, Access 2007 functions
How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)
Answer Question
| August 6, 2010 10:01 PM
Access 2007, Access 2007 forms, Access 2007 functions
Error message stating that the value is too long for the field.
I entered the last name of one of my students and received an error message. What is my next step(s)?
Answer Question
| July 30, 2010 5:28 AM
Access 2007, Access errors, Error Messages
I entered the last name of one of my students and received an error message. What is my next step(s)?
Answer Question
| July 30, 2010 5:28 AM
Access 2007, Access errors, Error Messages
Hotel database in Access 2007
How do i create a Hotel database in Access 2007
Answer Question
| November 22, 2010 3:59 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design
How do i create a Hotel database in Access 2007
Answer Question
| November 22, 2010 3:59 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design
Access form to link to Google Maps
I have like a form to put all the custome address I want like a bouttom to click then it opens a google maps with the customer address from the place I set prevoiusly for example A: My address (1901 Northwest Expressway Oklahoma City, OK 73118) B: customer Address which is from the Data base
Answer Question
| July 30, 2010 4:20 AM
Access, Access 2007, Access 2007 form creation, Access 2007 functions, Access Database, Access Database Design
I have like a form to put all the custome address I want like a bouttom to click then it opens a google maps with the customer address from the place I set prevoiusly for example A: My address (1901 Northwest Expressway Oklahoma City, OK 73118) B: customer Address which is from the Data base
Answer Question
| July 30, 2010 4:20 AM
Access, Access 2007, Access 2007 form creation, Access 2007 functions, Access Database, Access Database Design
Which methodology (SDLC, Software Development Method) is best to use for a Census Management System I’m creating?
I am doing my IT project for my final year (Bsc, Computer Science), Which methodology (SDLC, Software Development Method) is best to use for a Census Management System I’m creating?
Answer Question
| July 23, 2010 1:04 PM
.NET development, Access 2007, PHP, Software development, Software development methodologies, Statistics software, VB.NET
I am doing my IT project for my final year (Bsc, Computer Science), Which methodology (SDLC, Software Development Method) is best to use for a Census Management System I’m creating?
Answer Question
| July 23, 2010 1:04 PM
.NET development, Access 2007, PHP, Software development, Software development methodologies, Statistics software, VB.NET
