Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. neilmcdonald

    SQL Output parameters

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

    SQL Output parameters

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

    Disable button based on sql output parameter

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

    SubQueries

    That's exactly what I need - Thanks!
  5. neilmcdonald

    SubQueries

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

    NTBackup - High CPU Usage

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

    NTBackup - High CPU Usage

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

    Customer Portal

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

    mobile licensing question

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

    mobile licensing 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...
  11. neilmcdonald

    Update multiple records from one form

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

    Update multiple records from one form

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

    Complex report - Aliases and possible subquery?

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

    Complex report - Aliases and possible subquery?

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

    display subform with selectd record - nearly there?

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

    Email from continuous form

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

    Subform problem

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

    Subform problem

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

    Subform problem

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

    Subform problem

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

Part and Inventory Search

Back
Top