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.
13 1324 NeoPa 32,556
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.
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.
NeoPa 32,556
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?
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.
NeoPa 32,556
Expert Mod 16PB
So, does my suggestion sound like it's workable to you? If so, do you need help implementing that?
Yes I do need help implementing. I think that is what I am asking for
NeoPa 32,556
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?
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
NeoPa 32,556
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.
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.
NeoPa 32,556
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.
i do have a question. can you change the record source for only one field, or does it change it for all of them?
NeoPa 32,556
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.
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |