Search:

I have a table in SQL Server, which has two columns one of which contains

numbers as characters (eg. 214.67)
the letter U
NULL
I need to populate the second column with

conversion of...

Many thanks for the code.
I'll try it out later today (Melbourne Australia time)
Regards

I need to be able to step through all worksheets in a workbook and copy each worksheet's named range content to a consolidation worksheet named Master, for eaxample.

Worksheet1 has range name...

I have implemented all of your suggestions and it all works now.
I have given the database back to the business unit for useability testing and verifying results of the coding changes, with initial...

Thanks for your advice.

I have used your suggestion and been able to insert most of the values into the table, but am being presented with errors on others.


I can do this in the immediate...

As simple as that?

dbs.execute "Insert into tblMonthlyJournals ([Organisation]) values (Me.txtOrg)"

Will use your suggestion at work tomorrow.

Thanks!

Yes, there is code in the report and I have stepped through to the point where it generates the rtf attachment for Lotus Notes. It is at this point that I can see the subset of data which I need to...

Thanks for the suggestion, I'll try from within the report. The way the process works is the user steps through a query one record at a time, stopping at each record and clicking the report button. ...

I have been given an Access 2003 database which produces a report and then attaches that page to an email, based on complex criteria.

I have found the area in the code where it creates the rtf...

Thanks to both responses, which are equally valid.

As I am not the one that will actually send the email, it will be the Treasurer of the Club, I'll opt for the creation by looping through the...

I use MS Access 2003, SP2

I have a membership database, and once a year I am required to send out reminder notices to members to review and update their contact details.

In the past I have done...

Thanks John for pointing me in the right direction.
My issue was across a range of databases, which had recently been relocated from one network resource to another, wouldn't have thought that would...

Hi,

I have just lost the ability to summon the right-click menu within any object in Access 2003.

Have used the repair option with no success and would prefer not to uninstall and re-install if...