Search results

Thanks - too much trouble - I will without. Russ

Stopher - the Tabular stays faded, the Stacked is highlight when I select all the items = Big problem, if I select the Stacked button, Access takes my seven columns of fields, and combines them, overlaying the first column fields with others and 7 columns become one column of yuck, overlaid...

The Stacked and Tabular buttons are faded also.

I am having the same trouble, of the faded out button. Any help, would be appreciated. Thanks Russ :confused:

I added a picture, showing how to rename a field with a caption with a query. I forgot, it has been 3 years. And I was trying within the query screen to do it with newname:oldname. That method was failing and failing. So, I did a search and found this gem, a refresher. Russ

I like to add the current date to the email text. And better yet to the filename being created. Can anyone advised. Attached is what I have now. Russ

Mihail - thanks I have used your technique too. Russ

The fix I found is this, where old name is the string. newname: StrConv(string, conversion [, LCID ] ) Russ

Re: Rename a field in a query - how when a caption ?? Does anyone know how to do the rename of a field with caption without using the caption name or the name of the field. I have a user that wants a different name on the output other than the table field name and different than the caption...

Thanks a million - I had a field in a query I was trying to rename the normal way. NewName: OldName But it was failing. I knew the field had a caption. I tried this: NewName: Caption This failed. I tried other techniques failing. 1.5 hrs later.... Then I found this! and it worked. Russ

Thanks for sharing your experiences. Russ

Solved! AnyTestingNDTor5500: IIf(([Plan Testing]="Yes" Or [5500 Forms]="Yes"),"Yes","No")

I am trying to a new field based on two other fields: The new field is "AnyTestingNDTor5500", the field's value is "Yes" if either the two individual plan testing parameters are set to "Yes". Below is what I am trying and getting a syntax error. CODE AnyTestingNDTor5500:iif(([Plan Testing]...

Re: AutoNumber 2007-2010 - duplicate key We have had multiple times when we are getting a duplicate key message and no users can enter new rows. Looking at the table there is not a duplicate record. The only table connected has a field as a primary key, autonumber field type, and index...

Solved CompanyID4: IIf(Len([CompanyID4L])=3,[CompanyID4L] & "-",[CompanyID4L])

I have a field that I need to replace the 4 character in with a dash when the position is null. Sample of input values: ABC GATE HAV ROAD Output values wanted: ABC- GATE HAV- ROAD I have tried this and variations without success: Outputfield: Replace([Inputfield],"","-") Any suggestions...

WORKing - Yeppie - Thanks a million.. Russ

still trying The query behind the report is still failing to get the parameter. I tried: Me.Associatelisting and [Forms]![FrmSwitchBoard4SelectingPlanDoc]![Associatelisting] However, with either I get the pop-up message Enter Parameter Value and the variable. See attachments. Thx. Here...

getting a - syntax err Attached is a screen shot of the error.

Getting closer - but no success yet Thanks for the help, I think I need a little push more, I will post a Yippie when i get it to work. One Problems at this time 11-23-11-730amEST - 1) Syntax error in query when adding the parameter: [Forms]![associateform]![Associatelisting] Russ