Create Explorer (File Manager) Style Drill Down

Dec 6, 2006

Hello, I am wondering if there is an efficient way to create an explorer style drill down for a location/equipment table I have

i.e.

-Dept
+Finance
+HR
-Quality
+Supplier
+QA
-General
+Etc1
-Etc2
+Production

I have used the tree control to acomplish this but the major drawback I have found is it becomes WAY too slow when utilizing large amounts of data due to many embeded loops. Does anyone know an alternative or a way to program the tree control to only add nodes once a selection is expanded?

Basically I want this to operate as a drilldown of infinate levels with the speed of windows explorer. Unfortunatly all the code I have seen requires that all nodes are designated/Created when the form is loaded.

Any thoughts are greatly appreciated

View Replies


ADVERTISEMENT

General :: Create File Explorer Functionality In Access

Jan 31, 2013

how to create file explorer like functionality in ms access.

1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories.
2- I also need to be able upload (copy/paste) folders and files in that directory

I looked at different solutions and found a solution which might work on this foum link below.
---access-programmers.co.uk/forums/showthread.php?t=102667----

The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.

View 5 Replies View Related

How To Create Drill Through Report Link In Access

Oct 1, 2004

I have a Summary report and a detailed report in MS Access. Upon clicking one of the records in the Summary report should open the detailed version for that record only. Lets say the Summary report has a list of employees. Upon clicking an employee record/link in the summary report should open the detailed report containing the details for that employee alone.

View 1 Replies View Related

General :: Cannot Open Database File From Windows Explorer

Jan 9, 2014

All of the sudden I get an error message when I try to open my database from a file rather than through Access. If I open Access first and open the file that way, there is no problem but if I click on it from Windows Explorer, I get the error.

See picture.

View 7 Replies View Related

How To Create Backups/failsafes For Replication Manager/A97?

Jan 22, 2007

I have tentatively gotten an indirectly synchronised database system to work on a testing basis, in the following way:

1. Design Master - resides on network.
2. Replica Master - replica of master, resides on network
3. Local replica on the windows desktop of my laptop (as one of few folders with write authority). These three are managed by a synchroniser running on my laptop.
4. Other people (3-6) also have synchronisers running - managing the Replica Master, and a local copy on their desktop only.

This appears to work. It was done as we did not have access to get a synchroniser process running on a server, just folder access (I am amazed IT accepted this without oversight, anyway..). I would be happy to describe the procedure.


However, does anyone have any advice on potential things that could go wrong and how to avoid them? What problems could crop up? I don't believe database size would be one of them. How about backups? I know that the network is backed up daily and can be restored to any day - but would this method of backup create any problems if restoring? How rare are collisions/conflicts?

Also, is there any limitations to using the Compact utility in Access on either the replica master on the design master? Would this cause changes to get lost?

Would be grateful for advice.

Edit: Addition, just as I was submitting this, my synchroniser appears to have gone into a loop... From the log file:


Time = 2007-01-22 01:23:55 PM
Log Type = Close exchange
Replica = \afsukhofs02N_Dept[Folder names]Replica master.mdb
Exchange ID = {D4C646CE-140A-4DE0-B164-FE924A44C7A3}
Result = Failure

Time = 2007-01-22 01:23:56 PM
Log Type = Cancel exchange
Replica = \afsukhofs02N_Dept[Folder names]Replica master.mdb
Exchange ID = {D4C646CE-140A-4DE0-B164-FE924A44C7A3}
Reason = More than one synchronizer is managing the replica


This looks to be a problem... Is it caused by having multiple synchronisers managing the same replica? Does it work to set them to manage the local one only? Advice GREATLY appreciated. :P

View 1 Replies View Related

Forms :: Provide File Explorer Functionality To Open PDFs

Nov 1, 2013

I'm a newbie and using Access 2007.

I have added functionality that creates a report, saves it as a PDF, and then sends it to a customer via email as an attachment. The PDF file is saved to a folder and is named to include the Customer's unique customer number and the date and time the PDF was created.

For example, if the customer number is 09 and the date was 10th October 2013 and the time 09.00am, the file name is 0009101020130900.pdf.

What I want to be able to do from within the database is to have a button, that when clicked, will display all of the Pdf's for only customer number 09. The customer number will be based upon a field in the customer record.

