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

    How do I create a counter to keep track of how many Records are Return

    i have found a downloadable demo on a site that has a module you can put into your sql/query that will work this out (in theory) site url: http://www.data-flow.co.uk/technique.htm download url: http://www.data-flow.co.uk/download/running_totals_2.zip it has directions and everything, Hope...
  2. davesmith

    i want to move between records within 1 screen

    i'm writing a confirm screen for a system, i only want 1 record per screen, but i want to be able to switch through the records without confirming. ie. <last next>. i'm opening the full record set, but only displaying the first record at the moment so i need to add into this a movenext applied...
  3. davesmith

    Setting up a print letter page

    We are currently setting up a user system using sql and asp. we want to print letters from this system. In a letter, for the first page we have a header and a footer and for all subsequent pages we have a footer. Is there a way of putting headers and footers in a flash file? please, i love you...
  4. davesmith

    Can i logout automatically

    I want to log my servers out at 7 every night, but i want to leave work at 5!! Is there an auto logout option in windows that will let me do this? Cheers and Stuff DaveSmith
  5. davesmith

    a refresh on key press, thingy!!

    What i'm trying to do is show a list of names in last name alphabetical order, then i want a text box somewhere on the page, if box is &quot;&quot; then shows all records, if text is typed into box then it refreshes that data to only show matching records!! I know this can be done using a LIKE...
  6. davesmith

    Import Comma Delimited Data

    Someone has written a package which we plan to get some of our customers to use! Problem is it exports and emails all data in comma delimited form!!! What i want to do is get our staff to copy these files to say, the network in a temp file, then on our intranet/internet somewhere have an...
  7. davesmith

    Report - field for total number of checkboxes that have a yes

    Why make it harder, in your report have you 3 columns Username Requests Approved Group by user name, if you want your text to be on one line i.e, name 3 2 then leave the group by section empty, reduce the height to 0 and all your records will look in line with no gaps. Field1 = username...
  8. davesmith

    breaking down (because of) a date

    ok, i think i've got how to get the start/end date etc.. main problem is that i'm working with dates of birth. 14/10/78, 12/10/56, 04/03/80 i have also got to take into account these are pre 2000? The info is from a different system which i am taking selective data from. Meaning all i want...
  9. davesmith

    breaking down (because of) a date

    I have a table, this contains personal details such as name, address, and Date of birth, this is what my problem is. In the system i'm writing i want to have a screen which pops up after login with all a member of staffs' clients who have a birthday in say the next 21 days. In access i managed...
  10. davesmith

    Group By in ASP page

    If you have a table with your customer details in (unique codes) you could either run for all or selected, or even between dates, whichever query you run, but you could do it like this A = id table B = sales table open A, goto first record, do while not A.eof dim personID personID =...
  11. davesmith

    EASY DROPDOWN QUESTION HELP

    I was checking through some of our combo box coding and found this which pulled through vat months <select name=&quot;vatMonth&quot;> <option selected value=&quot;&quot;>Select...</option> <option value=&quot;June&quot;>April</option> <option value=&quot;September&quot;>July</option>...
  12. davesmith

    Active Directory and stuff

    I have read thread333-119488 and it makes sense to use the permissions on each folder to stop unwanted users to log in, unfortunately i need to go a little further, I am looking into the software that is featured on the same thread but i'm a bit dubious as to whether it does exactly what i want...
  13. davesmith

    Where is the data stored in sql!!

    I have had a search through and i have found a file called AMIS.mdf (AMIS being the project i'm working on), but i'm going to try putting the other server onto the same intranet, export the database using the export option in sql. This should work!! (i hope) Dave
  14. davesmith

    Where is the data stored in sql!!

    We are currently designing our new web based system using sql server as the backbone... Now we have created it to an extent on our internal servers we want to transfer our data to another server which has links to our webserver (heaven forbid we would give people access to our intranet) As we...
  15. davesmith

    Saving a field in a database with a class

    i am currently writing a mailmerge &quot;on the net&quot; type page for our customers, yet sql only lets you save in one font/bold/underlined etc in each field. I have found a way round this, but what i want to be able to do is, say i'm going to do a heading under the addres (which is picked up...
  16. davesmith

    mail merge using fields

    No.... I don't actually think its possible, the way i think i'm going to have to do it is.... Fields... LetterID, LetterSection, Text i.e. 132 1 (in bold)holidays 132 2 section 1 of letter and so on. I'm working in ASP and so i will have to...
  17. davesmith

    mail merge using fields

    i'm trying to create a mail merge facility for our staff / clients to be able to enter the letter text in a field in sql, then use that through a web page to create a mail merge using fields from another SQL table. But my question is, can i specify in a field differences such as allignment...
  18. davesmith

    I need to pause / delay

    On an if statement ie. if not authorised user, i want to print to the screen, easy enough. Then i want to redirect to another screen, again fairly easy. But i want the person to be able to read the message, so i want to have a delay in there for say 3-5 seconds between writing and redirecting...
  19. davesmith

    Print Setting - can i set them using ASP

    I am creating a report for on the screen, i also want to print it off. Can i enter code to automatically print the page in landscape from the browser. Can i also set margins!!!! Is this ASP or javascript, am i going to be able to do it? So many questions........ Cheers Dave
  20. davesmith

    Input masks!!

    Shtop, Shtop, We have a misunderstanding. I want all i want to know is how to accept/display data in a certain format. In access i would go into the Input Mask and type (for this same code 12-12-12) 00-/00-/00, this would put the number in the field as 121212 but would accept entry 121212 and...

Part and Inventory Search

Back
Top