Search results for query: *

I resolved this - I has the incorrect type set for the input parameter. Thanks anyway...

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

That's exactly what I need - Thanks!

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 Dave, The folders aren't compressed or encrypted. It has ocurred to me that this server is using different anti virus software to the rest. I've changed the settings on that, and I'll see what happens. Thanks, Neil

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

Thanks - apologies if this is a silly question...

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 jpadie, Thanks for the quick response! The code I had in mind for the processing is very much like your last example. Could you possibly explain further how the txid in your example would be entered into the array from the form? Sorry if this a dumb question - I'm pretty new to PHP.

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

Thanks hilfy - I appreciate your help. That seems to be working for me. If you've got any links or sites that explain the logic behind this, I'd love to read up a bit to increase my understanding...

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

Thanks AceMan, The combobox works within that form, but I still can't see how to open that form from another, with the relevant record displayed. Just to clarify, the search form will be used to find particular records(e.g. all those jobs completed by a particular engineer). I then want to be...

Fair Question! The continous form doesn't show all of the detail that the other form does.

Thanks for the quick reply! My subforms aren't synchronized with the mainform - should they be? There's no data shown on the mainform itself, only on the subform - if that makes any difference... Thanks, Neil

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