Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Filenames as fields.
Started 1 month, 2 weeks ago by akedm
Hi, I learned how to spell "access" earlier this week. That's how much I know about Access. I'm pretty fluent on Word and Excel inasmuch that I cannot program VBA, but I know where to look to get the information I need online and I can hunt and peck until I find the formulas I need to get things done. With Access, I'm a complete newbie. I want to basically make a spreadsheet at this ...
Site: Access World Forums  Access World Forums - site profile
Forum: Tables  Tables - forum profile
Total authors: 3 authors
Total thread posts: 7 posts
Thread activity: no new posts during last week
Domain info for: access-programmers.co.uk

Other posts in this thread:

georgedwilkinson replied 1 month, 2 weeks ago
Quote: Originally Posted by akedm I want to basically make a spreadsheet If you want a spreadsheet, I recommend Excel. You will just be hobbling Access if you come in to it with a spreadsheet mentality, and Excel is very excellent at working with spreadsheets. Quote: ...
Size: 5,600 bytes
Customize:  Customize "<b>Reply 1</b>: Filenames as fields. :: Tables :: Access World Forums"

Mike375 replied 1 month, 2 weeks ago
The fucntion found at that link will put the full path name into the field of a table. http://allenbrowne.com/ser-59.html Choose the List Files to a Table. So will you have entries in each record like c:\MyFolder\Filename.extension You have functions in Access (Excel would be similar) for Right, Left and Mid for extracting parts of a string. Also involved are InStr and InStrRev. ...
Size: 1,812 bytes
Customize:  Customize "<b>Reply 2</b>: Filenames as fields. :: Tables :: Access World Forums"

akedm replied 1 month, 2 weeks ago
Thanks for your responses. All things being equal, I'd much rather use Excel. But my problem I tried to describe about an easier interface in Access stemmed from an image I had of data entry into Access in a form format. Forgive me....here it goes... Field 1 : ____________________________________ Field 2 : ____________________________________ Field 3 : ___________ Field 4 : ...
Size: 1,289 bytes
Customize:  Customize "<b>Reply 3</b>: Filenames as fields. :: Tables :: Access World Forums"

georgedwilkinson replied 1 month, 2 weeks ago
Yes, Access forms can be set up that way. So can Excel forms.
Size: 62 bytes
Customize:  Customize "<b>Reply 4</b>: Filenames as fields. :: Tables :: Access World Forums"

Mike375 replied 1 month, 2 weeks ago
Your drawing is what a form does. Basically, a form will let you place the fields wherever your heart desires. A form can also display records in a tabular format, kind of table like. Forms are not just important for display but the form is where Macros or VBA are run from when clicking on something or because of conditions etc. Thus a Macro or VBA might run because the value of a field is >...
Size: 1,008 bytes
Customize:  Customize "<b>Reply 5</b>: Filenames as fields. :: Tables :: Access World Forums"

akedm replied 1 month, 2 weeks ago
Alright then, I'll use Excel to get done what I need done, and I'll repost a question about forms over on that thread. Thanks for helping out .
Size: 233 bytes
Customize:  Customize "<b>Reply 6</b>: Filenames as fields. :: Tables :: Access World Forums"

 

Top contributing authors

Name
Posts
akedm
3
user's latest post:
Filenames as fields.
Published (2009-11-08 23:28:00)
Alright then, I'll use Excel to get done what I need done, and I'll repost a question about forms over on that thread. Thanks for helping out .
Mike375
2
user's latest post:
Filenames as fields.
Published (2009-11-07 20:52:00)
Your drawing is what a form does. Basically, a form will let you place the fields wherever your heart desires. A form can also display records in a tabular format, kind of table like. Forms are not just important for display but the form is where Macros or VBA are run from when clicking on something or because of conditions etc. Thus a Macro or VBA might run because the value of a field is &gt;10 or whatever. As to Access and Excel, you...
georgedwilkinson
2
user's latest post:
Filenames as fields.
Published (2009-11-07 20:46:00)
Yes, Access forms can be set up that way. So can Excel forms.

Related threads on "Access World Forums":

