Recent content by WuCOng

Anyone?

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

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

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?

Ack! I meant from Access, not Excel!

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.

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.

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

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

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

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?

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

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

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?

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?