Modules & VBA :: Popup Message Box Asking For Password / When Changing File Extension?
Jan 5, 2014Is there and possiblity to have a pop up message box asking for password when changing file extension from accdr to accdb ?
View Replies
ADVERTISEMENT
General :: Follow Hyperlink To A File Without Using File Extension?
Sep 6, 2012Is it possible to follow a hyperlink to a file without using a file extension?
I have links being created based on the name of a file, but because I haven't used a file extension it crashes.
I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.
I'm potentially using 3 different file types, Word, Excel and PDF's.
The hyperlink works if I just reference a drive/folder, or if I add the file extension.
Not Prompted For Password When Relinking - 'Not A Valid Password Message'
Mar 29, 2007I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'
I must obviously be doing something wrong, can anyone help?
File Extension And Hyperlinks
Mar 11, 2007Hi Everyone
I have just solved one problem concerning creating hyperlinks based on values in other fields: See Previous Thread (http://www.access-programmers.co.uk/forums/showthread.php?t=124590)
but now I have another, the hyperlink I have created links to a document, while for the majority of time it is a word document it is not always, occasionally .xls or .pdf
So I need a way of building into the hyperlink code the file extension, my thoughts are it would involve check boxes and if statements (one check box for each) but I am unsure of how to do this, can anyone help?
My code is currently:
Private Sub H_Enter()
Form!H = "hyperlink#C:Documents and Settingscew1My DocumentsWORKSpecs" & Form!S & Form!PC & ".doc#"
End Sub
General :: Ade File Extension
Oct 13, 2013I have an old program with ade file extension and I would like to add some filters in one of the forms but I don't have design view or layout view option.
View 5 Replies View RelatedModules & VBA :: Detecting Excel File Is Password Protected
Apr 4, 2014Any VBA code that would tell me whether an xlsb file is password protected?
View 5 Replies View RelatedNewbie Question - File Extension For The Form?
Dec 11, 2006Hello. I have a mdb access file. When I open it, I can see lots of tables. How on earth do I open a form? Do I need another file, if so, what extension should I look for on my computer?? I really dont want to create a new form, since a person who did it has told me that its all have been already done. I just need to open the form and enter the data in. Thanks for any help!!!:)
View 1 Replies View RelatedGeneral :: Access Production File Extension?
Jun 10, 2013I want to release an Access program to the production environment for users. I remember there being a file extention that can be used so the users cannot access the DB or Code.
View 2 Replies View RelatedForms :: Popup Subform - Password Protect Individual Records
Jul 23, 2014So I created a new form that multiple coworkers will have access to. I understand that you can password protect an entire data base, but I was wondering if you could go deeper than that. I have a main form with a combo box (query to show existing IDs) for "ClientID" that links the main form and subform (Its controlsource is ClientID from the table the subform was created off of). If a user selects an existing ClientID, the linked subform pops up with the selected ClientID displayed on the subform in a field along with existing additional information displayed. If The user types in an ID not in the database, a blank subform comes up for the coworker to create this new record and the field for ClientID is blank.
1) How can I make it so that when a coworker types in a ClientID in the combobox that is not in the database, the blank subform that pops up has the ClientID field filled out with what was typed in the main form.
2) Situation: Adding a new client to the main form, and filling out the additional in on the popup subform. I want there to be a field on the main form for "worker". The worker will put their ID and create a new client record. Is it possible to make it only possible for this worker to edit this client record in the future? ...the original creator will be the only one able to edit the information.
-I am thinking maybe have a table with all workers and associated passwords. So, if a user tries to open a subform created by another worker, he will be prompted to enter a password (which will be the one associated to the creator in this "secret" table.
Forms :: Message Popup 30 Minutes After Checkbox Event?
Jul 18, 2014I would like to have a message box popup 30 minutes after a user checks a checkbox (check5). I am thinking I would have to have VBA code to run on the After Update property of the checkbox but not sure what the correct code would be.
View 3 Replies View RelatedHow To Make Alert Or Popup Message Using Access 2007
Sep 18, 2012I want to make alert message that will be pop up when the return date for borrowing book is one day before the date. and the alert message will also can show the information about the borrower.
the alert message will be something like this. Tomorrow one borrower need to return the book. click ok to view the data.
Can access 2007 do this kind of alert message..?
Modules & VBA :: Zip Code Not Importing With Extension
Jun 27, 2014I have a pretty basic TransferSpreadsheet module that works well except that if the Zip code has the four digit extension, it's not importing.
Option Compare Database
Dim myCheck
Function MeridianLinkFileImport()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_MeridianLinkFileImport", "R:DEPT-BRCONSUMER LENDINGMarketing Campaigns2014 Auto Loan PrescreenReport from LoansPQ.xls", True, "Sheet1!A3:AO50000"
End Function
If there is no extention, it is importing fine... 85086 works fine but 85018-4710 doesn't import.
The field is a Short Text data type.
General :: Payment Database - Monthly / Annual Renewal Popup Message
Mar 20, 2013I am creating payment database for a community gym, the data will be created on a data sheet.
There are 2 payment types monthly and annual (these are on a dropdown box with their own id number).
I have a joining date and a paid date, but reflected against the payment type ie 31 days or 365 days.
I have been trying to do something along the lines of:
if [monthly] (is selected) (so this would call up a 31days) date() is > [joining date] then give message to renew and same kinda thing for annual.
Forms :: Option Group To Select Subforms To Be Displayed - Popup Message
Aug 23, 2014I have a form with an option group to select subforms to be displayed .To save space on the main form I have added a subform (frmSubService) to the option group to display some of the data that was originally on the main form. The subforms data source is the same as that of the main form but only displays five fields.
After editing data in the subform frmSubService, if I then click on a field on the main form no problem, however if I click on an option button to view another subform I get a messagebox pop up with the following message;
The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.
If I click OK,and without re-editing the record, I can open another subform.
I have checked and the data changes made on frmSubService, in both cases, has been saved.
How do I prevent the pop-up message?
Changing A Password
Aug 1, 2007I have set a password on my access document but now need to change it - does anyone know how to do this?
View 1 Replies View RelatedChanging The Password
Apr 13, 2008i am doing a computing project using access 2003 and vba.
i have designed 2 forms A and B, form A is where a user to logs in to my system (with four main items: username (combo box), password (textbox) and two buttons) and form B is where the user can change their password (with four items: username (username (combo box), new password (textbox) and password verify (textbox) and a button that checks everything and updates the password).
Form A has two buttons, one button can log the user into the system after typing in their correct username and password credentials, and the other button gives the option to change their password also after typing in their correct username and password credentials (and the opens up form B for the user to change their password)
My question is, when the user presses the button to open up form B, what code could i use (or methods in access) that would set the username field (in form B) the same as in form A automatically without the user having to select it again?
All help would be much appreciated
Relink Backend File Using VBA With Password Protected File
Nov 5, 2013I have a code to relink a 2 backend files at start up. The problem is one of the files is password encrypted.
Code to input the password?
Dim dbsTemp As Database
Dim strMenu As String
Dim strInput As String
' Open a Microsoft Jet database to which you will link
' a table.
Set dbsTemp = CurrentDb
[Code] .....
This part is calling the password protected database
Code:
ConnectOutput dbsTemp, _
"Usernames", _
";DATABASE=C:UsersquicoDesktopWeight_estimate_software_Usernames.accdb", _
"Usernames"
Forms :: Changing The Password In The Table From A Form
May 9, 2013I have a login button in which if the username has an empty password or the user is his/her first time to login, another form will appear which is the Set New Password. How can I change the password of that current user, my Set New Password Form has two fields which is 'txtSetPassword1' and 'txtSetPassword2' and an OK button.
The user must enter a new password and a verification password, if the 2 fields matched, the new password entered will change the password in the table. The table name is 'tbl_UsernamesQry'.
I have done it but the main problem is, it changes the other's users password not the current user.
Here is my code for the OK button of that form Set New Password:
Private Sub btnSetOk_Click()
If Me.txtSetPassword1.Value = Me.txtSetPassword2.Value Then
Me.txtSetPassword1.SetFocus
[Code].....
Changing The Primary Key Error Message
Mar 12, 2006hello
is it possible to change the default primary key error message that appears when a duplication of the primary key is made in a form?? in other words how can i make those error messages more user friendly??
thank you :)
Changing The Title On Error Message Box
May 5, 2006I saw the solution to this on this forum a while back but no matter what I search under I cant seem to find it again!
Can someone remind me how to change the Title of the error message boxes I can change the error message - by changing the Err.Description - but how do you replace the 'Microsoft Office Access' with your own Title?
I am running Access 2003 on XP.
Changing Required Error Message
Oct 11, 2005Hi its me again.
i have an other table issue.
I have some required fields.
When a user fills in a form, i and forgets a required field, an error pops up. But i want to change what the error says. I tried getting it by using validationrules. but i can't reach it. The access message overrules mine.
Forms :: Popup Window To Save File At Any Location
Feb 23, 2014I find the following CODE online (Print to PDF). Which work perfectly for me, the only issue and/or modification I am looking for "Popup Window to save the file at any location", instead at fixed location.
Option Compare Database
Option Explicit
Function PrintToPDF(SrcFile As String)
On Error GoTo PrintToPDF_Err
'Function can be called from any report with this: "PrintToPDF(Screen.ActiveForm.Name)"
[Code] ....
Forms :: Password Validation - Message Pop Up With Specific Error User Has Made On Entry
Jan 6, 2014I am looking at the public function routine, that validates the password entry. I want to know how i can make a message pop up with the specific error the user has made on entry.
Public Function ValidatePwd(varPassword As Variant) As Boolean
Dim blnValid As Boolean
Dim blnValidCriteria As Boolean
Dim intChar As Integer
blnValid = Len("" & varPassword) >= 4 And Len("" & varPassword) <= 12
[Code] ....
MDE File - Set Password For Table?
Jul 25, 2012I created file .mde
How I can set password for table????
ODBC File DSN Connection No Password Required ?
May 23, 2007Hi, I have created a File DSN using my ODBC under Admin Tools and placed it on the network and have linked my Access 2003 tables to point at this.
I have asked a non-domain user to log into this database and open a table but when they do, it defaults to a Domain account until you untick trusted Source. You then have to enter the username and password for the ODBC connection. I thought the whole point of a File DSN was to eradicate the process of logging in. Can anyone Help?? Thanks
This is what the ODBC looks like through text editing software.:eek:
[ODBC]
DRIVER=SQL Server
UID=MyUserAccountName
LANGUAGE=us_english
DATABASE=MyDatabaseName
WSID=MyWorkstationName
APP=Microsoft Data Access Components
SERVER=MyServerName
Description=MyDescription
Multiple ID And Password Prompts On ISeries Linked File
Jan 9, 2014I am trying to print a report from access based on a linked file from an iSeries. I am prompted several times for an ID and password.
View 1 Replies View Related