Search results for query: *

Hi, I have a page with a sqldatasource and a detailsview. The sqldatasource uses stored procedures for select and update operations. When the page first loads, everything is fine, the select stored procedure returns three output parameters, which are used to determine which buttons on the...

Hi, I have a sqldatasource using a stored procedure with an output parameter. What I would like to do is enable/disable a button based on the value of that parameter. I think my problem is to do with timing - I'm not sure at which point I should test the value of the parameter. I'm also not...

Hi, I have two tables, Job and Event. A Job has several events and the tables are linked by jobid. Each Event also has a status. I need to find the status of the last event for each job. I've gotten as far as finding the last event for each job by doing the following: SELECT...

Hi, We have a small business server (2003) which shows NTBackup as the top process by cpu usage. The figure on the performance report is 79.7%. Other servers that we look after are nowehere near this figure. Can anybody give me any tips on where to start? Thanks, Neil

Hi, Our Server contains a folder for each of our clients, and we are looking for a way to make certain files available to each client via the web. Can this been done on SBS, perhaps using Sharepoint? The files are changed regularly, so ideally I don't want to have to upload to a website every...

Hi, I have SBS 2003, with 5 CALs. I intend to have 3 PCs connected permanently, and 8 smartphones running windows mobile 5 (using direct push email). Can anybody tell me if I would need to buy more CALS for my server - i.e. do the smartphones take up a license? I'd appreciate any advice...

Hi, I've seen several posts regarding updating several MySQL records from one form, but I can't get my head around how to make it work for me... I have set up a form which contains a table. Each row contains one job, which included a jobid and a drop-down of job status. What I need is to be...

Hi, I need to write a report in Crystal 8.5 to read data from a SQL server. The problems are: a) I cannot see a way to use a parameter to restrict the data b) I cannot format the data in columns There are four tables as follows: Contacts: ContactID, Name Event_Attendees: ContactID...

Hi, I have a main form with a subform. command buttons on the main form control the recordsource for the subform. I have a continous form and a another form with more details. What I would like to be able to do is double click the row on the continous form, and display the other subform with...

Hi, I have a continuous form based on a query. The form shows outstanding jobs, and allows the user to allocate an engineer to each job. Once all the jobs have been allocated, I would like the user to click a single button that will send an email for each job, to the relevant engineer. I...

Hi, I am creating a database in Access 2003. I have a main form with two subforms. The two subforms are in the same place, and their visibility is controlled by command buttons on the main form. One of the forms is a continuous form for searching - what I would like is to be able to double...

Hi, I'm trying to write a simple database to keep track of the jobs our company works on. Each job is entered into the system and then allocated to an engineer at a later stage. I've created a query to show only unallocated jobs, and a form based on that query. What I need to happen is...

Hi, I've seen a few posts on this topic, but I'm afraid I need even more help! I'm using Crystal 8.5 to generate mailing labels from an SQL (Saleslogix) database. The problem is label wastage as it is not currently possible to select the starting label for the print. One of the other posts...

Hi, I am reporting on a SQL (Saleslogix) database using Crystal 8.5. The tables are as follows: Contact Event Attendee Event What I need to do is look only at the contacts who have attended a particular event, and then report on which other events those people have attended. If I use the...

Hi, Is it possible to show the difference between two date fields in the format "x years, y months, z days"? I've searched the forums, but can only find formulas to give days and hours. I'm using crystal 10. Any advice would be greatly appreciated. Thanks, Neil

Hi, I'm having some trouble joining tables in crystal reports 10. It's a SQL database using an ODBC connection. There are 3 tables in the report: Contract Purchase Order Purchase Invoice. The report needs to be grouped by contract, then by purchase order, and then show the purchase invoices...

Hi, I am reporting on a SQL database using Crystal V9. The report contains two tables, one for staff records (MASTER) and one for staff absence (ABSENCE). The report is grouped by location, division and staff no (all from the master table). My problem is that each employee may have more than...

Hi, I have a crystal report written in V9, linking to a SQL database. The report was written using database A, but needs to be run on database B. The database structures are identical, but the names are different. I have set a new datasource location, but get the following error message...

Hi, I'm sure there must be a way to do this, but I cannot figure it out! I need to be able to add a number of working days to a date. I can find numerous examples of how to calculate the number of working days between two dates, but no way of adding them! e.g. A customer logs a call with...

Hi, I'm using the working days and hours formula from Ken Hamady's site, but I have a slight problem: I'm using the formula to work out the response times for our customers - the formula works great for calls with one part, but for any one call there may be several parts, each part having...