471,853 Members | 1,792 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

excel to access filename

how do you take the filename that you imported from excel to access and make a textbox to display the file name?
I have a textbox for it right now i just dont know how to get it show up.
Jun 12 '15 #1
13 1235
32,462 Expert Mod 16PB
What are you asking actually here? It's so unclear a question that I don't know how to help you. Consider making what you want clearer. Remember that we only know what you tell us, and you've told us very little about the situation your question comes from.
Jun 13 '15 #2
okay. i have a field called spr filename in access. when i am going to import the file from excel to access, i want to make the name of the excel file show up on my form in access.
Jun 15 '15 #3
32,462 Expert Mod 16PB
You have a field in some tables in some database called [spr filename]. You want this to be shown on some form when you're executing some process that includes an import.

Now, you'll have to excuse me being a little vague here as there is almost no information to work with, but may I suggest a bound form. The form can be bound to whichever table has the field in it and a TextBox control can be bound to the field itself. The form would allow you (The operator) to navigate through the records in the table and might also have a CommandButton control on that allows you to select which record to use to run the import.

Does this sound like what you're asking about?
Jun 15 '15 #4
im sorry, i am having a hard time explaining what i am looking for. but yes, i have a field called spr filename and when i import the file to the database from excel, i want the name of that import to show up in the field called spr filename. so i may have 1000 records with the same filename and that would be okay.
Jun 15 '15 #5
32,462 Expert Mod 16PB
So, does my suggestion sound like it's workable to you? If so, do you need help implementing that?
Jun 15 '15 #6
Yes I do need help implementing. I think that is what I am asking for
Jun 15 '15 #7
32,462 Expert Mod 16PB
Ok. That will involve you too, of course.

I need to know what you have managed to do already. I'm not allowed simply to do it for you.

When explaining what help you need try to be clear and include all relevant details. It's easier for you to understand what I suggest if I'm using the names of items that you already know rather than vague references to "a form" or "a report" etc.

Start by asking (and answering) the question :
Do all my records need to appear on the form or only one instance of each file name?
Jun 15 '15 #8
OK I have a form named main class form. And the field is called txtsprfilename. For every record that I have I want it to appear on the form. I have buttons that say next record or prev record, etc. I want every time I click on that button for it to show the filename of the excel spreadsheet in that sprfilename field
Jun 15 '15 #9
32,462 Expert Mod 16PB
That's the basic functionality of a bound form. Did you create it using the wizard?

If it isn't working for you, what is happening? I need information from you if i am to have any chance of helping.
Jun 16 '15 #10
No I didn't create it using the wizard. It has no functionality as of right now. It is just on the form right now. I pulled it in when I created the table from the excel sample file.
Jun 16 '15 #11
32,462 Expert Mod 16PB
The form will need to be bound to the table. Open the properties of the form and make sure the Record Source is set with the name of your table.

The control will need to be bound to the field. Open the properties of the control and make sure the Control Source is set with the name of your field.

Report back when this has been done and let us know what you are seeing. Is it working as expected or is something not? If not then explain what that is clearly.
Jun 16 '15 #12
i do have a question. can you change the record source for only one field, or does it change it for all of them?
Jun 16 '15 #13
32,462 Expert Mod 16PB
The latter. It changes it for all controls (Fields).

As for terminology, it may help to recognise that a Field is a holder for specific data in a table or query. A control is something that shows data on a form, that may refer to a field in a table or query. Controls can also be unbound. It's helpful to recognise the difference between the two when discussing such issues.

Controls can only be bound to Fields that are exposed by the RecordSource of the form. They can also show calculated values, but even they are generally from Fields from the RecordSource.
Jun 17 '15 #14

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by MARK TURNER | last post: by
1 post views Thread by Jim Heavey | last post: by
4 posts views Thread by BFoxDDS | last post: by
7 posts views Thread by farhaaad | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.