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
Look at query results & pass a value to form in ACCESS 2003
I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the [...]
Answer Question
| January 8, 2009 5:05 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the [...]
Answer Question
| January 8, 2009 5:05 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
AS400/iSeries Queries on a schedule
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question
| January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question
| January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job
Crystal Reports can’t connect to Access 2007
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.
Answer Question
| January 8, 2009 8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.
Answer Question
| January 8, 2009 8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access
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
MS Access 2003 write in SQL query to convert string to numeric
How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks
Answer Question
| January 19, 2009 4:47 PM
Access 2003, Microsoft Access, SQL, SQL Query
How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks
Answer Question
| January 19, 2009 4:47 PM
Access 2003, Microsoft Access, SQL, SQL Query
Microsoft Access 2007 Query/Report Calculated Fields
I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7 estimates [...]
Answer Question
| January 5, 2009 1:35 AM
DCount function, Microsoft Access, Microsoft Access 2007, Microsoft Access 2007 Reports/Queries
I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7 estimates [...]
Answer Question
| January 5, 2009 1:35 AM
DCount function, Microsoft Access, Microsoft Access 2007, Microsoft Access 2007 Reports/Queries
Update database when combo box value is changed
Hello, I am wondering how to update all the text fields, other combo boxes, and memo’s when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I [...]
Answer Question
| February 20, 2009 6:27 PM
Access 2003, ComboBox, Microsoft Access
Hello, I am wondering how to update all the text fields, other combo boxes, and memo’s when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I [...]
Answer Question
| February 20, 2009 6:27 PM
Access 2003, ComboBox, Microsoft Access
Checkboxes with INSERT and DELETE actions
I’m fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:
Answer Question
| December 31, 2008 3:13 PM
Access 2003, Access forms, Microsoft Access, Visual Basic
I’m fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:
Answer Question
| December 31, 2008 3:13 PM
Access 2003, Access forms, Microsoft Access, Visual Basic
Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it.
Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it. I have an idea on how to convert the text data to numeric. The problem is that I want to take text data from one table then temporarily create another table where the converted [...]
Answer Question
| January 1, 2009 8:27 PM
Access 2003, converting text to numeric, Microsoft Access
Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it. I have an idea on how to convert the text data to numeric. The problem is that I want to take text data from one table then temporarily create another table where the converted [...]
Answer Question
| January 1, 2009 8:27 PM
Access 2003, converting text to numeric, Microsoft Access
Replace an Exsisting Table
I want to make a Table in Access. I figured this out but how do I overwrite this table because obviously I don’t want to make new tables again and again. Right now i have just implemented a simple table. Any help would be help. Thanks
Answer Question
| January 2, 2009 7:50 PM
Microsoft Access, Microsoft Access tables
I want to make a Table in Access. I figured this out but how do I overwrite this table because obviously I don’t want to make new tables again and again. Right now i have just implemented a simple table. Any help would be help. Thanks
Answer Question
| January 2, 2009 7:50 PM
Microsoft Access, Microsoft Access tables
vb 6.0 conect with access to create a report
i have created a table in access to manage the house rent.i want to create report only for particular customer rent detail. the customer id is retrived from the table and stored in combobox in one form.when i choose particular id from the combo box, the respective details of the particular id should be print [...]
Answer Question
| December 26, 2008 6:58 AM
Microsoft Access, VB, VB 6
i have created a table in access to manage the house rent.i want to create report only for particular customer rent detail. the customer id is retrived from the table and stored in combobox in one form.when i choose particular id from the combo box, the respective details of the particular id should be print [...]
Answer Question
| December 26, 2008 6:58 AM
Microsoft Access, VB, VB 6
Creating form with combo box to enter data
I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.
Answer Question
| December 17, 2008 3:41 PM
ComboBox, Microsoft Access
I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.
Answer Question
| December 17, 2008 3:41 PM
ComboBox, Microsoft Access
Using WildCards in IIF Statement
Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don’t enter anything in the field on the form. I tried putting the following IIF statement in the Criteria: [...]
Answer Question
| December 17, 2008 3:38 PM
Access query, IIF statement, Microsoft Access, SQL, Wildcards
Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don’t enter anything in the field on the form. I tried putting the following IIF statement in the Criteria: [...]
Answer Question
| December 17, 2008 3:38 PM
Access query, IIF statement, Microsoft Access, SQL, Wildcards
Passing Parameters in Access into Vb6.0
How to pass Parameters in MS Access into Vb 6.0 and get the results through ado recordset
Answer Question
| December 17, 2008 1:27 PM
ADO Recordset Object, Microsoft Access, VB 6.0
How to pass Parameters in MS Access into Vb 6.0 and get the results through ado recordset
Answer Question
| December 17, 2008 1:27 PM
ADO Recordset Object, Microsoft Access, VB 6.0
Microsoft Access database too large – Can I divide my Access file?
Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now [...]
Answer Question
| December 17, 2008 7:39 PM
Database programming, Microsoft Access
Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now [...]
Answer Question
| December 17, 2008 7:39 PM
Database programming, Microsoft Access
Writing vertical data to a flat (unfortunately!) table
I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be [...]
Answer Question
| December 15, 2008 8:34 PM
Access 2003, ADO, Microsoft Access, VBA, Vertical Data
I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be [...]
Answer Question
| December 15, 2008 8:34 PM
Access 2003, ADO, Microsoft Access, VBA, Vertical Data
Using Access query data in Excel
I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets [...]
Answer Question
| February 4, 2010 5:02 PM
Access query, Access to Excel, Database, Excel 2003, Microsoft Access, Microsoft Excel
I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets [...]
Answer Question
| February 4, 2010 5:02 PM
Access query, Access to Excel, Database, Excel 2003, Microsoft Access, Microsoft Excel
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
VBA to print to specific printer with print button
In Access 2007 how do I use VBA code in my print button to print to a “specific printer” for my report.
Answer Question
| December 12, 2008 1:05 AM
Access 2007, Code, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
In Access 2007 how do I use VBA code in my print button to print to a “specific printer” for my report.
Answer Question
| December 12, 2008 1:05 AM
Access 2007, Code, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
