Drive Verification OnOpen

Oct 19, 2005

Is there a way to verify the drive that an FE is opening from and then close if it is not where is should be?

I have a frontend that gets copied to each users C: drive by a .bat file. However, some just don't care about rules and proceedures and continue to open the frontend on the network drive. Since they map their drive to a specific letter drive for the BE that is where they are opening the FE from.

Thanks
Rich

View Replies


ADVERTISEMENT

Modules & VBA :: Temporarily Map A Drive / Copy A File Then Remove Mapped Drive

Aug 29, 2014

My workaround was to temporarily map the URL to a vacant drive letter on the local machine, then copy the file over, then drop the mapped drive again. A bit clunky but doesn't incorporate much of a delay and this download only has to happen once per day.

The good news is, the file download / copy now works every time. The bad news is that removing the temporarily mapped drive after the copy has taken place, doesn't and I can't figure out why.

Here are the functions I use to map / unmap the drive :

Code:

Option Compare Database
Option Explicit

Private Const RESOURCETYPE_ANY = &H0&
Private Const CONNECT_UPDATE_PROFILE = &H1&
Private Const RESOURCE_CONNECTED As Long = &H1&

[Code] .....

I have separate functions to check existing drive mappings on the local machine and thus determine an appropriate vacant letter to use for the temporary mapping - they work fine.

Unfortunately the UnMapDrive function returns False (even though I switch the active drive to C: and force the connection to be cancelled with the fForce flag) So the mapping always remains on the users profile.

I don't want to permanently map drives on the users' profiles, just briefly for the purposes of this daily file download.

View 11 Replies View Related

Address Verification

Feb 4, 2005

any one have experience with address verification in access through the US postal service? any good resources? Examples?

View 3 Replies View Related

Entering Data Twice For Verification

Feb 21, 2006

I have a db with the following fields: ID, Customer first name, customer last name, account number, date, time, score1, score 2.

My problem is this: We are running a promotion in which the customers receive a score. This score must be entered correctly as we are highly regulated, however the users are constantly fat fingering or miss typing the data. I want to force the score 1 and score 2 fields to match before the record can be saved.

Any suggestions on this would be greatly appreciated; I have to go in every night to correct these errors manually, which defeats the purpose of this db.

View 14 Replies View Related

MS Access Verification With Form Help

Feb 12, 2008

Hi I have a form that I would like to check an MS database (.mdb) to verify the user exists in a field before allowing the form to go through. If the field doesn’t exist, is there a way to have the form redirect to a certain page? ..Also I noticed within the database, there are different categories within, does that make a difference with the coding?

Any help is greatly appreciated, thank you!


Form:

<html>
<head>
<script type="text/javascript">
//<![CDATA[
function processForm(f) {
f._recipients.value = f.Email.value;
}
//]]>
</script>
</head>

<form action="formmail.asp" method="post">
<input name="_recipients" type="hidden" value="" />
<input name="_replyToField" type="hidden" value="email@email.com" />
<input name="_requiredFields" type="hidden" value="Name,Email" />
<input name="_fieldOrder" type="hidden" value="info1,info2" />
<input name="_subject" type="hidden" value="Your confirmation Email.." />
<input type="hidden" name="info1" value="Info...">
<input type="hidden" name="info2" value="Info 2...">
<input name="_redirect" type="hidden" value="post-enter.htm" />
<input name="Name" type="text" size="28" />
<input name="Email" type="text" size="28" />
<input class="button" type="submit" value="Submit" onclick="return processForm(this.form)" />&nbsp;
<input class="button" type="reset" value="Clear" /></th>

</body>
</html>

View 1 Replies View Related

Bypass The OnOpen

Jan 24, 2006

Hi all...

I have a form that OnOpen does;

DoCmd.GoToRecord , , acNewRec

But, I also call it from another form, using a criteria, but because of the OnOpen event within the form it goes to a new record.

I need to be able to bypass the OnOpen event or find a different way of opening the form to goto a new record...

Please help!

Simon

View 1 Replies View Related

OnOpen Error With Replicated Database

Apr 15, 2008

I have a replicated databse that is used in both 2003 and 2007. Most development is done in 2003. I have stability problems with replicated/synchronised databases when running in 2007. The database normally opens with a switchboard menu, but on occassions the following error occurs:-
"THE EXPRESSION ON OPEN YOU ENTERED AS THE EVENT PROPERTY SETTING PRODUCED THE FOLLOWING ERROR: OBJECT OR CLASS DOES NOT SUPPORT SET OF EVENTS". Once this happens the databse will not open. I have to create a new replica which may or may not work. The strange thing is that I can run the database failing in 2007 from another rmachine that is running 2003, so it seems that the problem is specfic running 2007. Any suggestions or help would be appreciated.