Search Form with Combo Box as Search Fields/Result Fields  Access World Forums - site profile Forms - forum profile Search Form with Combo Box as Search Fields/Result Fields
Search Form with Combo Box as Search Fields/Result Fields
Show multiple fields as one, for searching purposes.  Access World Forums - site profile Queries - forum profile Show multiple fields as one, for searching purposes.
Show multiple fields as one, for searching purposes.
Option Buttons as Required Fields  Access World Forums - site profile Forms - forum profile Option Buttons as Required Fields
Option Buttons as Required Fields
Using a Report as a letter template - cant get the fields...  Access World Forums - site profile Reports - forum profile Using a Report as a letter template - cant get the fields to line up withthe text!
Using a Report as a letter template - cant get the fields to line up withthe text!
Use Word as template to edit Memo fields?!?!  Access World Forums - site profile Modules & VBA - forum profile Use Word as template to edit Memo fields?!?!
Use Word as template to edit Memo fields?!?!
Question regarding exporting form fields as xml  Access World Forums - site profile Forms - forum profile Question regarding exporting form fields as xml
Question regarding exporting form fields as xml
Write in PDF Fields and save as new pdf  Access World Forums - site profile Modules & VBA - forum profile Write in PDF Fields and save as new pdf
Write in PDF Fields and save as new pdf
Using derived query values as criteria fields  Access World Forums - site profile Queries - forum profile Using derived query values as criteria fields
Using derived query values as criteria fields
Blank fields not recognized as blank  Access World Forums - site profile Tables - forum profile Blank fields not recognized as blank
Blank fields not recognized as blank
Passing fields as array from Query, is it possible to...  Access World Forums - site profile Modules & VBA - forum profile Passing fields as array from Query, is it possible to print field names also?
Passing fields as array from Query, is it possible to print field names also?

Related threads on other sites:

Can Iview export the filenames as an excel or .txt file?  The DAM Forum - Index - site profile iView MediaPro - forum profile Can Iview export the filenames as an excel or .txt file?
Can Iview export the filenames as an excel or .txt file?
Image filenames as URLs  Actinic Community - Support for Actinic Users - site profile Actinic v7 Support - forum profile Image filenames as URLs
Image filenames as URLs
I want to batch upload to @ vimeo and use filenames as...  Twitter / veganstraightedge - site profile shaners - forum profile I want to batch upload to @ vimeo and use filenames as titles. @ tenderlove 's script almost works. But the videos won't transcode. Ideas? 10:13 PM Jul 16th from Tweetie
I want to batch upload to @ vimeo and use filenames as titles. @ tenderlove 's script almost works. But the videos won't transcode. Ideas? 10:13 PM Jul 16th from Tweetie
Plugin: NextGEN Gallery] Request: Show filenames as image...  WordPress Support - site profile Requests and Feedback - forum profile Plugin: NextGEN Gallery] Request: Show filenames as image description asoption
Plugin: NextGEN Gallery] Request: Show filenames as image description asoption
Flickr: Discussing Adding filenames as keywords in Bridge...  Flickr: Manchester, UK discussion topics - site profile Manchester, UK - forum profile Flickr: Discussing Adding filenames as keywords in Bridge - a little script that has made my life easier in Manchester, UK
Flickr: Discussing Adding filenames as keywords in Bridge - a little script that has made my life easier in Manchester, UK
Problem Displaying Cyrillic Filenames as Attachments  MozillaZine Forums - site profile Thunderbird Support - forum profile Problem Displaying Cyrillic Filenames as Attachments
Problem Displaying Cyrillic Filenames as Attachments
*SOLVED* OOo reading Japanese filenames as Arabic  OpenOffice.org Forum at OOoForum.org - site profile Setup and Troubleshooting - forum profile *SOLVED* OOo reading Japanese filenames as Arabic
*SOLVED* OOo reading Japanese filenames as Arabic
Reuse calculated AS fields in other fields  SQLServerCentral - site profile T-SQL - forum profile Reuse calculated AS fields in other fields
Reuse calculated AS fields in other fields
Just lost 5 hours because OSX does *not* treat filenames...  Twitter / quanza - site profile quanza - forum profile Just lost 5 hours because OSX does *not* treat filenames as case-sensitive when Debian does. At least I upgraded PHP 5.2.0 → 5.2.8 12:49 PM Mar 7th from web
Just lost 5 hours because OSX does *not* treat filenames as case-sensitive when Debian does. At least I upgraded PHP 5.2.0 → 5.2.8 12:49 PM Mar 7th from web
Host Root Directory has same filenames as Joomla! Root  Joomla! Forum - site profile Installation - forum profile Host Root Directory has same filenames as Joomla! Root
Host Root Directory has same filenames as Joomla! Root
Thread profile page for "Filenames as fields." on http://www.access-programmers.co.uk. This report page is a snippet summary view from a single thread "Filenames as fields.", located on the Message Board at http://www.access-programmers.co.uk. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity