access 2003, create a form that allows you to search for an employee and to edit you have to have permission

How to create a form that allows you to search and edit if you have permisson. I don’t want the information to be edited if the person viewing doesn’t have permission



Answer Question   |  June 27, 2012  2:35 AM
Access 2003, Access 2003 forms, Microsoft Access 2003 permissions
asked by:
5 pts.

How to replace the batch query in QMF thru JCL?

i have one batch query in DBC4MED1.BR211Q_SALEANAL(PRODUCTION).. this batch query is running thru the QMF PROC DBC4MED1.BR211P_SALEANAL to create a report. now i have made changes to the batch query and saved with my HLQ  (PM7351.BR21Q_SALEANAL) in QMF.Now i want to repace the query in DBC4MED1.BR211Q_SALEANAL with the modified query which was there in my HLQ…



Answer Question   |  June 27, 2012  2:35 AM
AS/400 batch jobs, JCL, Mainframe jobs( JCL, QMF, QMF Objects
asked by:
5 pts.

access data change history

i wanna know if the data entry will change the entered value more than one time or if i can make history register for data update and change



Answer Question   |  June 27, 2012  2:35 AM
Database, Microsoft Access
asked by:
115 pts.

Will SAP CRM add to Oracle CRM functional profile

I was working as Oracle CRM consultant a month back with 2.5 years CRM experience. I have very good knowlwdge & experience of Oracle CRM service modules like Contracts, Field Service, TeleService, Install Base etc. This economic downturn has pushed me out of job. My question is will it be helpful if I go for…



Answer Question   |  June 27, 2012  2:34 AM
Career development, IT careers, IT Job Market, Oracle CRM, Oracle Customer Relationship Management, SAP careers, SAP CRM, SAP Customer Relationship Management
asked by:
5 pts.

Migration from Paradox to MS Access or VB.Net/MS SQL

We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.



Answer Question   |  June 27, 2012  2:32 AM
Access 2003, Microsoft Access, Paradox 11, SQL, VB.NET, VB.NET 2008, Windows Server 2007, Windows XP
asked by:
45 pts.

Migration from Paradox to MS Access or VB.Net/MS SQL

We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.



Answer Question   |  June 27, 2012  2:32 AM
Access 2003, Microsoft Access, Paradox 11, SQL, VB.NET, VB.NET 2008, Windows Server 2007, Windows XP
asked by:
45 pts.

ERP Finance Consultant

What is the job skills required for an ERP finance consultant



Answer Question   |  June 27, 2012  2:32 AM
ERP, IT careers, Oracle
asked by:
10 pts.

Accessing abc.csv AS/400 files

how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice



Answer Question   |  June 27, 2012  2:30 AM
AS/400, AS/400 CSV, CSV, CSV file format
asked by:
345 pts.

SAP MM (Materials Management) career

AM Basically BE{MECH}.MY age is 41yrs. I have goy domain experiance of 13 yrs. Can i do sap mm at this level? Am planning to change my field to, sap can i?



Answer Question   |  June 27, 2012  2:26 AM
Career development, IT careers, SAP careers, SAP Materials Management, SAP MM
asked by:
40 pts.

SAP MM (Materials Management) career

AM Basically BE{MECH}.MY age is 41yrs. I have goy domain experiance of 13 yrs. Can i do sap mm at this level? Am planning to change my field to, sap can i?



Answer Question   |  June 27, 2012  2:26 AM
Career development, IT careers, SAP careers, SAP Materials Management, SAP MM
asked by:
40 pts.

Flickering subform in Access

Hi, I have a continuous subform that, upon opening the database, flickers constantly. This flickering can be stopped either by alt-tabbing away from Access and back again or by hitting F9. The main form has a button that changes the source object of the subframe to a different continuous subform, and the same behavior is…



Answer Question   |  June 27, 2012  2:26 AM
Database, Microsoft Access
asked by:
5 pts.

What’s your fastest /’Unique number’ issue method?

Once again I need to incorporate a mechanism which will issue a unique number as an object discriminator. I’m sure we’ve all been there. – Incorporate a timestamp – quick and almost always unique, though this application will be busy, so the multiple ‘threading’ is attractive, Big problem is the length though, I only have…



Answer Question   |  June 27, 2012  2:25 AM
AS/400 TimeStamp, IBM i, IBMi RPGLE, Timestamp
asked by:
5,505 pts.

Copy old database as new

Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com



Answer Question   |  June 27, 2012  2:18 AM
Database replication, SQL Server 2003, SQL Server replication
asked by:
25 pts.

Copy old database as new

Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com



Answer Question   |  June 27, 2012  2:18 AM
Database replication, SQL Server 2003, SQL Server replication
asked by:
25 pts.

Highlight Keywords in Access 2003 Forms

I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?



Answer Question   |  June 27, 2012  2:15 AM
Access 2003, Database programming, Microsoft Access
asked by:
5 pts.

Certification recommendation?

I have a Bachelor’s in Business Administration and have worked in the field of office administration for over 10 years. I have recently been given the option to move over to IT Compliance as a Risk Analyst. My boss the CIO feels this would be a great field for me to get into. The only…



Answer Question   |  June 27, 2012  2:13 AM
Certifications, CISA, Information security careers, IT careers, IT Compliance, Risk Analyst, Security certifications
asked by:
5 pts.

SQL Server error 7125: Updated driver to get around?

I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or…



Answer Question   |  June 27, 2012  2:12 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32
asked by:
5 pts.

AS/400 EXIT POINT

Hi , Has anyone worked on exit point  PGM  . I trying to write one  small PGM for allowing ODBC connectivty to my Box from specific Ip address and Userid  . When i do WRKREGINF i can see lot of exit point dont know which is used for ODBC connectivity  . . Any inputs are…



Answer Question   |  June 27, 2012  2:11 AM
AS/400 Exit Points, ODBC, WRKREGINF
asked by:
245 pts.

Error copying indexes in DTS package

I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a…



Answer Question   |  June 27, 2012  2:11 AM
DTS, Indexes
asked by:
45 pts.

AS400 Query Join

I need expert help. I need to create a query that will use four tables. Each table has a column of data that I need for the report. The end result should display the following: Name, City, Amount, Reason.  Here is my first query that gives me the name and city: SELECT “T16.GNAM”.N_NAME, “T16.GNAM”.N_CITY FROM…



Answer Question   |  June 27, 2012  2:07 AM
AS/400 Query, JOIN, JOIN statement
asked by:
365 pts.