Search results

Re: Change a field name by vba Sorry Bob I’m not being precious here it is complicated and I’m pressed as always for time. I’m trying to overcome a problem caused by unavoidable double entry of data. Records from an external application are imported into my Access dbase. There are two...

Sorry Bob, it's complex but the reasons are valid and being able to do it would help me automate a difficult job. This change would only take place in a temporary table and would not affect the core tables so data integrity is not going to be an issue.

Thanks Bob I only changed the Module name as I was still getting errors and forgot to change it back. That works fine now from the debug window but how would I call this from a command button or onLoad event?

Thanks for sticking with this. I've attached a small db I made to illustrate my problems. Im sure it's pilot error here but I think I've followed your instructions.

I appreciate your help guys. As a module it's the same. So I created a new table tblColors with fields color and hue and using Bob's code tested it in the debug window with Call RenameField("tblColors", "hue", "color") I hope this is correct, and now get Sub or Function not defined. I'm...

Thanks JANR I reset all the code to Bob's to get rid of my names but I now get a compile error "Can't assign to read-only property" on For Each fld In td.Fields If fld.Name = pfldName Then fld.Name = pnewfldname

Hi Bob I'm getting a debug error 'varaible not defined' on tblSugg in Red Public Sub RenameField(ptblName As String, _ pfldName As String, _ pnewfldname As String) '************************************************** 'Purpose: Rename a field programatically 'Coded by: raskew...

Thanks Bob I'll take a look at these.

Ooops! Should say "FIELD" name! I've been through dozens of posts on this and can't get my head around the solution. Is there a simple way to change the name of a table field?

Would that be actual success or perceived success?:confused:

Well it's obvious, he connects his machine to the cables connecting the body to its consciousness. Duh! :rolleyes:

We're on 97 and 2003 here and the recipient's kit is an unknown quantity at the moment! The snapshot option works fine and is simple so I think I'll stick with that subject to the recipient being able to install the viewer and to ms PITA security dialog hassles. Thanks for all your...

Thanks John.

Thanks for the pointer Boyd. I looked up snapshots here and using the code below it works a treat. Cheers. Private Sub cmdEmail_Click() DoCmd.SendObject acReport, "rptDS", "Snapshot Format", "Your email recipient", , , "EMAIL SUBJECT", , False End Sub

Hi Boyd The attachment is rtf. I'm not familiar with snapshots and the recipient of this email is computer illiterate so I need to make it as easy as possible to send him the information. Barry

I have a report which has a different picture for each record. Using 4 different types of command button syntax that I found here I've been able to send the report successfully as an email attachment but the images are blank. I presume this is because the jpgs are stored in a file folder and...

Shaneman I have had years now to come to terms with the sudden loss of my son Simon and I count the 17 years I had him in my life as a treasure. I know you and your wife and family will feel the same way about Kate. Your grief is new and raw, despite knowing what was to happen I don't believe...

I remember Dave Dee when the band was Dave Dee and the Bostons. They were all a really pleasant bunch of blokes and very underrated as musicians. They used to do an acapella version of Eleanor Rigby that was blisteringly good. My band was playing the same circuit as them and would regularly...

It's the 4 string L2000 I can't get on with five strings - tried it and hated it. It's in the blueburst finish and is my wife's (bless that woman) Xmas pressie to me. I must have been a good boy this year!:rolleyes: I roadtested one through my Markbass Jeff Berlin combo and it's the best...

I thought he deserved an honourable retirement Cindy and the new avatar says it all about my users! Life's too short Col. Thanks Ron. Definitely not a VIP! Better buy yourself some snowshoes from the look of that photo. ps expecting the new G&L bass any time soon. Can't wait.