Functions no longer working

[robcra]

Not exactly sure if we has anything to do with sql server so sorry if it isnt strictly relevant.
I have a database on sql server and am using an access data project as the front end. Have finsihed this and is working fine till I try and use it on another computer on the network. It still connects to the database fine (well on most machines on the network not sure why not on the others) but the problem is access functions in my reports and forms seem to have stopped working and show up as ?#name
Examples of the kind of functions I am talking about are

=Format$([DateFrom],"Long Date")

=[SumOfMinutes]\60 & Format([SumOfMinutes] Mod 60,"\:00")

any suggestions?

 

[cmmrfrds]

Are you logging onto these other PC's with your login or using somebody elses login? Are you using NT or SQL Server authentication or both? Who is the database owner (ie. login name).

 

[HappyCoda]

Hi. My understanding is that it shouldn't work on any machines. Why? Because we cannot use VB functions within SQL statements when working with a Transact SQL back end instead of the Jet engine. (Access Project instead of an MDB)

Format$, for example, is VB function. In controls it should be fine, but in SQL, you'l get errors.

Try using the CONVERT function (a Transact SQL function) in your SQL. More help found by searching "sql convert" on MSDN.com.

Cheers,
HappyCoda

 

[robcra]

I am actually converting a database from access to sql server and sucessfully converted any vb code to sql which needed it. It is in my forms and reports in my access project front end I was using VBcode. I have since solved the problem. On the machines it was not working on one of the libraries being referenced was missing I simple cleared the box so it was no longer referenced and it worked fine.
I am using integrated NT security and anyone who is an administrator on the domain has access. It works fine from all pc's except one.
When the project opens on this machine the file: connection menu isn't greyed out but when you clcik on it nothing appears, but as it is only one machine it isn't of much concern.

 

[HappyCoda]

Aha! Glad you solved it!