View 4 Replies View Related

General :: Rightclick Menu In Explorer - Compact Or Decompile Access File

Sep 24, 2012

I am looking for a registry setting or .reg file to rightclick on an Access file and in the menu i want to compact or decompile the access file.

I know it is possible but i don't know what's the registry setting.

View 1 Replies View Related

Trying To Create A Report (calendar Style) Based On Weekly Activities

Jan 15, 2015

I have created a table for a Gym that shows which classes / activities are on which days. You will notice in the image below that i have assigned Boolean to associate a class with a day of the week.

I now am trying to create a Calendar STyle report that GROUPS all activities by the day they are on. So, for example, see below:

As you can see, all of Monday's activities will appear first (in a group) followed by Tuesdays.

One way I think I could achieve this is by doing a QueryMonday, QueryTuesday...etc so I have dataset or resultsset for each day. Then I could bring into a report, each query as a sub-report. I believe this is overly complex for what i'm trying to achieve. Also, using 5 grouping levels in one report doesn't achieve it either.

View 2 Replies View Related

Forms :: Access Style And Window's Style Form Border?

Nov 15, 2014

In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.

View 4 Replies View Related

Linked Table Manager File Path View Truncation Problem

Sep 30, 2005

How do you get to see the entire file path in Access Linked Table Manager of linked tables that are located in a folder with a long path? The problem is that you can only view the first 64 or so characters of the table’s path. This is a real problem when these linked tables need to be updated and you don't know where it’s stored.

Jean-Guy

View 3 Replies View Related

Nested Tables/drill Down Limitations...?

Jun 16, 2005

Hi there,

I'm using access 2000 for starters.

I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data access form to work with.

However i have found that tables 1 through 7 are visible, but access doens't give a little "+" in the corner of table 8 to get to tables 9 and 10. i.e, i can't seem can't seem to drill down beyond table 8 to view related records in tables 9 then 10.

Does this mean that there is a limit to how far you can drill down through table relationships within access?

Thanks
Vince

View 9 Replies View Related

Nested Tables/drill Down Limitations...?

Jun 16, 2005

Hi there,

I'm using access 2000 for starters.

I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data form to work with.

However i have found that tables 1 through 7 are visible, but access doens't give a little "+" in the corner of table 8 to get to tables 9 and 10. i.e, i can't seem can't seem to drill down beyond table 8 to view related records in tables 9 then 10.

Does this mean that there is a limit to how far you can drill down through table relationships within access?

Thanks
Vince

View 2 Replies View Related

How Combo Box Can Drill Down Results As I Type A Name

Jun 16, 2006

How can i do the following? In a combo box, how can i type in say PEPPER and see every formulaName that contains Pepper in their description. I would get back Red Pepper, Orange Pepper, Black Pepper, Pepper, to choose from. Notice that Pepper can be anywhere inside the name.

I would like the choices change as i type. In other words, if i type BL, i would start to see choices like Black Pepper, Blue Pepper, Roger Blueboy, Green Bloak or any formulaname containing BL.

I presently have the following combo box. if i start typing BL and hit the down arrow, i will see formulas starting with BL. unfortunately, furtherdown, i also see all the other thousands of formulas in the base; meaning I see things that start with C, D, E etc.

I was hoping that i would see every formula containing the letters that i type, As I Type. so if i went further and typed BLAC, the formulas that almost made the cut, disappear from view, leaving me with things having BLAC in name, anywhere in the formulaName. Is this possible? I kind of want to DRILL down. when i finish typing black, i would have all formulaNames that have the word Black somewhere.

here is the combo box after update code:
----------------------------------------------
Private Sub CboFormulaNameFilter_AfterUpdate()
If Me![CboFormulaNameFilter] = "<All>" Then
DoCmd.ShowAllRecords
Else
DoCmd.ApplyFilter , "[FormulaID] = Forms![frmFormulaMain]![cboFormulaNameFilter]"
End If
End Sub
------------------------------------------------

============================
Here is the row source sql code:

SELECT DISTINCT tblFormulaMain.FormulaName, tblFormulaMain.FormulaID, tblFormulaMain.Description, tblFormulaMain.FormulaStatus
FROM tblFormulaMain
GROUP BY tblFormulaMain.FormulaName, tblFormulaMain.FormulaID, tblFormulaMain.Description, tblFormulaMain.FormulaStatus
ORDER BY tblFormulaMain.FormulaName;
===============================

