User Profile
Lewist57
Copper Contributor
Joined Jun 22, 2021
User Widgets
Recent Discussions
Re: Use of a combo box to select multiple values from a table
Now that I think about it, no need to store data twice. Recall that I do not use Access frequently, and when I do, I am dependent upon the various built in wizards. So let me alter the request. Suppose I have a table with 3 short text fields. On a form, I have a combo box that selects a record from Field 1 of the table. Once I select a record via a combo box from Field 1, how can I show the corresponding Field 2 and Field 3 text on the form (I would guess somehow these values can be tied to two labels on the form)?1.6KViews0likes0CommentsUse of a combo box to select multiple values from a table
Very infrequent user of Access, so bear with me. I have two tables and one form. On the form, I have a combo box to select a field from Table 1, and save the selected value in the same field in Table 2. Easy to set up, no problem. What I would like to do is to be able to use a combo box to select a value from Field 1 of Table 1, but also automatically bring over the values from Field 2 and Field 3 of Table 1 and store them in Field 2 and Field 3 of Table 2, based upon the selection of Field 1 of Table 1 by the combo box. Suggestions? Thanks!1.7KViews0likes2CommentsRe: Importing text into a single field of existing database
SOLUTION 1) the first line of text in the text file should be the same as the field title that you want to insert the data into. For example, if you are appending new records by inserting lines of text into the TITLE field, then the first line in the text file should be TITLE. 2) Start the text insert wizard. 3) Chose "delimited" for the input type. 4) Click on the check box that says the first line in the file contains the name of the field you want the text to be inserted into. 5) The deliminator type was automatically chosen to be a comma; this made no difference for me as the text records being imported are filenames, which do not contain commas. 6) Hit finish, and new records with the text in the appropriate field are added to the table.743Views1like0CommentsImporting text into a single field of existing database
I hate asking this, as I have figured it out before, but cannot remember how I did it. I have a simple Access database table with six fields. The second field is a text field. I have a text file (*.txt) with multiple lines of text (say 25 titles in 25 lines in the text file). I want to append the 25 titles into the second field of the table. I am pretty sure I was able to do this with the text import wizard and the Advanced button, but the exact set-up escapes me now. Any references as to importing lines of text from a text file into a text field of a multiple field table would be appreciated.787Views1like2Comments
Recent Blog Articles
No content to show