View 2 Replies View Related

Forms :: Verification Rule Based On Data In Another Field

Mar 5, 2015

I want to set a rule where employees cannot change the "Status" from "Active" to "Closed" if there is no date entered in the "Actual Closure Date" field.

The 2 fields I am trying to create a rule for are called 'Actual Closure Date' and 'Status'.When we raise an incident the 'Status' is set to 'Active' and the 'Actual Closure Date' field is left blank as it hasn't yet been closed.What I want to do is prevent people setting the 'Status' to 'Closed' when they havent entered a date in the 'Actual Closure Date' field.The Form name is called 'Issue Details' and the information is stored in a table called 'Issues'.

View 4 Replies View Related

Modules & VBA :: Error When Executing OnOpen Report?

Sep 8, 2013

I am using ACCESS 2010, win 7 Home Premium 64bit

difficult to handle error when executing my report. I put a code into OnOpen section but ACCESS states:

Quote:

The expression OnOpen you entered as the event property produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.

Additionally it says in description:

This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs.

I am genuinely confused by that. I have also provided the code in the case if I am missing something I don't know yet. In a debug window, I have executed the code line by line and it worked. Whenever I try to open the report, the error occurs. Should I be aware of something when I write code for reports?

Below, the code in my report "module":

Code:
Private Sub Report_Open(Cancel As Integer)
Call CreateTempTable
End Sub
Private Sub CreateTempTable()
On Error GoTo ErrorHandler
Dim strTable As String

[code]....

View 3 Replies View Related

OnOpen Form Event Filter A Combo Box In Subform

Jan 18, 2006

On clicking a button to open a form I want to filter a list in a combo Box located on the forms subform

The main form is called 'Frm_orders'
The sub form is called 'sub'
The combo box field is called 'CostCodeID'
and I want to filter column 0 of the combobox which is Tbl_InvoiceCostCodes.Type to show records with a type of 'Repairs'

View 2 Replies View Related

Change Recordsource Of Subfrm To Another Saved Query OnOpen

Aug 18, 2006

How do i make my subfrm record source switch to another saved query (qryPendingStatus) when it's opened from the form.

Heres what i am trying to accomplish:
I have a subfrm that i'd like to use to display info in 2 different forms.

There's a form currently for All statuses. Then another new one for Pending status. I'd like to use the same subform for this pending status form also, and in doing that my qryAllStatuses, but change to qryPendingStatus on the subfrm when i open the mainfrom.

