Search results for query: *

I'm trying to write some code to use Python to create a real Excel 2010 file from one of the iSeries files. I've created a command that accepts an SQL statement and an output location as parameters. It works perfectly when only one file is involved, for example listing all transactions for a...

I have a query that accepts 3 parameters and should insert a record into a linked table. It doesn't kick up any errors but it doesn't write the record to the table either. Set qDef = db.QueryDefs("qryInsertChild") qDef.Parameters("Master ID") = txtID ' Process all of the selected records...

I've got an Access front end that links to a Sharepoint back end. In the table one of the fields is called [Requestor / Contact] - Note the spaces When I use query designer to select this field and run it from within query designer it shows Okay. When I save the query it changes it to...

I've been given the task of putting a friendlier front end over a Sharepoint "database". Part of this involves importing test data from an existing Sharepoint list, about 4K records. I'm using liked tables thru Windows Sharepoint Services. If I open the table directly I can key the information...

At times when my users are working with an Access application it jumps into the VBA code editor for no reason. I say no reason but really I mean I don't know why it does it. There are no errors, no break points, the user isn't debugging the code. In fact, when he sees the VBA behind the scenes...

I have a table holding character values that should be used to replace occurences in text fields on another table. These are characters that do not occur in the standard english character set. Examples are ă and ƣ. If I view the table, create a query or display the data on a form then it shows...

Guys I'm looking for the downloadable pdf version of the iSeries System API Reference Manual. This is the Reference manual SC41-5801, not the Programming manual. I downloaded it ages ago but I've lost it and can't find it on any of Big Blue's websites. I got a link from IBMs help centre people...

I'm using XML-Into with a handler procedure to read the contents of an XML document held as a file in the IFS. It works really well apart from one thing. When any characters that XML regards as Special are included in the data it ignores them. Things like &, <, > and =. In one example, a...

I'm currently running several financial applications written in Access 2003 Pro which use listboxes to display information. The code is fairly straight forward with some SQL built on the fly to let the users select on multiple categories and display only those rows which match. The problem I'm...

I have an Invoicing database in Access2003 which I wrote a few years back and it has been working well for all that time. One of the main forms shows a listbox which is populated by a query showing invoice number, customer, invoice date, pay date, invoice amount and pay amount. The table which...

I've got a subform that allows me to key in payments received against an invoice. It shows four columns: Invoice text, invoice amount, payment date and payment amount. On several invoices I get things that show the payment amount correctly but when I move the cursor into the field it changes...

I'm looking for a way to save source members into text files that I can save easily without using save files. I've had a problem in the past in shops that don't allow RSTLIB or RSTOBJ when I'm trying to restore sample program sources (just to make life easier). I'm sure I heard somewhere of...

The place I'm working installed IBM's ClientAccess package on my laptop to let me view an AS400 database. Unfortunately, when I go into an existing (totally separate) VB6 project the data designer can't access the database it uses (Microsoft Access 2000) giving me the error message "Provider no...

I'm opening a recordset with a different selection so I'm checking first whether it is already open before closing it. If dteData.rsAgentDetails.State = adStateOpen Then dteData.rsAgentDetails.Close End If dteData.AgentDetails txtAgentID The recordset is open according to...

I've got a laptop with an Ethernet 10/100 port and also a Linksys Wireless-G card. If I'm using the Linksys card, when I go into IE6 I can't see the internet, when I go into MS Outlook I can't access my mail. When I'm actually plugged into the Ethernet cable everything works Okay. I don't think...

I'm trying to install Visual Studio .NET and it freezes when I insert the third CD. I'm getting pretty p****d off by now 'cause this is the third time I've tried. Anyone had the same problem and solved it? PeteJ (Contract Code-monkey) It's amazing how many ways there are to skin a cat...

I have two desktops and a laptop on my home network. One of the desktops is WIN XP, the others are WIN2K. Even tho I set up the WINXP box to get IP addresses automatically it totally ignored the address allocated by the router until I found out how to disable it (IPAutoconfigurationEnabled in...

I've got a broadband router with three PCs attached, two thru Ethernet, one wireless LAN. Two of them are Win2KPro (including the one with the wireless LAN card) the other is WinXPPro. As recomended by the router instal instructions I've got all of them obtaining the IP address automatically and...

I've never tried defining a column in a table as type OLE Object so that I could store an image directly in the table but I'm going to try it out in the near future. Can anyone tell me how you actually put the image into the field and is it possible to make an Image control a bound control to...

I'm looking for an API which gets me the same info as doing DSPPGMREF to an output file. I've been trying to move away from anything which dumps into files to use APIs instead (for example using QDBRTVFD instead of closing/clearing a file, doing DSPFFD to that output file then opening/reading...