Search results for query: *

I'm running Access 2007, and have been without issue for a couple of years. Over the last few days I've been experiencing a problem with writing queries which seems to be universal to any Access database I'm using - any query I write with a Function in the QBE grid causes an error: "The...

Hi I may have posted this in the wrong forum, possibly a VB forum would be more appropriate, but please bear with me. We use access databases to produce ad-hoc reporting information, and as time goes by, the number of databases tend to multiply, meaning that it becomes difficult to find queries...

I have a VBA procedure which updates several back-end Access databases and then compacts them remotely; however this will only work if I have exclusive access to each of the back-end databases, and since they are used quite heavily it's hard to find time in the working day when this is the case...

We have a series of databases which we've been using successfully for a few years now, all in Access2003, which has been converted from 97 a year or two ago now. All of a sudden they've all been failing on the following bit of code: Dim DB1 As DAO.Database Dim RS1 As DAO.Recordset Dim SD...

My PC's been on the blink for a while - I should have got it fixed but was always going to get round to it another time - it would simply power down out of the blue, and then not start up again until it had had a good 12 hours' rest - if I tried to fire it up again before that the light on the...

Just installed a Via Solution USB 2.0 PCI Host Card and also replaced the CDRom with a burner, rebooted and the Found New Hardware Wizard starts, looking for drivers for a)Real Time Clock and b)PCI card. B) I can understand, but why is it looking (and failing to find) a driver for the Real Time...

I've created an Access 97 database on a separate server for users, which is populated on a weekly basis from a BE database which has links to the 'FE' tables and uses queries to delete the tables and then repopulate them using append queries, so to all intents and purposes the database should...

My McAfee license expired, so I stopped receiving automatic virus-definition autoupdates. I'm given to understand it msy be possible to still get said updates on a manual download basis from McAfee, can anyone give me any info on this? Also, should I decide to uninstall McAfee anti-virus to...

Hi I've got a basic understanding of SQL, but am at a deadend here. I'm trying to directly update one table with the values from another where there is a mismatch (the tables are supposed to be in sync sharing the same keys) using SQLPLUS - I'm trying this in the Test area rather than on live...

Hi Some while ago my McAfee Updater expired, I got a download upgrade but couldn't install it as it required IE to be the default internet browser to complete installation; I ended up with 2 versions of McAfee both partially installed and neither usable, and neither uninstallable. I ended up...

OK, hands up, my fault; my Antivirus software is out of date (McAfee). I dloaded mediacodec-v4.732.exe and now I've run it I seem to have software installed that is allowing all sorts of advertising popups and stuff, including from Falcon Antivirus!? I did a HijackThis scan, but I've not the...

Hi Not sure if this is the right forum (please redirect me if so), but I've got a home PC which has McAfee Firewall/Virus Scan installed, and my daughter has just installed MSN Messenger, and I've heard rumours that it compromises security, can anyone enlighten me as to the risks, and what I...

I'm using Acc2002. What I'm trying to acheive is the following: 1st database (Db1) does some processing Db1 then opens 2nd database (Db2), which will start processing Db1 closes itself down. Db2 completes processing. How I was hoping to acheive this was using this code: Dim strPath As String...

The set-up: Oracle-based HR system (MidlandHR Delphi Millennium), from which we run reports (outputting large chunks of the DB tables) on a weekly basis. These are output in a text format, and manually FTP'd across to be picked up by Access download, which converts them into Access tables, so...

This may not be the most appropriate forum for this question; if it's not please excuse me. We're currently using Oracle Release 8.1.7.0.0, and were looking into getting some Oracle Certified training, but Oracle have retired the 8i exams now - is 9i comparable? Laters, Z "42??? We're going...

Hi All I'm very new to SQLplus, so forgive me if I'm blundering around in the dark here, but I wanted to do a simple one-off update on some of the records on a date field, which for some reason have been uploaded wrongly and ended up 100 years out - all the year values are 1903 instead of 2003...

I can't be sure this is a hardware issue, but having reformatted C: drive and reloaded windows with no effect, this is what I suspect. The problem is that after a short period of system run-time, the PC attempts to reboot, no warning, nothing, same as if I'd hit the 'reset' button. Then reboot...

Hi I want to set up a mailmerge document to an Access database (so far so straightforward) BUT I've got a field in the database which is set to data-type 'OLE object' and contains a bitmap of a signature, which I then want to out on my Word mailmerge document as a merge field - is it possible...

Just a quickie: I'm doing automation to send an Outlook email from Access, and I'm sure I've seen somewhere with the Object.Send a property that allows you to turn off the automatic spellcheck on send, but can't find it after searching these pages for some 20 minutes - anyone know what it is...

Hi All We have an Access database located on a network that on occasion, but far from all the time, leaves a lockfile hanging, and then as a result the database won't re-open. The .ldb file is on the Task Manager, so is at PC level rather than server, and the hanging event happens both through...