Search results for query: *

hi, I'm having a problem with a complicated ado query. I'm accessing an access database in which i need data from many different tables, resulting in just one dataset. Problem is, it is impossible to get all of the data i need in just 1 query, so in access I created 2 query's, on which I...

hi biot, You'd help me out too with that FAQ I'm afraid... would you be so kind as to... bart.slegers@pandora.be grtz CPUburn

if it's a .sql script you're referring to: install mysql-front .. a very handy tool for various operations on mysql databases. grtz CPUburn

hi there, you should use a simple nested query like this: SELECT * FROM test WHERE oms IN (SELECT oms FROM test WHERE user = 'user1'); grtz CPUburn

hi, try Mysql-Front !! it's free and comes in VERY handy: you can adress an access db directly or by an odbc datasource, it reads data and table structs and produces a .sql file on the fly grtz CPUburn

hi Response = acDataErrContinue is what you're looking for grtz CPUburn

Hi, Problem: I upgraded to Access 2002, but a client of mine works with Access 2000. -> the default database structure for XP is 2000 format, but it is impossible to make an MDE out of it ! is there a solution to this problem? grtz CPUburn

hi, I'm not at a computer where I can test sql's but give this one a try: "SELECT first(numberfield_name), max(letterfield_name) AS output FROM tablename GROUP BY numberfield_name;" grtz CPUburn

thx guys ! hungster got it right: i tried another brand of RW and these work fine now ! grtz CPUburn

hi y'all Since I installed xp i can still write CD-R's but when I insert a CD-RW in my drive (LG) it does not seem to recognize the disk.. any ideas? grtz CPUburn

hi jacq there's no need to make it that complicated. forget the word macro, all you need is access: check out the following article on the Microsoft support database, it should get you on the right track: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q159328

hi, not sure if this is what you're looking for, but try set db = nothing this will destroy the database object if i'm not mistaking. grtz CPUburn

you might wanna check out the references... grtz CPUburn

up it goes, would come in handy for me too (automatic faxing) CPUburn

you could try copying all of the controls (Ctrl+A then Ctrl-C, to be sure you've got them all) and pasting them on a new form. If you've got code behind the form, copy it onto the other form too. Access pulls this kind of tricks once in a while, and pretty often this solution works for us...

hi, very easy solution, requires a reference though: 1. reference the access object library 2. use dbengine.compactdatabase "source", "dest", , , "pwd" to compact it hth CPUburn

FYI access does rename the db, but when compact finishes, it renames it back grtz CPUburn

nobody?

Hi, Is it possible to adress Netscape from VB6 similar to adressing Outlook, creating mails, adding attaches and sending it? If so, where can I find any documentation on it? I tried the netscape developer section, no success though.. hope anyone comes up with an answer, this is really...

Hi, is there a way of creating and sending a mail from within access in Netscape mail program? If so, is it possible to add an attachment? grtz CPUburn