This is on the open even ofthe mainform, but does not work (says method not founds...so obviouly i can't use ".Recordsource" here:
Private Sub Form_Open(Cancel As Integer)
Me.subfrmJobInfo.RecordSource = "qryPendingStatus"
End Sub

How can i make this happen?

View 3 Replies View Related

Thumb Drive

Jul 8, 2005

Does anyone know if I could put the runtime and an mdb on a thumb drive and run it from anywhere? Or does install stuff have to happen... :confused:

View 1 Replies View Related

Shared Drive

Oct 23, 2007

Hello,

I have an exrternal shared drive "E:"where I put my be files (which are constantly accessed by users with fe's from different terminals). Everytime
I reboot the computer that I am working on (where the external drive is), I have to set up the permissions of the shared drive "E:" all over again, otherwise other computers have no access to E. Is there a way that I could
fix this and not having to set permissions every time I reboot my computer?
For some reason, the permissions are lost.

View 4 Replies View Related

DB On Network Drive?

Jan 3, 2008

I have a db on a network drive and the performance is terrible, it runs fine on my local machine. How can I make it run better? The db is only 2 megs so I figured it would be ok, but since my forms have numerous queries within them, performance stinks.

View 13 Replies View Related

Drive List

Jun 21, 2005

Hi,

Does anyone know if Access has a built-in control that allows users to scan the directory structure of their PC? Similar to the DriveListBox and DirListBox controls in VB6? If so, how might I get access to it?

Thanks

Davemere

View 4 Replies View Related

How To Execute Query From C Drive ?

Sep 27, 2005

Can I keep my queries in the C drive and execute it against tables that are in the LAN network drive ? Right now the queries are also in the netowrk drive. So each time when I refresh the data into C drive, I have to import the queries too.

Is it possible to keep the queries in the C drive and execute against data in the netowrk ? Please let me know.

Thanks in advance.

View 9 Replies View Related

Different Paths For Shared Drive

Feb 2, 2006

Hello all:

I have the following code to retrieve doucments:

strPath = "G:CorpCustomer Files"

Application.FollowHyperlink strPath & "" & textbox1 & "-" & textbox2 & ".doc"

This works fine from my computer because the shared drive on my computer is saved on the G drive.

I tried using the code from a coworker's computer, but got an error because her shared drive is : "X:CorpCustomer Files"

Basically anyone can access the Corp server through any drive depends on how it was mapped.

How do I get around this so that it works from any computer as long as the user has the Corp share drive?

Thanks much.

View 5 Replies View Related

Link To A PDF File In Another Drive

Feb 8, 2006

What I have is a bunch of files located in another Drive (PDF). I would like to link to them by id number from access.

Is this possible?

View 4 Replies View Related

Copy From A Drive To A Folder

Feb 27, 2006

Hi.
I have been searching previous threads and the help file and got half way, but have got stuck.

I want to copy all files from a floppy disk to a drive on a directory on a server. I can check to make sure the directory exists and if not, can make it. All I want to do is copy all the files from the floppy disk drive (A drive) to the direcory I have just created.

I got this from the help in access:-

FileSystemObject.CopyFolder "c:mydocumentsletters*", "c: empfolder"

but can't get it to work......is this the way I want to go?

Can anyone help?

Thanks.

Frank.

View 3 Replies View Related

Modules & VBA :: Getting A Drive Letter?

Aug 19, 2014

I have an MS Access database that sits in the users local area e.g. C:Users....

I have the following code which will open a user guide on a server shared by all users.

Code:
strFilename = GetUNCPath("T:") & "19_InformaticsInternal Offer Transfers" & "Utility User Guide.doc"

Users have different drive letters for the server name. In my case it's "T:" but for others it may be"S:".

Is there any code which would determine what drive letter each user has? The server name is

denasvf1acorpHR_GLOBAL_1HR_Shared_Service_Data

View 3 Replies View Related

Max Users On A Network Drive

Oct 23, 2014

I was just wondering how many users Access would be able to handle on a split frontend and backend database? The backend will be on a network drive and the frontend will be installed on each workstation. My database is pretty simple with no relationships if that matters. Also using Win7 and some users will have Office 2010 and others will have 2013.

View 2 Replies View Related

Mapped Drive Converted To UNC Is Slower

Nov 23, 2005

I have my database connected to a network of ten computers. I recently switched my linked tables from a Mapped Network Drive to using the actual UNC path \computerfolderdatabase.mdb

My users have started to notice it takes longer for the database to connect in order to log in. Once they have established the connection, the data transfer speed seems to be normal.

Is this to be expected? Any suggestions to speed things up for login? Or is this the downside to using UNC?

~Scott

View 2 Replies View Related

Runtime Access97 On Thumb Drive?

Dec 2, 2005

does anyone know if it's possible to "install" the runtime version of access 97 (we do have developer's edition, so can distribute the run-time version) to a thumb drive so that it would run without having to install it on each computer that one was going to use the thumb drive on - is there any add'l software that would make this possible/ - the application is for figure skating clubs - with distribution of up to 1000 copies - the idea is to distribute them to member clubs and various officers could use the application and exchange up-to-date data by passing on the thumb drive - this also would hpefully avoid all installation problems with pc's having various versions of access already installed, etc. - thanks for any suggestions- jim

View 6 Replies View Related

Unique Hard Drive Serial

Dec 8, 2005

I have seen some API that gets the serial of the hard drive, but this information is not unique and changes when the volume is formated.
Does any one know of a way to return the orignal manufucture's information/serial which is unique(GUID) to the volume.
Any Idea will be highly appreciated.

View 6 Replies View Related

DB Security On A Shared Networked Drive

Jan 31, 2006

I've created a database on put it on a shared network drive. I have several people who will need to use this database but I dont want some of them to be able to edit the database in anyway.

Ive tried creating individual user accounts for the database but I don't think I'm grasping how the security works.

When on my machine I'm promted for a username and password but when on someone elses machine they can open up the database with full access.

How do i create individual user security accounts on a database I want to share on a network drive?

View 4 Replies View Related

Database On Network Drive Won't Open

Oct 24, 2006

I was using the database when there was a network error and I had to close it. When I tried to reopen it I got the error message: Record(s) cannot be read; no read permission on 'MSysAccessObjects'. I logged off the PC and logged back on various others, but keep getting the same message. Can anyone tell me if this is terminal or is there a way around it. I do have a backup, but it's a few days old and a lot of work will need re-entering' so any help would be appreciated!!

View 1 Replies View Related







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