How to use an form field in a SQL from a combobox

I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn’t work. what is the correct syntax to refer to a field…



Answer Question   |  June 27, 2012  5:54 AM
Access 2003, Microsoft Access, SQL Forms
asked by:
5 pts.

Microsoft Access Report “Specific Printer”

Cannot get MS Access reports to let go of default printer. Selection of “Specific Printer” in page setup does not get saved. Also set .UseDefaultPrinter=False in code but it goes back to true no matter what. Have also tried every conceivable means of setting properties of both application.printer and report.printer objects. I must get this…



Answer Question   |  June 27, 2012  5:53 AM
Microsoft Access, Microsoft Access printing
asked by:
5 pts.

Lotus Approach and File Maker Advance Pro 10.0.3

Can anyone help me on how to migrate or import/export or open Ms Excel using these softwares Lotus Approach 2000 and File Maker Advance Pro 10.0.3 please thanks



Answer Question   |  June 27, 2012  5:51 AM
FileMaker Advance Pro 10.0.3, Filemaker Pro, Lotus Approach, Lotus Approach 2000, Lotus Approach and File Maker Advance Pro 10.0.3 softwares
asked by:
15 pts.

resize contol in Access print view

[table style="border-collapse: collapse; width: 347pt;" border="0" cellpadding="0" cellspacing="0" width="462"> [col style="width: 347pt;" width="462">[/cOLIST] [tr style=”height: 69pt;” height=”92″> [td class=”xl63″ style=”height: 69pt; width: 347pt;” height=”92″ width=”462″>I am using ms access to devlop several reports.  Text boxes are having one property i.e “Can Grow” , which is used to set the height of text box as per…



Answer Question   |  June 27, 2012  5:51 AM
Microsoft Access, Microsoft Access printing
asked by:
5 pts.

resize contol in Access print view

[table style="border-collapse: collapse; width: 347pt;" border="0" cellpadding="0" cellspacing="0" width="462"> [col style="width: 347pt;" width="462">[/cOLIST] [tr style=”height: 69pt;” height=”92″> [td class=”xl63″ style=”height: 69pt; width: 347pt;” height=”92″ width=”462″>I am using ms access to devlop several reports.  Text boxes are having one property i.e “Can Grow” , which is used to set the height of text box as per…



Answer Question   |  June 27, 2012  5:51 AM
Microsoft Access, Microsoft Access printing
asked by:
5 pts.

SAP for B.tech or MBA students only

hiii i have done B.Tech in electronics..will SAP basic course is beneficial for me or it is beneficial for MBA students only



Answer Question   |  June 27, 2012  5:50 AM
Career development, IT careers, IT education, MBA, SAP careers, SAP training
asked by:
10 pts.

SAP for B.tech or MBA students only

hiii i have done B.Tech in electronics..will SAP basic course is beneficial for me or it is beneficial for MBA students only



Answer Question   |  June 27, 2012  5:50 AM
Career development, IT careers, IT education, MBA, SAP careers, SAP training
asked by:
10 pts.

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   |  June 27, 2012  5:47 AM
Access 2007, Access 2007 functions, Access 2007 printing, Access errors, Microsoft Access printing
asked by:
5 pts.

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   |  June 27, 2012  5:42 AM
DCount function, Microsoft Access, Microsoft Access 2007, Microsoft Access 2007 Reports/Queries
asked by:
10 pts.

MySQL 5.0 advantages and disadvantages

what is the advantage and disadvantage of mysql 5.0?



Answer Question   |  June 27, 2012  5:28 AM
MySQL, MySQL 5.0
asked by:
10 pts.

Creating New Data Source to SQL Server…

I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do,…



Answer Question   |  June 27, 2012  5:27 AM
Administrative tools, Data Sources, ODBC, SQL Server
asked by:
5 pts.

Return nth record

I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.



Answer Question   |  June 27, 2012  5:22 AM
Access, Access 2007, Database, Microsoft Access, Microsoft Access 2007
asked by:
25 pts.

DB2 / ODBC file availability

We have a new web app that we want to be able to run 24/7. My question from our web staff is  “when the data is available? “. There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be…



Answer Question   |  June 27, 2012  5:03 AM
AS/400 High Availability, DB2, iSeries, ODBC
asked by:
3,915 pts.

How to Set Active Period in a Table

There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this should…



Answer Question   |  June 27, 2012  5:03 AM
Access 2003, Access Records, Microsoft Access
asked by:
80 pts.

Using Excel 2010 to pull data from SQL Server?

How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.



Answer Question   |  June 27, 2012  5:02 AM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database
asked by:
1,110 pts.

The most-watched IT questions this week: Dec. 8, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values…



Answer Question   |  June 27, 2012  4:57 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
asked by:
16,755 pts.

A report that works in Crystal Reports client does not work in CMC

Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week’s data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record. Through a stored procedure, we fetch this…



Answer Question   |  June 27, 2012  4:56 AM
Central Management Console, Crystal Reports XI, Oracle 10g, Primary keys
asked by:
5 pts.

Does Siebel 7.7 work on Windows Vista (64-bit)?

My name is Ayman and I’m new on this technology Siebel 7.7. My questions is: * Does Siebel 7.7 work on Windows Vista (64-bit)? * Where can I find Siebel 8.0 software? * Why does Siebel needs ODBC? Thank you so much for your time.



Answer Question   |  June 27, 2012  4:55 AM
CRM software, ODBC, Siebel, Siebel 7.x, Siebel 8.x, Vista
asked by:
250 pts.

Connect JasperServer and Sql 2008

i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to…



Answer Question   |  June 27, 2012  4:51 AM
Jasper, JasperServer, JDBC, SQL, SQL 2008, SQL Server 2008, SQL Testing
asked by:
5 pts.

A question about system integration testing

I have two development teams looking at integrating testers / test developers from traditional QA team. How should we best handle system wide integration testing that would include devices, firmware, and web software? Most books are written for software only teams. Our integration and regression testing touches hardware, firmware, and software.



Answer Question   |  June 27, 2012  4:44 AM
Integration testing, Java applications, MySQL, System integration testing
asked by:
5 pts.