Need To Display A List Of Folder/subfolder Contents
Nov 15, 2006In access, I need a way to display a list with folder contents, for example...
Folder1
subfolder1
file1
file2
subfolder2
file1
Folder2
subfolder1
etc
ADVERTISEMENT
List Directory / Folder Contents In A Form
Mar 23, 2005I have 12 folders (User1 - User12) located in "c:users..."
When I select a UserName from a combo box in a form e.g. User3 , a list of all files with extensions ".doc" in the respective directory (c:usersuser3*.doc) should render with a hyperlink to the file / s.
I have tried variouse "Select Case" and "FileSearch, FoundFiles" scripts, to no avail.
Any assitance would appreciated.
Current Version: Access 2000
Modules & VBA :: Test If Main Folder And Subfolder Exist
Mar 1, 2015I'm having problems creating a second subfolder in the main folder.
The main folder is used to keep inside the reviews of clients inside.
The code I have now, will only create a main folder if it does not exist and then a subfolder with the BIN nr, type review and date. If the client would have a diferent ones and in diferent years. So if it has first "Prototype Model", the next one could be "Prototype Review". The part of the code that checks if the main folder exist works, but how to let the code create in the main folder the second review subfolder? Please see below code I managed so far:
Code:
Private Sub btn_Create_Folder_Click() 'XXXXXXXXXX working onXXXXXXXXXXXXXX
Dim path1 As String
Dim path2 As String
path1 = "C:Test_FolderMedium" & Me.BIN & "_" & RTrim(Me.LE_Name) & ""
path2 = "C:Test_FolderHigh" & Me.BIN & "_" & RTrim(Me.LE_Name) & ""
[Code] ...
How to have the code test both of them?
Modules & VBA :: How To Open Treeview Node To A Specific Folder / Subfolder
Dec 18, 2014I have a tree-view object that is filled with a specific folder list, when a command button is pressed I would like too expand to a specific node based on a variable/foldername.
How to achieve this? My knowledge of tree-view is limited and I am still learning VBA.
Contents Of Folder - Cut And Paste Using VBA In Access 2007
Jul 15, 2014I am new to VBA and I am looking for some code to use in access 2007 where I can cut the entire contents of a folder on my C: drive and paste it in a separate folder in my C: Drive
View 5 Replies View RelatedModules & VBA :: Textbox And Contents Will Not Display
May 3, 2014Me.TxtNotAllowed.Visible = True
dtTimer1 = Now
dtTimer2 = Now + TimeValue("00:00:10")
Me.TxtNotAllowed.Value = "You do not have permission to use this database !"
Do Until dtTimer1 >= dtTimer2
dtTimer1 = Now()
Loop
Me.TxtNotAllowed.Value = ""
DoCmd.Quit
The above code will run definitely for the 10 seconds however the textbox and contents do not display HOWEVER if stepped through with breakpoints line by line and the form checked each time the textbox DOES display and its contents.
Forms :: How To Get Third Combobox To Display Its Contents
May 14, 2015I have a requirement that will need three cascading combo boxes - the second box should only display the contents that match or are relevant to the first combo box, etc.The title of the YouTube video is:
Microsoft Access pt 9 (Cascade Combo Box)
It seems the first and second combo boxes cascade and works fine. However, the third combo box remains blank after the second combobox selection has been made.
I have three tables: Customer, CustomerSubOrg, and PORs. I have setup lookup fields that are using Primary keys for two of the tables (CustomerSubOrg and PORs). However, I ensured that the primary key fields display as the "Names" of each instead of the numbers. I also ensured I went back and changed their data type to "Text" instead of "Number" so the text appears (which seems to have worked for box #2).
How to get the third combobox to display its contents? I've attached some additional screen shots below. I know the problem is within the second combobox -- perhaps the query needs some adjustment?Unfortunately I cannot attach images yet since I am now. But I basically created two queries and used them each for the second and third combobox.The comboboxes on the form:
Customer
Sub Organization
POR
The Suborg query looks like this:
Table: CustomerSubOrg
First Column:
From field SubOrg
From table CustomerSubOrg
Second Column:
From field CustomerID
From table CustomerSubOrg
Criteria [Forms]![frmMain]![cboCustomer]
The POR query looks like this:
Table: PORs
First Column:
From field PORName
From table PORs
Second Column:
From field SubOrgID
From table PORs
Criteria: [Forms]![frmMain]![cboSubOrganization]
Why wont the contents from the third combobox appear?
Forms :: Display Contents Of Active Cell
Mar 2, 2014I'm trying to have a cell display the information from which ever cell the cursors is on.
I am trying to use (Master Info / Child info) for a subform but would like the Master cell link to where ever the cursor is.
Is this even possible?
Print List Box Contents.......
Mar 24, 2006...seems such a simple thing to do but I'm completly stuck. Everything I've found on the forum suggests alternatives to doing to above i.e. setting the query that produces the list to produce that report print directly but that wont work for this situation unfortunately.:eek:
Some background....
I have a form (lucky me) in which the user enters 3 category levels and a branch id, they click a button to generate a list of 50 random stock ids so they can be checked at the branch. A preview of the Stockid's (along with description and Stocklevels) is shown in a list on the form. The stock manager then needs to print the list box contents. If the query is re-run it will differ from what is shown in the list so I need to avoid this.
Any help greatly appreciated.....;) :confused: ;)
Clear Contents Of List Box
Oct 9, 2007Hey guys,
I have created a list box that is based on a select statement using the value of another list box.
for example:
box1 lets you select aaaa
box2 shows a list of all the records that have aaaa
now I need to know how to clear the list as box1 is changed
right now it will give me
aaaa123
aaaa789
bbbb123
bbbb789
I need to know how to clear it so that
aaaa is deleted and bbbb shows when the code is stepped through a second time.
code is as follows:
Private Sub Car_Empty_GotFocus()
prefix_input = Form_Car_Loading.Prefix.Value
Set db = DBEngine.OpenDatabase blah, blah, blah
sqlstatement = "SELECT [prefix], [Car_number], [Date_loaded] " & _
" FROM Car_loading where isnull(Date_Loaded)= true and prefix= '" & prefix_input & "' "
Set record = db.OpenRecordset(sqlstatement, dbOpenSnapshot, dbSeeChanges)
Move first
Do Until record.EOF = True
Form_Car_Loading.Car_Empty.AddItem (record(0) & record(1))
record.MoveNext
Loop
db.Close
End Sub
Display Images From Hyperlink Within Folder
Mar 9, 2006i've looked but can't find the answer!! which is unusual as this forum covers everything.
i have a field [photo location] with a hyperlink to a folder within which is a number of images. at the moment i have 2500 folders and its growing daily. the action i want when the 'photo location' field had got focus or when clicked is for the photos within the folder to open [not within the form itself] - either in seperate windows or preferably all together. i am using irfanview to display the images but am easy on this point. i do not want to give each photo its own hyperlink because there are thousands of them. any suggestions as to how i should do this?
thanks
Modules & VBA :: Display Random Image From Folder (Not Embedded)
Jun 26, 2013I'm working on a database for my holiday pictures. The pictures are organized in folders per trip/date/location.
When viewing the data of a particular trip, I want the form to display a random image from the respective folder (path stored in database).
I already found a function to count the files in the folder:
Code:
Function GetFileCount(folderspec As String) As Integer
' Returns a count of files in folderspec, or -1 if folder does not exist
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FolderExists(folderspec) Then
GetFileCount = fso.GetFolder(folderspec).Files.Count
Else
GetFileCount = -1
End If
End Function
to plug into a "randomizer":
Code:
lngFileCount = GetFileCount(strFOLDER)
Randomize
intRND = 1 + Int(lngFileCount * Rnd())
MsgBox intRND
The thing I can't find is how to reference this nth file (or even if there is a way to directly reference this file).
Is there, or do I have to use some kind of looping?
Created List Box With One Column - Display All Characters Of List Item
Jan 2, 2014I have created listbox with one column (contains one column only), now i would like to display all the characters of list item (want scroll bar to listbox).
How do i display all text of list item, I have already fixed Column Widths to max length (22";0.1"). However when scrolling to right, it is going to next blank column of list box, which is created only to change Column Widths property.
How To Open A Dialog Box To Move Files Inside A Folder That Is Setup As Current Folder
Sep 2, 2015I'm trying to automate a process of selecting a set of file/s and move them in a folder. When I click on a button, it should open a current folder that is setup in the code.
Lets say that I have a folder C:documents est, and very time I click on the button, it should open the dialog box with that path so I can select the files from another folder, drag them there and they will be saved in that folder.
This will form part of wider automation that will send an email stating that those file/s where placed in that folder.
I have in the same form where the button is placed, 3 check boxes that needs to be passed to the email as well that one or all the files where placed in the folder.
Modules & VBA :: Open Folder Nested Inside Main Folder?
Mar 16, 2015I'm trying to open a folder based on a BIN nr. This folder could be in a main folder that has diferent subfolder. As there where differnt naming used to create the folderes, one of the things they have always is the BIN nr. It alwasy start with a unique number and maybe I could use it to scan the subfolders and open that one that the BIN nr is equal as in the field BIN.
Now we have serveral 1000th of folders and finding them takes time.
Modules & VBA :: Create Subfolder And Copy File - Path Is Variable
Apr 18, 2014I have a folder which holds 1000s of pictures organised in subfolders, for example:
D:~AI Database Print Scans2009family and
D:~AI Database Print Scans2009holiday
And so forth. In total at the moment 17 main subfolders, each of which hold another 2-3 subfolders.
I am putting together a database to bring pictures together with all sorts of details. I import the picture via hyperlink and complete the various fields. All that works fine but there are a lot of pictures! And it gets confusing to see which ones have already been entered into the database and which ones haven’t.
One solution for this is to copy the pictures that have been “completed” to another folder. I have found a way to do that:
Dim fs As Object
Dim oldPath As String, newPath As String
oldPath = Forms!frmPrintDetails.txtPath1
newPath = "D:~AI Database Print ScansCompleted_Entries"
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile oldPath, newPath
Set fs = Nothing
Works fine, but the problem is that I loose the subfolder structure, it copies all pictures to the same main folder. I’d like to maintain the subfolder structure and add code to create the correct subfolders and next copy the picture. With the different paths I’m lost. I don’t know how to extract the correct path in code. I’d also like to either rename or remove the picture once I have completed entry of the details. The problem I have again is that I don’t know how to code for a changing path.
Modules & VBA :: Copy And Rename Excel File To Subfolder With Name Entered In Forms Control?
Jan 5, 2014I am still trying to copy an Excel file from a parent folder to a sub-folder, that this code creates, and name the copied file with the name used to name the sub-folder, using the name entered in a control field (named 'TheDirName) of an Access 2007 form. Here is my VBA, which names the copied file "TheDirName.xlsx.:
Private Sub MakeDir_Click()
Dim appExcel As Excel.Application
Dim lngLastDataRow As Long
Dim Folder_Path As String
'Create path for customer folder & files
[code]....
Forms :: Using One Dropdown List Box To Display A Selecting In Another Dropdown List Box?
Aug 4, 2014I have a form where I have two drop down list box.The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold
The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated.
I have a products form. When a user created more inventory they will selected in the drop down list create, then a quantity. Then I would like the status of the product to update to "Unallocated".
When the user placed an order but doesn't finish it they will choose the status of the inventory to be allocated so I would like the product status to be updated to allocated automatically.
They other status the user will choose them self and do not need to be linked to each other.
In my vba code I have tried with the OnClick and AfterUpdate sub procedures with the following code.
If Me.Transaction_Type.Value = "Created" Then
Me.Product_Status.Value = "Unallocated"
End If
If Me.Transaction_Type.Value = "Allocated" Then
Me.Product_Status.Value = "Allocated"
End If
Yes when i select "created" from the drop down list it does not change product_status to say "unallocated"
(in using access 2007)
Display A List Of The Most Recent Records
Aug 31, 2005hi. i would like this to happen....
i have a database where jobs are entered and the date and times of the jobs are kept in separate Date and Time fields.
to enter a date the user uses this method "30 12 05" and to enter a time like this "21.30"
i would like a query that will display the 10 most recent job additions according to their respective date and times. however, it will not be enough simply to view these records in a report.. what would be ideal is if the 10 records are opened.. in their original form format (goto next record...previous...(1/10...5/10) and the fields are editable like in the default job entry form. this is because after a job record has been added, maybe 20 or so minutes later, that record would need to be retreived as the last bits of information for that record will have been established.
how can this be acheived. i am clueless at the moment, so if there is a solution even resembling this scenario that would be ideal. (if a filter is going to be used...it can be either the 'date' or the 'time' fields, ideally though the query would use a combination of the two to retreive a more exact date to filter the records by)
thank you access world for even considering my dilema.
How To Display List Of Value Based On Combo Box
Mar 17, 2015I want to create a combo box on a form where I can choose between 5 company names, and upon my choice, I want a list box or another combo box to display the departments under the company I chose (each company has different departments), and when I choose the department, I want to another combo box to display the limited job titles under that department.
For example: I choose company A > combo box displays the 5 departments under company A (dept.1,2,3,4) I choose dept. 4 > display job titles under dept. 4
How can I do that? Should I do a table? A query?
Using A List Box To Display Query Information
Jul 30, 2013I'm trying to get a listbox to display results of a query that are only related to the current record being viewed.I have a form (setup as a continuous form) that displays a vendor table. I have a query setup to reference what parts a vendor supplies, and I would like those results to be visible on the form. I would use a subform to make this happen, but if I try and drop a subform on the main form, it says it won't do it with a continuous form. So, the listbox. I copied my form, dropped in the subform, and took a copy of the SQL statement. I then took that SQL statement and dropped it on the Row Source of the unbound listbox. I do get a return of Parts and Prices, but its the whole list, not just a list for the currently displayed vendor. My SQL is currently thus:
Code:
SELECT tblPrice.[Part Number], tblPrice.Cost, tblPrice.[Price Date], tblPrice.[Bulk Discount], tblVendors.[Vendor Name]
FROM tblVendors INNER JOIN tblPrice ON tblVendors.[VendorID] = tblPrice.[VendorID];
I have tried to wrap my head around it, and I'm stuck. GoogleFu has also failed me, as I can't find something quite on point to what I'm doing.
How To Display Data From A Relation In List Box
Jul 3, 2013I made a database with 3 tables:
"city"
"company"
"person"
Each company has a director (I choose from a list that's bound to "person" by its ID field)
Each person lives in a city (I choose from a list that's bound to "city" by its ID field)
So:
- a person's city is stored in "person" as the ID of "city", so I only have numbers (1, 2....)
- there can be two persons in "person" with the same name (the only thing that differs them is the city they live in)
The problem is:
When I try to choose a director in "company" from a list, it shows me the name, surname and the ID of the city the person lives in, all from the table "person". The trouble is, since there can be two persons/directors with the same name, I really need to see their cities (the real city name, not just its ID). But I still want the city in "person" to be stored as ID of "city".
I attached my database so you can see what I'm writing about.
practice.accdb
List Box Won't Display Time Correctly
Jun 25, 2014What I want is for the "Time In" column in the listbox to show the time as hh:mm, just like the other two. The listbox is pointing to the table correctly, as evidenced by all the data showing up, but what floors me is despite the "sign_in" table showing time in all three columns in the desired format of hh:mm, the listbox seems to have its own thoughts about how to display the called data.
View 7 Replies View RelatedReports :: How To Get List From Form To Display In Report
Apr 7, 2014I'm trying to get a list into a report, the specific list is build in a form.
How can i get this list displayed in a report ?
Can i load the list using vba code or is there an easy-er way of doing this ?
Display Specific Records In A Subform Using A Dropdown List
Apr 12, 2005Hi to all,
I developed a database where I keep all the problems that I face and their solutions along with its category.
Now I want to have a form that when I choose each category, I should have all its records.
I heard that I should implement this by using a subform but I couldn't manage. With a search at the topics I've seen that I should use a macro but I don't know how to implement it.
Possibly after the lookup field I should have an After Update function but how can I connect it with the subform?
ex. at category "hardware: floppy" i have 2 records and i want to see only these, and when i choose category "hardware: hard disk" to have other 5 records of that category
Help plz?
Modules & VBA :: Combo Box Will Not Display List In Correct Order
Nov 3, 2014I have code attached to a command button to fill a Combo Box with data from a music collection. A letter of the alphabet is entered into a Text Box then records beginning with that letter are copied from a table, either by Artist or Title. They are saved to a temporary table at which time they are in no particular order. Those records are copied to a further table and saved in alphabetical order. This table is then used to fill the Combo Box.
I used two temporary tables because the records were not displayed in the correct order. I hoped this might cure it, it did not. The records are in order in the table but not in the Combo Box.
Code:
Private Sub Command68_Click()
'SEARCH AND FILL COMBO BOX
On Error GoTo errTrap
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM tempList;"
[Code] .....