FormulaID is a text field.

thanks
Penwood

View 13 Replies View Related

Cannot Create An MDE File

Jul 4, 2005

I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work.

This is what I got:

This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.

So installed office XP and tried the same steps but still not working.

View 1 Replies View Related

Unable To Create An Mde File

Jan 1, 2006

I am running access 2000 9.0.2720. I wanted to create an MDE file but every time I attempt I get the message 'unable to create an MDE file'. Any advice?

View 1 Replies View Related

Create Custom Help File

Oct 11, 2004

I am just having a heck of a time, in trying to make a custom help file.

Has anyone had any luck? I sure would like to see a sample database, showing a
custom help file. I just about tried everything, but not to smart about setting one up.
I have tried the wizzard as well. I know where I get hung up is, trying to map the help file,
to the Help ID number.

Any help would be appreceiated

View 6 Replies View Related

Unable To Create .mde File

Oct 28, 2004

I was able to create a MDE database from .MDB file (1900 KB) using Access2000 but not on the other database (5000 KB)
I followed the steps (under tool -database utilities- make MDE file), the message box shown " Microsoft Access was unable to create a MDE database"

Is there any limit on the size of the file? What should i do or check?

NaNy

View 4 Replies View Related

Can't Create MDE File - Alternative

Dec 7, 2005

I have tried to create an MDE file for my database but can't figure out why it will not let me. I can't don't think I am over the limit in open TableIDs. I have 76 Forms and 91 Tables.

I am setup with two databases - the database with the data is on the server. Is there any other alternative that I can do other than putting the mdb file directly on the client. And if not is there a way to stop the mdb file from constantly growing in size.

View 4 Replies View Related

How To Create Log File In Access

Jun 11, 2012

How I can create a log file in Access?

This file will record all processing on access file

View 6 Replies View Related

How To Create An Empty Excel File ?

Sep 28, 2005

Hello,
I would like to know how to create an empty Excel file (from Access) ?
I would like to name the workbook (xxx.xls) name the sheets and give the folder where to store it.
Thanks in advance for help.
VINCENT

View 5 Replies View Related

Create Help File Inside Of Access

Oct 6, 2005

I created a help file in access that lets you have text mesasge up to 1024 chars. Just press F1 key on any control that you have setup to bring up help message.

Does any one see any problems with the way I did this?




Form
Help File: = ""
Help Context ID: = 0

For each control on the form where you would like to have a help message do the following.
Form
Control
Help Context ID: = Set to one of the help index numbers in the help table.

Add KeyDown Event to the control

Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
'Add this line
KeyCode = DisplayHelp(KeyCode, Me.ActiveControl.HelpContextId)
End Sub



module

Function DisplayHelp(KeyCode As Integer, HelpContextId As Integer) As Integer
Dim dbs As DAO.Database
Dim rstRecords As DAO.Recordset

If KeyCode = VBKeyF1 Then ' 112 = F1
Set dbs = CurrentDb
Set rstRecords = dbs.OpenRecordset("SELECT tlbHelp.Index, tlbHelp.HelpMessage " & _
"FROM tlbHelp WHERE (((tlbHelp.Index)=" & HelpContextId & "));")

With rstRecords
If .RecordCount > 0 Then
Call MsgBox(!HelpMessage, vbInformation, "Help")
End If
End With
DisplayHelp = 0 ' Clear KeyCode
rstRecords.Close
Set dbs = Nothing
Else
DisplayHelp = KeyCode
End If
End Function



Create Table and Fields

Table Name: tlbHelp
Field Name: Index as Number
Field Name: HelpMessage as Memo
Field Name: FieldName as Text
Field Name: FormName as Text

How type in custom number and message for each help message.

View 2 Replies View Related

Create Connection Without Lock File

Feb 26, 2006

Hi there, we currently have a database that users write to through an excel form. Each time a user sumbits a record to the database we open a connection up with the below code, insert the record and then close it. This creates a ldb file for 1-3 seconds depending on how long it takes.

' OPEN DATABASE CONNECTION
Set dbConn = New ADODB.Connection
dbConn.CursorLocation = adUseClient
dbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0"
dbConn.Open sConn

