File Extended Properties

Mar 29, 2007

I have a list of files which contain the full path of the file (dir & filename), how can I get the extended properties for these files?

I try to use the script

Dim arrHeaders(35)
dim sFolder as string

sfolder = "C:Scripts"

Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.Namespace(sfolder ) 'objFolder = nothing even after the object is set.

It does work; however, if I were to hard-code the path in the NameSpace("c:Scripts")

For i = 0 to 34
arrHeaders(i) = objFolder.GetDetailsOf(objFolder.Items, i)Next

For Each strFileName in objFolder.Items
For i = 0 to 34
msgbox objFolder.GetDetailsOf(strFileName, i)
Next
Next

Any thoughts on this?

Thanks.

View Replies


ADVERTISEMENT

Get File Info FROM Properties

Dec 4, 2005

Can anyone tell me a sample code on how to write/develope the Advance file properties like....

File version
Description
Internal Name
Product name

I have seen different types of files properties some has additional features while some has none - its just click once on any file and then click the right hand side mouse button and select the properties that will display all the information about the files click on second tab version (if there) will tell you the additional info about the file.

View 3 Replies View Related

Excel File Properties From MS Access

Jul 10, 2006

Hi Guys,
Does anyone know how i can get an excel file properties from Access. Thanks.

View 1 Replies View Related

Excel File Properties From MS Access

Jul 10, 2006

Hi Guys,
Does anyone know how i can get an excel file properties from Access. Thanks.

View 1 Replies View Related

Dump Table Properties To A File

Feb 8, 2008

Is there a way to write the properties of a table out to a text file or excel sheet?

I'd like to be able to get the Field Name, Data Type, Field Size, and format for each field in my table.

Thanks,
CRhodus

View 3 Replies View Related

Table Column Name Properties/Combo Box Head Properties

Dec 8, 2006

Hi, I would like to change the properties of either the column heads in a combo-box or the column names for tables. I don't think there's any way to adjust the column head properties, and I'm doubtful there's a way to change the column caption properties.

Some of my column titles are long, and I'd like to be able to word wrap them essentially. Anyone know if this is possible? Thanks.

View 5 Replies View Related

Extended Forms

Mar 16, 2006

I am creating a form based directly on some paperwork which needs to be logged electronically, Unfortunately this extends well over the 55" that Access allows for a form.
Not a problem I thought, just create a second form and place a continuation button on the first...Obviously not.
When I place information on the second form, it throws a new record in the table meaning that the table ends up twice the required size and half the records have one side of the data and the rest is on the other side.
What do I need to do to sync these together properly?

Regards

Jason

View 3 Replies View Related

Extended Price Subform

Feb 5, 2005

I am stuck for a calculation expression for 'extended price' which can be seen in the attached screenshot.

I want to times item price by quantity and deduct the discount.

Thanks. :)

View 4 Replies View Related

Listbox Extended Multiselect & Opening Form

Dec 12, 2006

Hi, i was wondering if it's possible in a listbox with the multiselect option set to extended simply click on a field and open a form with the data of this field..

example:
i've a listbox of my customers, (only first and last name)..i click on one of this and a new form with all the details'll open, so i can see and modify stuff...
with the multiselect set to none this works..but with the extended??

(btw..i wanna just click on one filed, but i need the extended multiselection on for other options..)

thx in advance

View 14 Replies View Related

Queries :: Default Value 0 In Query Extended Price Field

Mar 4, 2015

How to set a Default value "0" in Query Extended Price Calculated field ?

I have attached the screenshot with explanation, how to changes the formula.

I have used below following functions but there is no workout.

Extended Price: CCur([Qty]*[BPrice])
Extended Price: CCur(Nz([Qty]*[BPrice],0))
Extended Price: Nz([Qty]*[BPrice],0)
Extended Price: ([Qty]*[BPrice])
Extended Price: IIf(IsError(([Qty]*[BPrice])),0,([Qty]*[BPrice]))

View 4 Replies View Related

How To Populate List Box With Another List Box Using Extended Multiselect

Nov 23, 2012

How to populate a list box using another list box on the same form. I have this working completely fine if the the source list box has the multi select property configured to be off, however I need it to be set to extended multi select.

View 1 Replies View Related

Sub Form Properties

Sep 13, 2006

Hi,

I have created a sub form and wanted to make it's background transparent and also be able to enter new data and change it on the form. I sat Data entry = Yes, but I still can't enter any data. And I can't find the Back Style property at all.

Any help how to do that will be very much appreciated.
B

View 1 Replies View Related

Check The Properties

Mar 27, 2006

I was doing my assignment with the table in access, and my sister came up to me and ask me “why it is important to check the properties of each field in a table before developing a form based on that table.” Can anyone help me and answer this, because I don’t know how to answer her question.:confused: :confused::confused:

View 1 Replies View Related

Subform Properties

Feb 9, 2005

Am sure this is an easy question but I'm missing something:

