Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access Text SQL Value
Name: Chad Johnson (by ChadJohnson) Date: February 18, 2004 at 15:40:20 Pacific OS: WinXP CPU/Ram: N/A
Comment:
I am working with something that someone else created, and they have the control source of a text field (Name) set to
SELECT FullName FROM informix_id_rec WHERE informix_id_rec.id = kine_staff_rec.Staff_ID;
informix_id_rec is a table in a live database, and kine_staff_rec is a table within my Access database. These fields do exist in both tables.
When I run the access program, the Name field's value gets set to #Name?
Name: chnos Date: February 19, 2004 at 00:54:25 Pacific
Reply:
U mean u use sql language in access?
0
Response Number 2
Name: altaylor Date: February 19, 2004 at 05:35:17 Pacific
Reply:
Are you sure that your Access database is linked to the external table? The table name should appear in your list of tables with a diamond-shaped bullet mark at the left.
0
Response Number 3
Name: Chad Johnson (by ChadJohnson) Date: February 19, 2004 at 21:42:01 Pacific
Reply:
Why not use SQL in Access?
Yes, I am sure that the informix_id_rec is linked to an external database. There is a diamond-shaped icon next to it.
What could be a possible problem?
0
Response Number 4
Name: altaylor Date: February 20, 2004 at 03:03:05 Pacific
Reply:
Have you tried the suggestions in the Access help file? Look up #NAME? in the index and select 'Troubleshoot forms' from the items. Difficult to suggest anything else without the files' structures.
0
Response Number 5
Name: Jennifer SUMN Date: February 21, 2004 at 15:27:56 Pacific
Reply:
Is your Access table "Name" field set to the same field type as the SQL field?
0
Response Number 6
Name: Chad Johnson (by ChadJohnson) Date: February 24, 2004 at 09:26:30 Pacific
Reply:
I fixed it with some help. I have a form, then I have a subform (in which the name field is located). I simply linked these two values and it works great. Thanks for the input!
For curiosity sake, I will look at an old version and see if the types are the same.
Summary: I'm trying to do a minus / except query in MS Access 97 using SQL commands. Here's the SQL code: (SELECT DISTINCT * FROM table1) MINUS (SELECT DISTINCT table1.* FROM table1, table2 WHERE table1.col1 =...
Summary: i need to give letters a value for a shift rota, eg i need "N" to equal 11 and "LD" to equal 12. Each cell will have N or LD for different shifts, then i need to add up all in a row to give a total of...
Summary: Hi - have what should be a simple question for someone to answer. I'm creating an access database and will have 2 fields. The first will allow the user to enter a date. The second will show this da...
0 
