Search results for query: *

Hi, I have a really old access db.. it wasn't created by me and I'm not really a programmer so I'm struggling to figure this out.. It is used to store certificates, on one of the forms there is an small thumbnail of the document ( PDF ) when you click on the image it opens the PDF document...

Hi, OK so what I'm trying to do is do perform a calculation depending on the TRANSACTION CODE... so in the example below the OOREC transaction are parts produced and SUNREC are parts scrapped, so for ORDER_NO 12345 we need to add the OOREC with is 150 and subtract the SUNREC 25 which should...

Hi, I'm new to Oracle / plsql I'm trying to find a way to write a simple query but use sysdate as a default parameter, but this parameter can be changed by the user if necessary. Thanks, Mick.

Hi, OK so I've got some data an example below TRANSACTION_ID MACHINE_NO PART_NO QTY VALUE ORDER_NO DATE 1234 123 abc 5 12 123 17/07/2018 1234 123 abc 5 7 123 17/07/2018 1234 123 abc 5 3 123...

Hi, I have a report, all detail sections no groups, no report header just page header with some fields. On most reports it prints the information on every page but some it misses pages ( but always prints on the first page ) If I make some of the detail sections either larger or smaller i can...

Hi, I have a report that is looking at the rejects that have been made. all info is in one view, contents below: Transaction ID Part Number Date Rejected Value Now depending on when the part was rejected there could be multiple values, for example Raw material cost, labour cost, overheads...

Hi, I'm looking for a solution to try to save me from writing multiple reports, what i need is to be able to choose which data is included in the report depending on the report type ( if that makes sense ) For example.. report 1 would need to include part numbers beginning with M and have...

Hi, I'm using Crystal XI I have a report that can have a different layout depending on the part number, there are 4 different types of part as below part type 1 - A1234 part type 2 - M1234 Part type 3 - P1234 part type 4 - MK1234, AK1234 or PK1234 So I've created different sections so if part...

Hi, I know this question has been asked many times before, but I was just wondering if any new way has been discovered to do this. i have seen the idea that you add another table with numbers 1 ..... 2000 or whatever you want but this is not possible for me, I am using Crystal XI is there any...

Hi, i have a report that pulls customer order details that need to be delivered by a specific date and this works well. what I have been asked to do is to add another parameter that breaks it down by part number, the issue is that the part numbers all begin with either F* or R* ( this is a...

Hi, A bit of a long shot but here goes... I'm looking for a way to find which documents contain hyperlinks to a certain document, at the moment I'm going through each document and checking each hyperlink. But was just wondering if there was a way to either find documents linked to the document...

Hi, our NAS server has died and we are looking at replacing this, our exchange server ( windows server 2008 r2 and exchange 2010 ) has 1TB of free space so was just wondering if there would be any issues using this server as a file server? Any comments/advice? Regards, Mick.

Hi, As the title says we have implemented Exchange 2010 ( standard ) running on Server 2008 r2. we have purchased Backup exec 2012 and was looking for a guide on how to backup the server and how to restore it completely as in a disaster. I have performed a full backup on the server with...

Hi, I'm looking at creating a database, either from scratch or importing an access database, then creating a 'frontend' to access the data, create forms and reports etc... What I'm really looking for initially are idea's for the best way to accomplish this, I'd like to try to do this as...

Hi, We have recently upgraded from office 2000 to office 2010, all went fine but we have got one issue that I hope somebody can shed some light on and hopefully resolve... We created quite a few documents in word 2000 with a footer that contains a date, format is dd/mm/yyyy but when we open the...

Hi, I'm using crystal xi querying oracle 10g.. What I have been asked for is a report to show all orders and all scheduled orders broken down into 0-30 days, 31-60 days, 61-90 days and 90+ I've created 2 groups ( customer name and part number ) I created multiple formulae for each of the date...

I'll give a brief overview of our setup then get onto the issue.. We have one domain ( 2008 r2 ) with 2 sites each site has its own exchange server ( 2010 ) each server has its own mailbox database for users and also its own public folder database. Earlier this year we upgraded to our current...

We have recently started using BE 2012 with a quantum value loader as the hardware, we are using a full backup / incremental back up method. We are doing a full backup of all servers over the weekend, this takes 4 tapes so we have partitioned the valueloader with slots 5 - 8 for the full...

Hi, We are using access 2000. we use a product code of A1234 -A, A1234 -B, B1234 etc... In a query we use the mid function to bring back all part numbers no matter what prefix it has, so if we query for 1234 it will bring back all parts.. the query is Part: Mid([tblPART].[strPartNo],1,5)...

Hi, We have a database that records all the calibration equipment we have, and the dates that they need recalibrating, I've been trying to get it to change the border colour from green to red if the date has passed. I set the border colour on the form to be green, but then in vb set it to red...