Search results

Hi, yes, bad terminology on my part, it is a parameter to the query and it is being passed through correctly already, I've even just made sure as you suggested by changing the parameter names. The error still remains the same.

I believe I've had the " incorrect syntax or expression to complex to evaluate" error before and found that it had something to do with the length of the string and query being worked out, I just split it into two lines e.g.: sqlquery = "select * from blah" sqlquery = sqlquery + "where blah =...

Hi All, I have the following append statement that is throwing back this error "Parameter [@SCHEDULE_ID] has no default value". It is a stored query and is used via a web page. I have tested the variable before it goes into the query and it has got a valid values. It is something to do with...

Re: Paste Command Failing [ANSWERED] Hi Vassago, I think I've solved this, it appears that that activating the document was not enough I had to do a select command as well. Regards Hayden

Hi, I have a Word Macro that does the following: 1. Opens Word document with macro in it "DOC1". 2. Creates a new document "DOC2". 3. Opens another document "DOC3" that is acting like a template of sorts. 4. DOC2 is selected and copies the entire document to the clipboard. Then pastes it into...

The users are not part of the same system. Separate networks, off-site from me, councils round Aussie.

Sure at certain periods through out the year I would like to send out database updates to multiple users that use this database. Without having to update them one by one. So basically I note down table and data changes which is a bit more manual, and I add these as sql commands to a txt. E.g...

Hi All, I would like to read/iterate through all queries in an access db and write them to a txt file. This will include the name of the query and the sql text. Any ideas?

Hi All, I am trying to update queries in one mdb to another with a bulk update. In order to do this I want to extract out into a txt file all queries with the name and SQL statements. I know SQL Server does this, is it possible in access or maybe I'll need to create a vb script, any help would...