cpytoimpf CSV file showing garbage
I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does...
I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does...
35 pts.
To be back in the IT career
Hi, I have 8 plus years of experience in the IT industry doing development using Lotus script, Javascript & HTML. Did Project Management to become a Porject Manager. But currently I can't find job with my background. I am trying to upgrade my skills but not sure where to start. I need some advise....
Hi, I have 8 plus years of experience in the IT industry doing development using Lotus script, Javascript & HTML. Did Project Management to become a Porject Manager. But currently I can't find job with my background. I am trying to upgrade my skills but not sure where to start. I need some advise....
Career matchmaking - program development
I am interested in making software that allows potential employees to find employers who are offering what they are looking for in a job (be it salary, benefits, location, a specific job, etc). I also would like to have the vice versa of the scenario where the employer can look for a specific type...
I am interested in making software that allows potential employees to find employers who are offering what they are looking for in a job (be it salary, benefits, location, a specific job, etc). I also would like to have the vice versa of the scenario where the employer can look for a specific type...
data copy - paste from the same table not showing in a subform
I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...
Answer Question
| Jun 30 2009 3:50 AM GMT
Microsoft Access 2007, Microsoft Access, Database programming
I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...
Answer Question
| Jun 30 2009 3:50 AM GMTMicrosoft Access 2007, Microsoft Access, Database programming
Microsoft Access Audit Report
I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...
I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...
Access Reports to PDF file
Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...
Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...
0 Row affected
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM], = dbo.[Elution_Report]., = dbo.[Elution_Report]., =...
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM], = dbo.[Elution_Report]., = dbo.[Elution_Report]., =...
Pictures in a DB
In my DB I have a picture in each record but it now says I have no more space available...How do I get round this?
In my DB I have a picture in each record but it now says I have no more space available...How do I get round this?
Reminder: "Cert success story" contest ends June 30th
As some of you may already be aware, one of our bloggers, Ed Tittel, is currently running a contest on his blog IT Career JumpStart. The contest is called Share Your Certification Success Story, Win an MS Voucher, and the six winners who share the best stories about someone whose life was affected...
As some of you may already be aware, one of our bloggers, Ed Tittel, is currently running a contest on his blog IT Career JumpStart. The contest is called Share Your Certification Success Story, Win an MS Voucher, and the six winners who share the best stories about someone whose life was affected...
Showing a substiute value in a report if conditions are met - Access
In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...
In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...
Information Security Degrees
As an IT security professional, does it really matter which school a degree is earned from? For example, I have two schools that are both online and regionally accredited: American Military University and University of Maryland University College. AMU offers a B.S. in Information Systems...
As an IT security professional, does it really matter which school a degree is earned from? For example, I have two schools that are both online and regionally accredited: American Military University and University of Maryland University College. AMU offers a B.S. in Information Systems...
dynamic temporary table variable usage
We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...
We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...
Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is...
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is...
Deleting Nightly Database Backups (dumps)
How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday
How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday
MS-Access
Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...
Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...
top values and ranking
What function do i use to give a field a ranking based on it's current sorted position in a query. I do not want to use a running sum on a report - it needs to be in the underlying query as I am going to have to join several together.
What function do i use to give a field a ranking based on it's current sorted position in a query. I do not want to use a running sum on a report - it needs to be in the underlying query as I am going to have to join several together.
about visual basic.net
Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my...
Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my...
Disconnecting a Crystal 8.5 report while report is open in VB6
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which...
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which...
