Check A Directory From Access

Aug 20, 2004

Hello creators,

I have a little problem and it is creating and checking directories.

In my database I have a form, on it you can see a record of a project. This project has a keyfield called projectno.
On this form there is a button to create a directory with the projectnumber. So far so good. (code example: MkDir ("C:projects444323")

My problem:
If the directory for some reason already exist the code stops and gives an error.

Now I want to create some code that checks if the directory already excist so than I can skip making the directory.

Thanks for the help!!!!!

View Replies


ADVERTISEMENT

Modules & VBA :: Check Directory For A Folder Name Which Has Certain String In It

Jul 25, 2013

I'm trying to check a directory for a folder name which has a certain string in it (RecNum)

However the fso object filesys.FolderExists does not take an argument when looking for part of a folder name on a particular path.

What I basically want to do is look in a directory for a folder with the RecNum variable as part of the folder name. if it exists open it, if not create it.

This is how far i've got:-

targetdir = targetpath & RecNum & ChannelPartner & Enduser

Set filesys = CreateObject("Scripting.FileSystemObject")
If filesys.FolderExists(targetdir) Then GoTo function_end
MkDir targetdir
If filesys.FolderExists(copypath) Then
filesys.CopyFolder copypath, targetdir
End If
MsgBox ("folder created")
function_end:

Shell "Explorer.exe /n,/e," & targetdir, vbNormalFocus

View 6 Replies View Related

Modules & VBA :: Check If Directory Is Open Before Saving PDF

Aug 28, 2013

I have some code that resides in a button on a report that allows me to save a PDF version of this report. My problem is that if i have the destination directory open on windows explorer, i get a runtime 2501 "The output To action was cancelled" error.Is there any way to check if the directory is already open, and cancel the output to, or close the window to avoid this error?

Here is my code:

Code:
Private Sub CmdSavePDF_Click()
Dim MyFileName As String
Dim MyPath As String
'Dim CompanyName As String

[code]...

View 1 Replies View Related

Open A Directory From Access

Nov 30, 2005

Hi, I wish to open a folder/directory (not a file) using the onclick event of a cmdButton. Any ideas out there?

Robb:D

View 1 Replies View Related

Access/Active Directory Relationships

Apr 29, 2005

I know the is probably wishful thinking, but is it possible, and if so how, to link or create groups from Active Directory for use in Access.

View 1 Replies View Related

Modules & VBA :: Link Access To Active Directory

May 8, 2014

I want to link into the active directory to get a list of staff usernames, so it will update the user table as new members of staff are created etc. We currently have around 130 staff, so rather than manually updating the user table i want it to pick up the usernames from AD?

View 3 Replies View Related

Modules & VBA :: Access 2010 - Active Directory Lookup

Jul 20, 2015

I have a database that, I would like to add a button that performs a active directory lookup. I would like it to check a username with Active Directory, and auto populate a few fields.

First Name
Last Name
Manager
Department

This is my first database and I have very little exp using VBA.

View 7 Replies View Related

Modules & VBA :: Saving Excel Files Through Access In Particular Directory

May 4, 2014

I am using Access to save an Excel file in a particular directory. The code was created about 10 years ago and hence saves the file with .xls extension and I would like to save with a .xlsm extension. If I just change the .xls to .xlsm, in the code below, the file is saved but the Compatibility Checker comes up (I would like to stop this) and when the file is reopened I get an error message stating there is a file extension problem and the file won't open.

Code:
strExt = ".xls"
'If .txtFriendlyName <> "" Then
' strDestFileName = .txtFriendlyName
'Else
' strDestFileName = Left(objFile.Name, Len(objFile.Name) - 4) & MakeFilePosfix(Now())

[Code] ....

View 7 Replies View Related

Using Active Directory To Restrict Access To Parts Of A Database

Jun 25, 2013

how to restrict access to forms and reports using the Active Directory. It is a pretty simple method to pick up and easy to use in any database. My problem comes when I try to apply this same method to tables and queries as well.

View 5 Replies View Related

Access Application For Check-in/check-out

Mar 19, 2007

Long time lurker, first time poster.

I'm in need a of a check-in/check-out application for my company. We have about 550-600 employees at any given time and our turnover is about 20-30% per year. Our check-in/check-out process requires our employees to personally visit between 30-40 areas in our company (personnel, safety, credentials, parking, insurance, etc) within the first month of employment. This is currently done manually and is a huge drain on labor, especially when check-in sheets are lost, misplaced or, in some cases, forged.

I'm looking to build a database that would be intranet based, password secure (by check-in area) that would allow the new employee to present at a particular check-in, check-out site, complete that portion of the check-in/out process and then allow the person responsible for the check-in/out to enter the status into the database. At any point in the process, I would want to know the status of the person checking in/out (how long they've been checking in/out and what portion of the process have they completed).

