General :: Maximum Number Of Subfolders / Directories
Dec 19, 2012Got to the stage where I'm creating and accessing folders via my db.
Is there a number out there for what is deemed a sensible maximum number of subfolders in a folder?
ADVERTISEMENT
General :: Copy A Pdf File Between 2 Directories
May 31, 2013I am trying to copy a pdf file between 2 directories. I am using xCopy, When I build my copy statement based upon various parameters, it looks something like this:
xCopy C:PDF995OUTPUT*.* P:Billing1297344137.pdf /y
I might note that there is only one file in C:PDF995OUTPUT at a time. So I copy what is there, delete it and it is empty until the next usage.when it executes the statement, I get a DOS message asking whether what is being copied is a File or a Directory.How can I identify that without needing to respond to a message?
Auto Increasing A Number, Depending On Maximum Number When Condition Is Met
Sep 18, 2006Hi,
I'm trying to get the maximum number in a table field to increase it by one depending on the member that is selected in a drop down in a field.
I have three tables: members, programs and times. Each member can have N programs and each program can be broadcast N times.
Each member has a three digit code, like XXX. Each program has the three digit code of the member + three numbers that are supposed to auto increment. That is, the first program of member X with the member code XXX is called XXX001.
What I'm trying to do is that when a new program is filled in and I select the member, then the program code should update automatically, adding one to the latest program by that member.
That is, if the last program by member X that was inserted in the database is XXX010, then if a new program is inserted it should automatically be XXX011, even though programs by other members have been added in between.
This is the code I use now, for the AfterUpdate when selecting the member in a dropdown in the form. But although I've played around a bit, I just get error messages...
Private Sub medlemsruta_AfterUpdate()
Dim medlemskod
medlemskod = Me![medlemsruta].Column(2)
Dim strMax As String
strMax = DMax("programs_kod", "table_programs", "Left$(programs_kod, 3) = medlemskod")
Me!program_kod = Left$(strMax, 3) & Format$(Val(Right$(strMax, 3)) + 1, "000")
End Sub
Medlemsruta is a dropdown where one selects the member from the members table, where the three digit code is in the third column (Column(2)).
I'm trying to use DMax to get the maximum number for the particular member and after that adding 1 to that for the new program code.
Grateful for any advice! Thanks!
Maximum Number Of Connections
May 4, 2005Hi,
we use access for localisation in our application. The business object which accessess the access uses DAO connectivity and we often land to
"Too many client tasks" problem.
is it wise to change the DAO to ADO? if so the above problem will go off?
what are the chances that the problem still persists?
is that access has any limits on the number of connections? like 64, 255? or is that ADO/DAO has any limitaions on the number of concurrent connections to access DB?
Pls help, your help will be highly appreciated.
Thanks,
Venkat.
Maximum Number Of Records
May 3, 2006hi all,
This is general question only. How many number of records that Access can handle as a maximum records?
Or it only depend on size limit (4GB)???
thanks
Maximum Number Of Relationships?
Jun 3, 2005My issue:
Does anyone know the maximum number of (one to one) relationships with cascading deletes a table can have?
Background:
I have a split database peer-to-peer application with ten simultaneous users, 250+ linked tables running on A2K, AXP and A03. MSDE and SQL Server are presently not viable options.
I'm unable to manually or programmatically relate one table to 73 others with referential cascade deletes; some of the 73 are related to still other tables. The one table is used as a recordsource on a subform on each of 73 different main forms, each of the latter having a different recordsource.
In other words, I want to delete a record in any of 73 different main forms, each with a unique table recordsource, and then cascade delete a subform record (which has the same table recordsource, regardless of the main form).
If I combined the 73 into a single table, I'd have a monster record with 500+ fields, assuming the latter is even possible, and in which event perfomance would suffer from excessive network traffic.
What I've tried:
I haven't worked this issue for some time and have forgotten the number of relationships for a single table I've been able to create. As I recall, it's on the order of 20 relationships maximum for one table.
Of course, I can do it programmatically delete the subform record on the OnDelete event of the main form, but, for elegance, I'd like to use a cascade delete.
Peer-to-peer network performance is not presently a problem.
Maximum Number Of Records
Nov 1, 2014I have created a db for my warehouse, now what I want is to set a maximum no of items to be issued to one person = 20 (means 20 rows only) in a subform. If the number exceeds it prompt user that you reached to the maximum no of issues.
View 2 Replies View RelatedMaximum Number Of Fields In Table
Dec 27, 2006I have run into a problem with an ODBC table connection. The table I am connected to exceeds the number of fields allowed in an Access table. I am using Access 2003. When I looked on Microsoft help site I think the max number of fields in a recordset is 242 so I am unable to see all of the fields in the original table I am linking to. Does anyone know if this limitation has changed in the newest version of Access? I checked the Filemaker www site and that program does not have the same limitations. Thanks in advance for any help!
View 4 Replies View RelatedMaximum Number Of Fields In A Table
Feb 8, 2008Hello there.
Is it better to have many fields in one table or to split the data between a number of tables and link them?
Thanks.
# gingette
Maximum Number Of Columns In A Query
Aug 21, 2007hi there
how many columns is the maximum in a query?, because i have one that has 26 columns , but i need some more... what can i do?? is there a way to add some empty columns to a query??
thanks
How To Retrieve Column Name That Contain Maximum Number
Apr 9, 2013I have an Access database with a table that contains 11 fields. The first is a unique ID and the other 10 fields are various numbers. I need to know which of the 10 columns contains the highest number for each row and return the 2 rightmost characters of that column name. I started with the "maximum" function that I found on-line and it works to give me the maximum number in each row, but I need it modified to return the 2 rightmost characters of the column name that contains that number.
Code:
Function Maximum(ParamArray FieldArray() As Variant)
' Declare the two local variables.
Dim I As Integer
Dim currentVal As Variant
' Set the variable currentVal equal to the array of values.
[Code] ....
Query Maximum Number In Hour Per Day Every Cell ID
Jul 13, 2015I need to know about "Need to query result from access2007 find only "one maximum number" in hour per day every cell ID"
How I use sql command?
See my file at ...
Maximum Of 20 Combo Boxes Will Appear Based On Assigned Number
Oct 14, 2014I am trying to create a training matrix in which i need a form that if I put or assign maximum of 20 attendees then 20 comboxes will appear in form.for example, i enter in textbox1 6 or 15 depends but max is 20 then if hit enter comboxes will appear but quantity will based on value that i enter in textbox1.
View 4 Replies View RelatedGeneral :: Maximum Access Users
Dec 9, 2013I know that Access probably permits around 20 or so users to simultaneously access the database before it start to become unfriendly. However, I have a database that would require 200 or so users grabbing around 1,000 rows of data via an Excel ADO connection to the backend tables.
So they would never need to physically go inside the Access database its self, but instead it would garb data by opening an ADO connection to the database > Grabbing the data > Closing the database connection.
Is this okay to do with around 200 users simultaneously querying the database tables via an Excel ADO connection?
Create Sub Directories
Jun 15, 2006Hi All.
I have searched forums......honest!! But cannot find an answer.
I have the following code to make a directory....the directory name is as the ID_number....
---------------------------------------------------
Private Sub Command216_Click()
Dim strDirectoryPath1 As String
strDirectoryPath1 = "\server1Helpdesk_Calls" + CStr(Me.ID_Number)
If Len(Dir$(strDirectoryPath1 & ".", vbDirectory)) <> 0 Then
MsgBox "The project folder already exists, the folder will now open"
stAppName = "C:Windowsexplorer.exe \server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
Else
MkDir (strDirectoryPath1)
MsgBox "A folder has been created on the network at location \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
stAppName = "C:Windowsexplorer.exe \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
End If
End Sub
------------------------------------------------
This works fine, and makes a directory on the network drive i.e
\server1helpdesk_calls123456
My question is, how do I also make it create directories under this one i.e
\server1helpdesk_calls123456Emails
It is the ID_number that is throwing me....have tried with numerous goes!!
Many Thanks.
Frank.
General :: How To Pull Maximum And Minimum Start And End Date
Jan 11, 2013I would like to know if it is possible to pull the max and min start date and end date. Basically i have an option where by the user selects the desired date range that they would like.
Now I would like to know how to get the earliest and latest date range should they not select a date range. My date range is being displayed at the top of my report.
Modules & VBA :: Retrieve Count Of Emails In Outlook Subfolders
Jun 28, 2014I need to retrieve the count of emails in a shared exchange mailbox in Outlook 2010. I found the following software that retrieves the count I need, but only in default folders or ones that are 1 layer deep. The folder I need is two layers deep Mailbox -> Inbox -> Completed. Is there anyway to drill down just one more level?
Const olFolderInbox = 6
Set objOutlook = CreateObject("Outlook.Application")
Set objNamespace = objOutlook.GetNamespace("MAPI")
Set objInbox = objNamespace.GetDefaultFolder(olFolderInbox)
[code]....
Modules & VBA :: Delete A Folder To Include Subfolders And Files?
May 25, 2015I need a way to delete a folder along with subfolders and files associated with a record via command on a form:
The path is stored in a text field "txtDocuments".
For example: "C:UsersWatsonDesktopFY1515051505-010"
So, I would want the code to pull the folder location from the txtDocuments text field and delete folder "1505-010" and all sub folders & files contained within it.
Modules & VBA :: Searching Subfolders To Open Files Using File Names
May 19, 2015I am using Access 2010 with Win-7.Shared, split database with several users.Database Purpose:PM Procedure for Medical Equipment..To be able for the user to copy the file name of 1 or more technical manuals and paste into a table used for a subform on the procedure parent form.Users can then open the related files stored in a common directory that are related to the procedure when later reviewing the procedure .
Problem:File path on the common drive for our group remains static Syspro_5VOL1BIOMEDCOMMONEquipment (Service Manual).The subfolders are not static.There is an unlimited number of sub folders by vendor, model, or make.The subfolders sometimes get renamed as vendors change ownership.The file itself usually does not get renamed.New subfolders get added as needed.Everyone in our group has access to this area of the server.
Question:Is there a way in VBA that when a user opens the procedure record form and dbl-clicks the name of the file in the subform, Access can start at the parent folder and keep searching through all the subfolders until it finds the file?I cannot depend on people in my group to be able to correctly update hyperlinks so I need a way people with no Access knowledge can even use even if its a little slow.
General :: Getting Invoice Number Field To Auto Generate Next Number
Jun 2, 2014I'm trying to get an invoice number field to auto generate the next number, keeping the format as "00000"...this is what I have, which gets the next number but drops the leading 0
Code:
Private Sub Customer_AfterUpdate()
If Len(Me.[InvoiceNumber] & vbNullString) = 0 Then
Me.[InvoiceNumber] = (DMax("[InvoiceNumber]", "[tblInvoiceNumber]") + 1)
DoCmd.RunCommand acCmdSaveRecord
End If
End Sub
invoice numbers are 04024, 04025 etc...how I keep the formatiing?
General :: Auto Number PK Change Starting Number?
Dec 18, 2013I have a table with an auto number PK. This table will contain orders. I'd like to use the PK from this table as the Invoice number on the invoice. I'd like to have it start at a number other than "1" just because it looks better on an invoice. I don't know how to do this. I looked at the table design to see if there were options available to me there but couldn't find anything. Is it possible? (I do not know how to use code.)
View 7 Replies View RelatedHow To List Multiple Files In Multiple Subfolders
Nov 14, 2005Does anyone out there know how I might do the following:
I have a main folder which contains many sub-folders. In turen, each subfolder contains several files. I am interested in creating a text file that within each sub-folder will list certain files in that sub-folder. Example:
"Main Folder"
"Sub-folder 1"
FileA
FileB
FileZ
"Sub-folder 2"
FileA
FileB
"Sub-folder 3"
FileA
FileB
FileZ
Pseudo-code:
Read Main Folder
Do While Sub-folders exist
Do while selected sub-folder contains files
If selected sub-folder contians FileZ then
Write selected sub-folder name to text file
Write time/date stamp to text file
else
loop to next ub-folder
end if
end do while
end do while
Close input and output
Any help offered is greatly welcome. Thank you!!
Getting A Maximum Value
Jun 5, 2005I have a Table where the are several entries all with Fields A, B and C
the same, and varying values for Field D.
There are several different values of A, B and C.
I want have a query, pick out each combination of A, B and C and just the
Max value of D for that combination.
It looks as if it should be simple but I can't figure out how to do it?
Anybody able to help?
Maximum
Jul 10, 2005Hi to all;
I am not familiar with access function, in Excel its very easy to find the max value at row level, what's the formula in access query to get the max of this example
Co1co2 co3….co60max(co1:co60)
200150300 500 ?
212542321 222 ?
thanks in advance for respond
Majed
How To Select The Maximum Value
Jul 17, 2007Hi all
I have an expression in a query which is checking a list box on a form. If the list box is empty (is null), then I would like the query to search on the highest (maximum) value in the specified field (CourseFK), otherwise it will look for the value in the list box.
Expr1: IIf([Forms]![frmEditDeleteStudentDetails]![lstEditCourseFK] Is Null,[CourseFK]=Max([CourseFK]),[CourseFK]=[Forms]![frmEditDeleteStudentDetails]![lstEditCourseFK])
However it seems Access will not allow me to do this - I get an error about an aggregate function in a where clause.
Can someone please suggest to me how to get around this? Eg, is there an alternative way to search for the maximum (still needs to be determined dependant on the list box).
Thanks
Maximum Question
Dec 10, 2007Hi,
Can some1 tell me how to create a query that shows me the ProcessID for max time and date (date and time are in separate fields) for every PersonID. I need to run a query once in 5 minutes to check the job that every person is doing. They are entering the processID every time they get a new work to do.