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!

  • Congratulations SkipVought 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. WuCOng

    Midi error on startup. How do I fix it?

    The error message is: The SoundBlaster AudioPCI 128 driver cannot load MIDI waveset. MIDI playback disabled. I realise that the Hardware Wizard is for the Voice Modem but as my brother lent the installation disk to a friend and the modem obviously works (I'm using it now!) I'm ignoring it for...
  2. WuCOng

    Midi error on startup. How do I fix it?

    I've put my old mobo in my 2nd PC and everything is fine but the sound. I get an error on startup and the add new hardware wizard starts. I can cancel it and still have sound but midi won't play. my mobo is a Microstar and I've DL'd the drivers for the soundchip but this doesn't do anything...
  3. WuCOng

    Can't find a host that allows ASP-database connections!!

    Everyone in the uk (that's affordable) seems to only offer PHP and mySQL!!ARRRGH!! I only know ASP, VBscript, JavaScript and using ASP with MSAccess. Can anyone point me in the right direction?
  4. WuCOng

    Web hosts that allow ASP links to Excel DBs??? Who should I choose?

    I need to be able to have a portal page that links to several subsidiary sites, some of which will have ASP pages that get infor from an Excel2000 DB. Are there any good, cheap hosts out there? Preferably in the UK. I don't expect too many visitors.
  5. WuCOng

    Can PC150 RAM be used on a PC100/133 board?

    Well, can it? I don't mind if it only runs at 133Mhz. I have been given 256Mb PC150 memory that will (I believe) fit on my motherboard (a Gigabyte GA-7ZXR). I'm just not sure it'll work/not wreck something.
  6. WuCOng

    Activating IDE 3+4 in stead of RAID?

    I've done it!! Just incase anyone else has the same problem this is how it's don (stupidly simlpe really): 1.Make sure that the RAID/ATA100 Promise Chipset is enabled with the jumpers. 2.Disable RAID on the second set of jumpers. Only 1 set of jumpers allows a RAID/ATA100 Promise Chipset...
  7. WuCOng

    Activating IDE 3+4 in stead of RAID?

    My Gigabyte GA-Z7XR has 4 IDE sockets. 1+2 are normal IDE sockets but 3+4 are RAID/ATA100 sockets. I've disabled RAID and enabled ATA100 with the on board jumpers but although the BIOS recognises 4 IDE sockets as possible sources of boot info I can't use 3 or 4 to boot up (if i connect 3 to my...
  8. WuCOng

    How to select records created between or on certain dates in Access?

    shaddow - but even with ' all my other recordesets are generated fine. The only problem is when using dates, and then you have to use # anyway. Neither of these solutions worked. The date clause is just ignored and a recorset of all data, regardless of date_sub, is generated. Nickman - the...
  9. WuCOng

    How to select records created between or on certain dates in Access?

    shaddow - the code works fine without the date bit in it even with the ' in place. The dat_sub is from the compliants table but even with the c.date_sub alias the result is the same. I'll try your method Nickman, thanks, but why does this work and not my method?
  10. WuCOng

    How to select records created between or on certain dates in Access?

    I'm using this code: dim SQLstr, oRS, monthchecker, varNow varNow = Date() 'CALCULATE A DATE THAT IS 6 MONTHS AGO monthchecker = varNow - 183 set oRS = server.createObject("ADODB.Recordset") SQLstr="SELECT s.service_name, COUNT(c.complaint_no) AS num_comps FROM complaints c...
  11. WuCOng

    Pattern matching to validate a form - date and email?

    How do I check that fields in a form match an email or date pattern before being sent? I can check that the fields are not null and that they contain strings of a certain length (or greater) but how do I check for a "@" and a "." character (for email validation) and a date...
  12. WuCOng

    Can you set up a time triggered script in ASP/Access?

    I have a table that is supposed to be updated every quarter (3 calendar months). The data in it is supposed to come from the other tables and it provides a summary of three months data. Can I create a script/procedure in Access/ASP that does this?
  13. WuCOng

    Is it possible to request only data that is from a given period?

    I have a table that has the field &quot;date_created&quot;. I want to be able to pull data that was only created between date X and date Y on to the screen via ASP. The user is supposed to choose the from and to dates via two <select> lists. Can it be done?
  14. WuCOng

    Need help with SQL to create a recordset. Can't work it out.

    I'm struggling with a piece of SQL. I need to create a recordset with two columns, &quot;name&quot; and &quot;number of comments&quot;. The tables are designed like this: Service (table): Fields are: ServiceID (primary key), name, servicetype. Comments (table): Fieldsare: CommentID (primary...
  15. WuCOng

    Inserting data into a MDB with ASP - why can't I do it in this case?

    Yep, makes sense to me Paul. Thanks a heap. Guess I've been looking at the code too long to be able to work it out myself (or maybe those late night AvP sessions have fried my brain :) ). Thanks again.
  16. WuCOng

    Inserting data into a MDB with ASP - why can't I do it in this case?

    I'm taking values from a previous page via request.form and using them to updata a DB. One of the values is the name of a service but Idon't want to insert that into the table, but rather the primary key (which is a number). In order to do this I need to SELECT the primary key WHERE the...

Part and Inventory Search

Back
Top