Search results for query: *

This does not work, because each variable can only be 8000 long (hence the use of two concatenated together). The space is there at the beginning of @sql2. I wasn't sure myself if you can use an expression in 'execute', however it seems to work when run from QA.

This is a cut down version of my procedure, I have added ... to fill in any gaps that I don't think are too important. I have used GO at the end of the procedure, and the update is between 2 selects that do get executed. I think I worded the added column bit slightly wrong. My permanent...

Hi all, I am having a bit of trouble with a stored procedure that I have written. The procedure takes data from my database and stores it in a temporary table. It then performs two updates on this temporary table and does a select on the temp table. If I run the same code in query analyzer...

Hi, I am trying to write a query that will return total numbers from a quantity column with certain date parameters. I so far have the following query that returns the totals in september 2002 : select 'SWEDEN' as 'Market', sm.compgroup as 'manufacturer', hp.hpval as 'HP Description'...

I want to cycle through all files in a folder, opening each one (preferably individually) and then working on them. Is there any way of using a file system object method to do this, or an alternative method? Cheers Rich

COuld someone please tell me the syntax for including parenthesis within a string.

I have set up some VBA coding behind a button in access that opens a new word document and merges in data from a table in the database I am working with. Unfortunately, I also want it to add certain fields onto the document after it is created, ultimately giving you a new letter with the...

I wish to set a variable in VBA to equal an email address that is returned from an access query. Can anyone please help? Rich

Is there a way of sorting the order of the fields in the drop down box for a pivot table? Cheers Rich

Unfortunately I'm using outlook, but thanks anyway.

Is there a way that I can set up an e-mail that will pick out addresses from a table, (all or a selection)? Cheers Rich

If I do this, will I have to use the 'DoCmd.RunSQL' syntax, and if so, how do I pass the parameter into the string?

I wish to run a parameter query from a macro, so that the parameter is passed in from a variable within the macro. Could anyone please help? Cheers Rich

I have set an event on a field update (before update) on a continuous form, that calls a macro, which in turn calls a VBA function, which calls a sub procedure. The sub seems to work fine, but when I enter some invalid data, the error message appears as many tmes as there are records on the...

Oh well, thanks anyway.

Yes, I knew about that syntax, sorry should have mentioned that, but is there no way of doing it so that I don't have to keep repeating myString? Rich

I can't seem to find the syntax for the or operator so that I can compare a string to a list of strings, eg. myString Like "one" or "two" or "three" I feel like I'm being a bit dim!! Cheers Rich

I have created a sub form that is linked to a form via a button. When the button is pressed, the sub form displays all records from table2 that are linked to the record selected in the main form from table1. However, I wish to use this to input any new records, and when you try to input a new...

I have a query that is based on 2 tables, which have a on to many relationship. The first table is clients and the second is dispatches. I am compiling a label report to print off the addresses of any clients picked up by the query, but if the client has more than one dispatch record, their...

Does anyone know the syntax for running an Access macro from within an Excel macro (if it's possible). Cheers Rich