Replica does not recognize formated text boxes

[tbac]

I have a replicated database with several formatted text boxes that work well on the design master but not on the replica. Example 1: On Reports where I inserted a Date text box in the footer. When you open the report on the replica, you get a message, 'Enter Parameter Value' for Date. Example 2: On a form I have a text box with Control Source: ="R" &Right(Year(Now())-0,2). On the design master it shows '09' but in the replica it shows 'NAME?'. Has anyone else had this problem?

 

[MajP]

Often when string functions do not work
right, left, len, instr etc it has to do with a bad visual basic reference.
Try some basic string functions in the immediate window of the replica and tell us what happens.
However, what is this ""R" &Right(Year(Now())-0,2)? I do not get it.
How about

format(now(),"\RYY")
if you want R09

 

[tbac]

I think you are right that I have a reference problem but it seems like it would be a common problem and there would be a way around it, and I wasn't sure if it was the reference to VBA or the reference to DAO: The Design master is on my laptop and the replica is on a shared drive on our server, G:\Database... Everything works fine with VBA code for On Event routines, but the Text Box controls like Dates inserted into reports and others, do not work on the replica.

 

[MajP]

I have seen this where the VBA reference is older on the system than the the machine it was created on. It requires the user to open the db. Remove the reference to VBA and then recheck it. One solution is to use late binding on all your vba string functions (which is a pain).

See if the replica on the user machine can run any string functions. See if you reset the reference to VBA.

 

[MajP]

http://bytes.com/topic/access/answers/194577-certain-functions-have-stopped-working

 

[tbac]

The references are there on the replica and the files they reference are the same version. What I am wondering is if there is something about the replica being on a network server while the design master is on my laptop. They synchronize fine but I wonder if there is a way that I can get the date function to work on the replica

 

[MajP]

and?
format(now(),"\RYY")

 

[MajP]

Did you remove and then re apply the reference to vba?
Did you verify it is a string problem issue throughout the db not just the query (that was a guess)?
If it is vba issue then explicitly call vba out i.e VBA.Right(.._

 

[tbac]

The replica will not let me remove the reference to VBA and the format(now(),"\RYY") function acts just like the original string I had in the text box, that is it works on the design master but not on the replica. I wasn't sure what you mean by explicitly call vba, would I put VBA.Right(... into a text box?