MS Access "#Name?" in unbound field on SOME machines

Posted by alkorya on Stack Overflow See other posts from Stack Overflow or by alkorya
Published on 2013-06-27T22:18:32Z Indexed on 2013/06/27 22:21 UTC
Read the original article Hit count: 227

Filed under:

access-vba

|

field

|

ms-access-2010

I have a datasheet form bound to table. I added 2 unbound fields and set their Control Source properties to user defined VBA functions: 1. ConcatRelated (http://allenbrowne.com/func-concat.html) 2. Custom function that returns a string:

Public Function GetLowestSatatus(LookupField As String, JSAID As Integer) As String
    On Error Resume Next
    GetLowestSatatus = DLookup(LookupField, "JsaStatuses", "ID=" & DMin("StatusID", "Tasks", "JSAID =" & JSAID))
End Function

It works fine on my and some other machines but there are machines I got "#Name?" in these 2 unbound fields. All machines configured identically.

Any ideas? Thank you!

© Stack Overflow or respective owner

Related posts about access-vba

T-SQL Equivalents for Microsoft Access VBA Functions

as seen on Internet.com - Search for 'Internet.com'
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL. >>> More
Access VBA sub with form as parameter doesn't alter the form

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Microsoft Access 2003 file with various tables of data. Each table also has a duplicate of it, with the name '[original table name]_working'. Depending on the user's choices in the switchboard, the form the user choose to view must switch its recordsource table to the working table. I… >>> More
Achieve Rails-style migrations in MS Access VBA application

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a simple way to do Rails-style migrations in a VBA application. Just add additional migrations like migration(name, sql_string, database) to run_migratons and call run_migrations somewhere in the beginning of your execution. Function migrate(signature As String, sql As String, dbs As DAO… >>> More
Using INSERT INTO and setting one field value - Access VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using INSERT INTO to copy rows of data from one table to another: INSERT INTO tblNewCustomers (CustomerID, [Last Name], [First Name]) SELECT CustomerID, [Last Name], [First Name] FROM tblOldCustomers How can I set one of the field values in tblNewCustomers for all of the new records that… >>> More
MS-Access VBA: form_error vs on error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to set up error handling for a MS-Access application. The standard method to do this seems to be with an On Error statement in each subroutine/function. It seems simpler to me to use the Form_Error function to catch all the runtime errors in that form as opposed to an On Error statement… >>> More

Related posts about field

How can I convert XML files to one CSV file in C#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a collection of strings that are XML content. I want to iterate thru my collection and build a CSV file to stream to the user for download (sometimes it can be hundreds in the collection). This is my loop: foreach (string response in items.Responses) { string xmlResponse = response; … >>> More
CSS: move a "float:right" element to top (to align with the first element of the list)

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I've a sequence of elements and the last one has css "float:left". I would like to display it at the same height of the first element and not on the bottom of the list. (I cannot change the html code, so it is the last in the list). At the same time, I would like to keep it on the right. How… >>> More
MySQL field type for a comments field or text area

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title says, I'm after a good field type for a comments field I have in a table. It will store many characters (as users can continuously add to it) so it's definitely over 255. I looked at longtext but wasn't sure...Also how do I change the field type to accept different characters such as… >>> More
XML String into a DataGridView (C#)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am currently working with a webservice to pull a report about users in a remote support system. After pulling my report and receiving the result, I am given the following string back by the method: <report><header><field id="0">Source</field><field id="1">Session… >>> More
How to convert many-to-one XML data to DataSet?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an XML document that has a collection of objects. Each object has a key/value pair of label and value. I am trying to convert this into a DataSet, but when I do ds.ReadXml(xmlFile), then it creates two columns: label and value. What I would like is to have a column for each "label" and the… >>> More