Can this be done in ACCESS?

Thanks

View 1 Replies View Related

Spell Check Error In Access 97

Aug 2, 2005

When I try to do a spell check in a Form by pressing F7 I receive this error:

Can't start the spelling checker because it isn't installed.

How do I get it installed?

Thanks!

View 1 Replies View Related

Access Check Box And Option Button

Apr 25, 2013

I'm new to access. I have created table with following fields.

ID No, Name, Address, Gender, Favorite Food

I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table.

Database1.accdb

View 2 Replies View Related

Tables :: How To Get Access To Check For A Condition In A Table

Apr 25, 2014

I'm relatively new to Access 2010.

I want Access to look in one table for a certain condition, and if it is true to autofill text in a different column but I've never done this before.

Specifically, I have a column in a table that is named "Letter Received" and another named "Letter Received Unsigned" which is in date format. I want Access to write "N/A" in the "Letter Received Unsigned" column if there is a date entered in the "Letter Received" column.

View 7 Replies View Related

Queries :: Check For Same Cell Value Access Table?

Jun 19, 2014

I've created a database with entries corresponding to different participants in a tasting experiment. All the entries are stored in a single table. The participants are each members of a family, with participants of a family given a family number (increments with family) (see image link below).

imgur.com/yM1vO59

I want to be able to check that for either 'Mother' or 'Father' of 'Child1','Child2', etc. within the same family, the location within the sweet, sour, bitter column is the same.

