473,222 Members | 1,836 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,222 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 1321
32,554 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,554 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,554 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,554 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,554 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,554 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,554 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

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

Similar topics

by: MARK TURNER | last post by:
Hi, Can anyone point me in the right direction to learn how to get real time updates in an Access form from an Excel spreadsheet? I'm trying to link the following formula which exists in an...
by: Jim Heavey | last post by:
Hello, I am using a generic AD Domain Account to create an excel spreadsheet, but I am getting an "Access Denied" error when I attempt to instatiate the excel object. The generic account does is...
by: miffe | last post by:
Greetings, I've got an access database on a server, and in a client PC I've got an excel spreadsheet... I run a query from the client PC involving some maths to develop different price lists from...
by: vancehome | last post by:
I have a series of macros running everynight creating tons of excel files (using transfer spreadsheet). I then have another program that zips them up and emails them all over the place. It then...
by: BFoxDDS | last post by:
i'm sure this is simple to do, but i can't find the answer in the search engines. i have an access db with 400,000 records. i produce queries of 5,000 records at a time exported into an excel...
by: farhaaad | last post by:
Hi everybody, I just wanted to know if i can make a form in excel (the same as access forms), so when i enter data in excel form it goes to a table in access ? I mean when i enter a value in a...
by: newnewbie | last post by:
Hi, How do I disable the warning Excel gives me when I am trying to open a document with the same name? I do not care is the changes are discarded, just need to switch the warning off and let the...
by: TrevoriousD | last post by:
hi I have created a data link from access query to excel. I use excel pull data from access in order to do stats. the excel workbook always stays in the same folder as the access db. I want to be...
by: roshaan | last post by:
i m very new to asp and working on a project using asp and access not asp.net………. I have a small application in which after login, user can upload .xls file, then the record from this excel file...
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.