Search results for query: *

Hi all I have a slight problem... We have an access db (2003)that records helpdesk tickets, the DB then sends out an e-mail via outlook to the relevant support person when a button is pressed. this works fine for the majority of the users, however a couple of users are experiencing problems -...

Hi all A colleague of mine is developing an access database that sends an e-mail on the click of a button (the code is below), this works fine on her PC, but when I try and run the same process on my PC then I get the "Activex Component can't create object" error. We have both been looking at...

Hi I have been looking into an issue we have with one of our reports - unfortunatley I can't seem to see what the issue is and I was wondering if anyone could help. We have a report that was written in 6i that displays batch payments that have been made, however occasionally, one of the fields...

The only experience I have with loading images is through Forms, and this is done using the READ_IMAGE_FILE built in. I'm not sure if it help.... James

Cheers Dima - Works great.

Hi We have a report (v6i) that we want to look like a letter, Half way down the report, after the usual niceties, there is list of events, and depending on the number of events that where ticked by the user on a form depends on how many are included on the report. This works fine until it...

The documentation states.... -------------------- ORA-01002 fetch out of sequence Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set...

Hi Silvia I had the same problem a while back and I added an extproc_connection_data parameter to my tnsnames file, this seemed to clear up the problem for me. There is lots of info on this error on metalink. HTH James

I have a table that I scan barcodes into, this table shows the full character string of the barcode and it is then split, using a query. i.e. aaa111y (barcode in a table) would display aaa 111 y (in the query) however I need to be able to validate the first three characters of the...

I use the following procedure to send mail using outlook, you can play about with it so that you preview the mail before it is sent or choose to send it straight away (by just commenting out the 'display' or 'send' lines). James --------------------- PROCEDURE SENDMAIL IS objOutlook...

Thanks for the help Lewisp, just one more quick question, how can I deal with a null value, e.g jc.add2 may not contain data and therefore will throw the fixed length format out. Cheers James

Hi I am currently using the following procedure on a v6i form to extract data from a block and create a file, everything with this current procedure works fine, however, as is usually the case, my users requirment has now changed to a fixed length file rather than a '#' delimited one. I have...

Thanks Chrissie1, Works great. ;-)

Hi, I am currently playing with access, and intergrating barcodes into it. I am able scan barcodes into a table, no problem, but now I want to take things a step further. What I would like to be able to do is split a single barcode into seperate table columns using a delimiter e.g. a...

Hi To get a column separator to be a '|' you need to.... 'SET COLSEP |' Hope it helps James