How in the heck are you supposed to get to the subform properties box. The only way I know is to click on the very thin border area surrounding the form and then try and right click your way to properties. There has to be an easier way. Usually I have to fight my way to the properties box as the area loses focus by the time I right click and I have to reselect and try and right click again...ARGH!

View 3 Replies View Related

Control Properties

Mar 14, 2005

hi all,

i m referencing a control like me!<controlname> in my code.

but in 1 screen its not giving me option after me!<ctrlname>.(only value property).


but in other screen i m able to access the properties.

So what could be the reason for this.I particularly want to access the enabled property to set it dynamically.

Thanks

View 4 Replies View Related

Date Properties

May 2, 2006

How could I implement a feature which determines if something is at least 7 days before a booking at a theatre, but no more than 2 months. For example, something like... If =Now() - 7 Then... Elseif =Now() Then...
I don't really know how to go about it.
Hirer Date is when the booking is to be held (e.g., 12/01/2006) and Booking ID is when it was booked over the phone. (121205/M = 12/12/05 in the Morning) If someone could help me I'd appreciate it greatly. :D

View 2 Replies View Related

Access Properties

Sep 15, 2004

Hi everybody!
Is it possible to set the properties for an access database not to confirm the changes when running an update query. I have done it under tools/properties etc. but then I make it in access in general. I want it to apply on one singel access database.

Anyone?

eroness

View 2 Replies View Related

Change Properties On Event

Apr 19, 2006

ciao people
i've been looking around for days, hope u can solve my problem!

my form is made up of several combo boxes
i wanna write a code which after a selection in any combo box sets the properties of the latter as follow: enabled NO and locked YES (just the opposite of the default value)

can u please help me?

View 2 Replies View Related

Change Properties On Event

Apr 19, 2006

ciao people
i've been looking around for days, hope u can solve my problem!

my form is made up of several combo boxes
i wanna write a code which after a selection in any combo box sets the properties of the latter as follow: enabled NO and locked YES (just the opposite of the default value)

can u please help me?

View 3 Replies View Related

Accessing The Database Properties..

May 6, 2005

Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name.

This window has several tabs including "Summary" and "Custom." It looks like this should be stuff that I can set and then reference from within my code.

My thought is that I can use the "Title" from the "Summary" screen as a variable for all of my msgbox titles. The other interesting one is "Project" on the "Custom" tab. It looks like this may be the same sort of thing.

I've found that the Access Help is absolutely useless - I'm about ready to take a shotgun to "Clippy." But as they say, a display is a terrible thing to waste <grin>. I've also found that it's getting harder and harder to find what I'm looking for in the MSDN library. There's so much stuff and they don't always file it in logical places.

Well, thanks for reading.. sorry for the rant. As usual, any help is appreciated!

Cheers!

View 2 Replies View Related

Altering Chart Properties?

Dec 13, 2005

I have a line chart built in Access. Is there anyway I can change the line colors like I can in Excel? The default fuschia, bright yellow, and bright blue are horrendous.

View 3 Replies View Related

Modifying An Icon's Properties

Mar 21, 2006

I have an Access database split into FE/BE. For the front end, each user has his own directory on the lan. The directory is named with the UserName.

I've created an installation program in Access. It basically installs the icon on the user's desktop using Environ("UserName"). It also installs an Excel file the program needs on the hard drive.

Here's the problem...Right now, the installation program grabs the shortcut off the lan and installs it, but that shortcut has one user's UserName hard coded as the target. That one piece of information needs to change for each person. Is there a way for the program to modify the target based on the username of the person running the installation program? Without this piece, I need to visit every user after he runs the installation program and modify the properties of the new icon to point to his specific directory.

Thanks for any help you can provide!!

View 2 Replies View Related

How To Disable The Properties Window

Nov 30, 2006

I was hoping someone knows how to disable the ability for users to gain access to the properties window.

When viewing a form (or any object), one can usually right click, click on the corner of the form, or a few other actions and gain access to the properties option. If selected, the properties window is displayed with all the object's properties.

Is there a way to NOT allow the users to select this option? i.e. to disable this option from the menu list?

Thanks for any help you can provide.

-arm1

View 3 Replies View Related

Can't Resize The Properties Window

Aug 13, 2007

I have been running 2003 on XP SP2 for some time but a couple of days ago I needed to do a 'detect and repair' on Word but without resoring defaults. When I opened Access, the Properties Window was back to its default (small) size and couldn't be resized. An uninstall/reinstall made no difference.

Has anybody got any idea what might have happened and what I can do to put it right? I usually have it the height of the screen and this is driving me nuts!

View 14 Replies View Related

Copy A Column And It's Properties

Mar 9, 2005

hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.

thanks for reading.
Seiky

View 1 Replies View Related

Copy A Column And It's Properties

Mar 10, 2005

hello,
I wanted to know how to copy a column and it's properties by programming (VBA-SQL).
I have a column that has a list of values, and want to duplicate it (with another name).The new column should have the same list of values.

thanks for reading.
Seiky

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved