NeoPa and TheSmileyOne -
Thanks for your help with this! I was able to get the thing to work by using a combo box instead of a list box, and fixing the data stored in the source table [Locations]. Also, I appreciate the advice about naming the queries, tables, etc with a prefix of tbl, qry, or whatever to help distinguish them. My Access knowledge is advancing ever so slowly....
Kristin
gravesk
Last Activity: Apr 26 '10, 12:14 PM
Joined: Mar 11 '10
Location:
-
I think I understand what you're saying, but what steps do I need to take to fix this? I want to see "NOT CHOSEN" for any record without a selection, and then see the selection when it's been made.
You mention "sizing a ListBox as you would a TextBox" - but I assume that "sizing" isn't referring to the size of the box?
thanksLeave a comment:
-
Copy of database
OK, here is a small copy of my database. My users have already been adding data to the real thing, so I'd appreciate being guided as to what repairs to make.
Thanks in advance for your help.
Kristin...Leave a comment:
-
This is the SQL statement of the query on which my form is based:
SELECT [Gibbons Oct 2010 Master - Account Level].account, Left([Gibbons Oct 2010 Master - Account Level]!Account,14) AS Acct_txt, [Gibbons Oct 2010 Master - Account Level]!Account*10+[chk_digit] AS Account15, [Gibbons Oct 2010 Master - Account Level].Division, [Gibbons Oct 2010 Master - Account Level].CUST_NAME AS Name, [Gibbons Oct 2010 Master - Account Level].SADD...Leave a comment:
-
control source = location (one of the fields in the query that is my source
for the form)
row/source type = table/query
row/source = locations (name of lookup table)Leave a comment:
-
Why Is my Lookup Value Being Copied to Other Records in My Form?
am using Access 2003, and am not very familiar with Access or its terminology. I am not at all familiar with VB.
I created a form from a query, and everything is generally working fine.
One of the fields on the form is based on a lookup table for location. I have assigned a default value of 1 (which translates to NOT CHOSEN), and that's how everything shows up when I go into the form. I assigned the default both in the originating... -
Hi -
The two text boxes are NOT both linked to the same control source. That is the part of the properties that is not identical. I should have been clearer about that.
As for creating a spot for the text box to save to, I'm not sure what you mean. I want the text box to save to the control source field (I may be using incorrect terminology here).
thanks,
KristinLeave a comment:
-
No, this is not a new field. And yes, the field is listed in the control source.
thanks,
KristinLeave a comment:
-
Updating a Text Box in a Form
Hi -
I am using Access 2003, and am not that familiar with Access. I am not at all familiar with VB.
I created a form from a query. Most of my text boxes on the form can be updated (i.e., I type in a value and if I close the form and then come back to it, the value is still there). For example, the text box called case # updates correctly. When I close the form, it prompts me to save my changes.
One field... -
Hi all - I tried the CLng function as suggested by NeoPa, but it did not work.
I then looked into the three-step process suggested by TheSmileyOne. As I mentioned earlier, I am pretty inexperienced with Access. One thing that I had not mentioned previously is that my tables are imported from Excel worksheets. Moreover, the worksheets are refreshable (that is, with the click of a button, they update with the latest set of data from...Leave a comment:
-
Yes, I did run the two queries separately without problems. Everything appears to be fine when I do it separately.
I will try the CLng function as suggested. If CLng doesn't do it, then I'll try the new field and the update query (I don't even know what that is, but I'll look it up), and then the revised original query joining on the new field (all as suggested by thesmileyone.
I'll get back with results, but it won't...Leave a comment:
-
OK, here is a little more about my set-up and the format of my fields.
I start with two tables, read each of those tables into a query, and then the problem comes when I try to join the two queries into a third query.
Here is the information about the field formats for my two join fields:
[Old Mtr #] field
The starting point for the [Old Mtr #] field is table A. In table A, the field is called E_MTR_NO,...Leave a comment:
-
Datatype mismatch in criteria expression - query
Hello -
I am a novice in MS Access and do not know SQL. I am using Access 2003.
I have set up two queries that seem to be working fine. Each comes directly from a table. I have joined the two queries in a "include all records from A and only those records from B where the joined fields are equal" join.
The fields that I am using for the join are both fixed decimal, zero decimal place fields in their...
No activity results to display
Leave a comment: