Search results for query: *

I've always gotten that too, but ignore it because the users are only interested in changing the data which is on the SQL Server. That error only tells you they can't modify the forms or reports. a.

Help-help! Me too! It's an ADP database, with the data on SQL server. The ADP is on the network and three users hit it. Two work just fine, but the third lists the stored procedures as "storedproc; 1"

I know this post is a little old, but I'm experiencing the exact same thing... did you ever get a resolution? a.

the syntax for combining fields into a new field is: NewField: Field1 & Field2 for example, if you've got firstname and lastname as two fields and want to combine them into one field: FullName = FirstName & " " & LastName -or- FullName = LastName & ", " & FirstName a.

insert the result into a label: "label.caption = result" and it should work. a.

i have an idea... check the can shrink/grow properties for the section of the report (group header/footer or details, wherever these fields are printing... a.

i've often found http://www.mvps.org/access/ to be quite useful... a.

i've got a report that has a text box linking to a memo field that has over 2,000 characters in it, and it displays fine... i've got "can grow" set to yes and "can shrink" set to no. can't think of any other settings that would affect it... a.

memo lets you enter up to 32k of characters. i've never had much luck with memo type data fields - especially if it's a multi-user db. it tends to corrupt *very* easily... anyhoo - if the length of the text in that field is mostly below 255 characters, you can change the data type to text...

I've got a table with a structure of: BuildingID PersonId Value1 Value2 Value3 123 001 564 1 952 123 002 122 36 512 What I need to do is transpose the values thusly: BuildingId PersonId ValueId ValueValue 123 001 1 564 123 001...

heck, why does microsoft do *anything* the way they do? so - the data type of the field you're linked to is "memo"... does any data in this field get cut short on the report? if so, how many characters display before the cutoff? is it consistent? do you need the field to be memo? a.

check the properties of the text box; specifically "Can Shrink" and "Can Grow"... make sure they're set to "Yes" and see if that doesn't help. a.