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...

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...

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...

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...

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...