I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

hi! I’m new here! I have a report and this is connect to db2/as400. When I compile i have the next error “[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause….” I don’t know what is happenning. The query I run in other program and this is right, so I think is something with Jreports!! thanks…

WE have been using the same ACCESS Database for 7 years.  Suddenly, worksheets and reports that have always printed out perfectly are not dropping entire pages; for example, if there are five pages of information, it will drop page 2-3-4 but print page 1 and 5.  What would cause that?

I am trying to use DlookUp to get field values from a previous recrod wher the records have been filtered.   I have found the code below but it refers to ID-1, rather the actual ID that may be the previous record resulting from the filter. =DLookUp(“[MyField]“,”MyTable”,”[ID]=Forms![MyForm]![ID]-1″) Any suggestions? Thank you.

ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can’t gain access to…

HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT NB : THIS…

I have been studying Sap modules FI-CO I have had hours of practice on dummy configurations, I have got to a point where l feel a lot confident that I can do this job. I just dont know where to start, all the job that I have seen they all asking for someone with lot…

i am using Crystal Reports 10 to display data from ODBC. The error “Failed to open rowset. Details:HY000:

how to stop the replication page from popping up in lotus notes where background replication is enabled

Hi All,       I am currently in IT Industry as Oracle Apps Technical Consultant since last 3 years.       I have learn OBIEE (Admin and Presentations Services) and around 6 months work experiance in OBIEE (Admin and Presentation Services). Now, my confusion is is really help this way of learning my career means Oracle Apps Technical…

I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!):  Proposal, Supplier and Parts.  The report is for the Proposal.  It is grouped by Supplier and then has a subreport…

I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Want to use Boomi to access JDE DB2 What do I need to define on AS400?

I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all types of errors – data mismacth, byval required, etc..…

Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE DEFINER=`admin`@`localhost`…

I’m having a problem with opening a shared database in Access 2002. I open it on a specific workstation as a shared database others users cannot open it. But when I open it on any other workstation as a shared database everyone can open it.

HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a lot.

hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the…

I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when I try to access it, I…