' INSERT RECORD THROUGH EXECUTE COMMAND
dbConn.Execute("INSERT INTO.... VALUES....")

' CLOSE CONNECTION
dbConn.Close

Is it possible to open the connection up without an ldb file being created so more than 1 user can insert a record into the database at the same time?

Thanks for your time,

Cheers

Tony

View 6 Replies View Related

Expression To Create A File Code

Nov 16, 2004

I have a main filing table and three look up tables (file cabinet, topic, and subtopic). In the three look up tables I have created short codes to identify the name of the field.

I want to create a main filing code that takes the codes from each lookup table and combines it into one field. If the location of the file changed I would need the code to change.

Example file cabinet location Rod 1 is R1, Accounting is AP; file topic Active Jobs is ACTJOB, Bank Transactions is BANKTR; subtopic Northeast Fire Station is NETCFS. For the file for the fire station the code would read R1ACTJOBNETCFS.

The form is set up as a cascading combo.

The only purpose for this field is to allow me to do a mail merge to create labels so that I can re-file folders easier without having to go into the database and look up the locations.

I don't know if I should create the expression in the form or if I should do something in the table field.

Suggestions?

View 1 Replies View Related

An Easy Way To Create An XML File From A Query?

Jun 13, 2007

Is there a relatively easy way to output the results of a query to an XML file?

I have the file writer set up more or less:
Code: Dim intFn As Integer Dim strFilePath As String Dim strOutBuf As String strFilePath = "c: emp est.xml" intFn = FreeFile Open strFilePath For Binary Access Write As #intFn strOutBuf = "<?xml version=" & Chr(34) & "1.0" & Chr(34) & " standalone=" _ & Chr(34) & "yes" & Chr(34) & "?>" & vbCrLf strOutBuf = strOutBuf & "<file>" & vbCrLf 'DO FOR EACH LOOP HERE strOutBuf = strOutBuf & "</file>" Put #intFn, , strOutBuf Close #intFn
If this were a C or JAVA application, I would just write a "for each" statement similar to as follows:

Code:For Each (Row in Query){ strOutBuf = strOutBuf & "<entry>" & vbCrLf For Each (Field in Row){ strOutBuf = strOutBuf & "<" & (Column Name) & ">" & (Value) _ & "</" & (Column Name) + ">" & vbCrLf } strOutBuf = strOutBuf & "</entry>" & vbCrLf}
What commands would I use in Access to get each separate row in a query? And then to get each field in that row? And how about the column names for the XML tags?

Thank you for your help.

View 4 Replies View Related

Modules & VBA :: How To Create Hexadecimal File

Sep 13, 2013

I would like to read a TIFfle to ACCESS, and store its content as hexadecimal like below to further other process..., how can I achieve this change and storage??

0000: 49 49 2A 00 4E 00 00 00 80 3F E0 50 38 24 16 0D
0010: 07 84 42 61 50 B8 64 36 1D 0F 88 44 62 51 38 A4
0020: 56 2D 17 8C 46 63 51 B8 E4 76 3D 1F 90 48 64 52
0030: 39 24 96 4D 18 80 80 00 60 00 00 00 01 00 00 00
0040: 60 00 00 00 01 00 00 00 08 00 08 00 08 00 0F 00
0050: FE 00 04 00 01 00 00 00 00 00 00 00 00 01 03 00
0060: 01 00 00 00 11 00 00 00 01 01 03 00 01 00 00 00
0070: 0F 00 00 00 02 01 03 00 03 00 00 00 48 00 00 00
0080: 03 01 03 00 01 00 00 00 05 00 00 00 06 01 03 00

View 4 Replies View Related

Create Database From INI File Provided

Mar 3, 2012

An ancient application I'm working with came with .ini file which looks like an instruction set to create an access database. A sample few lines look like:

TABLE, USER, 13
FIELD,USRID,LONG,2,NODUP,ID,False,0,AUTO
FIELD,USRFNAME,TEXT, 50, NO, , True, 1

TABLE,VISITS,15
FIELD,VISIT,TEXT,12,NODUP, ID,False, 0

and so on.

Is there a way to get Access (2007 in my case) to create a new db by reading from this file? Or do I need to manually enter all this information.

View 1 Replies View Related







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