(I'm asssuming five queries will have to be run, one for each of the flavours).

To reiterate, I want to check for example if 'Mother' and 'Child1' within 'Family Number' 3 taste 'Bitter' in the same place (Which they do - 'Middle').

View 3 Replies View Related

Click Check Box And Display Value In Text Box In Access

Feb 27, 2013

I have a form that has a remarks textbox. Depending on the options, the form will write something in that textbox. Now I want to have other options (check boxs) that I can click on which will add to that remarks textbox.

Code:

Private Sub Check27_Click()
If Me.Check27 Then
Me.Remarks = ("Shipping Box/Container")
Else
Me.Remarks = ""
End If
End Sub

View 4 Replies View Related

Access VBA Statement To Check For Null Entries

Jan 24, 2012

I've built a form on my Access database that invites a user to enter a start date and an end date into two textboxes. When i press a command button, a parameter query runs which uses the two textboxes as the parameter's criteria. However, to ensure that both textboxes have a data entry, i have tried entering in some VBA that prompts the user to enter in a date if its left null...then set focus to that textbox: Here it is...

If IsNull(Me.txtWeight1) Then MsgBox "You must enter a minimum weight!"
Me.txtWeight1.SetFocus
Else
If IsNull(Me.txtWeight2) Then MsgBox "You must enter a maximum weight!"
Me.txtWeight2.SetFocus
Else
If IsNull(Me.txtWeight1) And IsNull(Me.txtWeight2) Then MsgBox "You must enter a min and max weight!"
End If

This will not compile for me! I've tried with and End If and without an End If and other stuff. Why won't it work?

View 4 Replies View Related

VB Directory Listbox

Apr 13, 2006

Can you use a VB6 directory listbox control on a MS Access form to display the directory structure? If so, how do you do it?

Or is there some other way to display a user selectable directory structure on an Access form?

Thanks
tw

View 2 Replies View Related

TreeView Of Directory

Feb 22, 2006

Hi All,

I've been trying to use TreeView control to display my computer's directories and folders just like Windows Explorer does.

Thanks to Popeye for reposting all the Treeview samples (samples posted before the site was hacked). Most or all of these samples, TreeView is used to display data out of tables. Mr. Ghuson posted a great example for browsing directory but it pops up a separate windows for browsing.

Now I'd like to somehow combine the two into one; browsing thru directories and folders using TreeView Control. Yes that I can browse and save all paths and directories to different tables and add them to the TreeView control but I'm trying to stay away from saving data to tables first.

Can this be accomplished? Can Windows Explorer be somehow embeded on an Access form or called? Any ideas, experts out there?

Thanks all in advance.

View 14 Replies View Related

Get Directory Path

Jul 13, 2006

Anyone got any ideas how to get the directory path where the database is running?
Thx in advance
Bob

View 2 Replies View Related

Need Help Building A Directory.

May 8, 2006

I have made an Access database containing contract names and addresses. I need to have each of these contracts linked to another table which shows the allocated engineer for the particular contract. I used a "one 2 many" relationship using a field "LinkID" to do this. Each engineer has a unique "LinkID" in the engineer table but the engineer changes each day. The engineer for each particular day comes via an excel spreadsheet. The way it works at the moment is that the engineer name has to be manually changed each day, and this takes time. I have tried importing a linked excel table which looked like it would work, but was not able to use the linked table in the same "one 2 many" related table format as above.

What i need to do, is find a way for the fields containing the engineer name to be automatically updated somehow, possible by reading the values from the excel sheet.

Anybody know of any way for this to be done?

Thanks, and hope this makes sense got its got me baffled.


*** Edit **** Thinking about it, i could have an imported execl sheet which contains all of the engineers for each day. Would there be a way using a macro, to update the data in the engineers table that is related to the contracts, by overwriting it with the data from the linked spreadsheet?

View 4 Replies View Related

Get Path (Directory)

Nov 15, 2005

Hi,

In MS Access,

DoCmd.OutputTo acOutputReport, "Appr", acFormatRTF, "P:Appr.rtf", False

I want output the file in the current directory,
the above code is specific the path,
how can I edit the current path, so whereever the the database is either drive, they still can work.

The concept is like that
DoCmd.OutputTo acOutputReport, "Appr", acFormatRTF, currentdirectory:"Appr.rtg", False

Please let me know, thanks.

View 1 Replies View Related

Viewing A Directory

Sep 6, 2006

Hello Access gurus
I hope I am in the right place to start this off
I had D/b all set up but i need to have on my form a view of directory(s)

I have button that creates the folder (many thanks to the person whom gave me this )
but what i want to be able to do is preview this witihn my form

so on my form I want a box that will show what i have stored in this folder (which could be word or pdf or xls)
my button will create C: empfiling filenumber & filename ( about 20 chars)
so my form need to be able to preview all files within this folder ( I hope that I have at least half way explained what I am after
Access 2000 - and reasonable expereince (not brillaint at advance VB )

any thoughts regards

View 4 Replies View Related

Directory Browse

Oct 5, 2006

I have a form where I want to browse for the directory path and display in a text box.I have done something similar to browse for file and display, but this time round I need only the directory path to be displayed .Need help on this.

View 1 Replies View Related

Directory List

Apr 18, 2007

Is there a way to make a directory box, like you can find invisual basic, that you can dynamically search folders for files?
Thanks

View 1 Replies View Related

Directory Search

Jan 25, 2008

I'm hoping someone can help me with this.

I would like to be able to provide a directory search form in my database. This is to enable staff to locate files that they would like to attach to the report they are submitting.

I don't seam to be able to find a control to do this.

We have Access 2000

Any help sample code ect would be appreciated.

Thanks in advance

David

View 1 Replies View Related

Way To Open Directory

Jan 29, 2013

We decrypt about 130 different files into an internal directory by using code that was created in Access 2010. I would like to open that directory with the files that were decrypted for that day so the user can confirm that the process was completed. I use the Shell command throughout the code but I cannot figure out a way to open the directory.

View 1 Replies View Related







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