Search results for query: *

I tried the code above on a different table which also requires a one letter change and am getting this error message: An error was triggered in the 'edit' method on an object of TCursor Type. This is what the code looks like: method run(var eventInfo Event) var tc tcursor endvar...

Thank you. I just realized that I need to make this change only one a select group of records. These records are in another table and the way to identify the records is by the letter D. This table and the table that has the records that I need to change from A to D are linked by a common number.

Thanks alot. Where do I put this snippet of code now? And how do I run it?

Yes, that's what I would like to do. I don't know anthing about the use of tcursor, can you tell me more about it and can you provide the syntax? Thanks

I'm trying to change the data in a memo field. I get this error though: Operation is not supported on BLOB fields. I have this statement in the query: A, changeto D Any idea how I can change the data?

I'm trying to send email through Integration Services (based on when a package has been executed successfully) however I get this error message: SSIS package "CopyEmailTable.dtsx" starting. Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message...

I have a table in MS Access that I would like to copy/import into SQL Server 2005. I would like to automate this process so that it copies the table over on a daily basis. Can someone tell me how this can be done? Thank you in advance.

Also, would docmd.sendobject work here, because I really don't want to send an object, just use an email address to create an email.

I have a form that has a button. Once the form is clicked it inititates a query. User is prompted to enter a parameter value (client number), the record is then displayed to the user. However, I would like to instead of displaying the record, create an email message with the email address of...

I would like to create an email message from Access based on a query. Query provides the email address. I would like the email address to be added to the 'to' line in the Outlook email message. Any help is appreciated!

How? could you show by example? Thanks!

Is it possible to perform a changeto query and use a field name? For example, changeto (100 x [FieldName])? If not, what else should I be using?

Thank you very much for your time and assistance. In the end the issue was that I did not have the proper working directory set. Dare to solve my other issue? I would like to know if its possible to link from SQL Server 2005 to Paradox 8, so that when I update records in SQL that this also...

Here is the query: Table1 and Table2 exist in the same folder as this query. I'm assuming result.db has to exist as well, or does pdox use this to rename the answer.db? Query ANSWER: :PRIV:result.DB Table1.DB | Disb Type | Status | Recnum | Date Updated | | FA | Check P |...

Thanks for the info. After checking again it is true that the table is no longer valid. How do I make the change now without creating a new query?

When trying to run a query in Paradox, I get the message Table not found. The query is based on a table that is still valid and in the same location.

Is it possible to link SQL Server 2005 to Paradox, if yes, what are the steps? I want SQL data to sync with/to Paradox 8.0. Thanks.