I would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how?
One more question. Is it posible to based on a login name(form in FE) open a BE readonly or normaly?
I 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?
Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.
I have an Access Db that is not password protected, but is asking for a password. It opens on any other machine fine?
I think my version of Access is playing funny buggers with me, any suggestions?
I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.
Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??
i have found a code that brings up a box when tab or clicking in to a box for editing as below:-
Dim strPassword As String If InputBox("Please enter the password:") <> strPassword Then SomeOtherControl.SetFocus TextBox1.Locked = True End If
its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.
I am useing DoCmd.SendObject to send emails - however I get outlook opening an email with my To, BCC fields filled in , however I am stuck in the new email screen - ie can't get to a previuos email to copy and paste text - like it is dialog?
I have been able to create a form that will send an email automatically when the form is opened. Tha problem is, the email will not actually send until I open Outlook. Any ideas?
i want to send an email to several people when someone else enters a complaint in my database. I have a form which displays the complaint with a reference number, recordsource is "tblKlachten". i have query that is set to return only those emails i want it to send to called "qerMailBeheerder". In there is a field called "email".
Now, whenever i a user closes the form after adding a complaint, i want at the same time a mail sent to those ppl in the query with the subject the reference number of the complaint (field called "Referentienummer") and in the body other information from the fields on the form. Like the field "complaintdecription" and "clientname".
Now, i know about the sendobject thing, but i have tried alot and non would do what i want. Can anybody help me with the code.
Does anyone know what's the best way to send a mdb file via the internet. I've tried sending is as an email attachment and putting is on a webserver for downloading. Both wayes only gives errors.
I have created a database system to book appointments between tutors and students in a school.
In the form, I want tutors to be able to send appointment details to students via email. I have created tables consisting of these details, however I don't know how to set it up for emails to be sent.
I am finding this very difficult especially with the visual basic codes. :confused:
I am using Docmd.sendobject to print a report to Outlook so that I can e-mail the report. The method used to work. Outlook would open, I'd elect my recipients and could click the send button to e-mail the report. Now the send button is disabled once the report shows as an attachment in Outlook. I have to ctrl-alt-del to break the process and outlook gives me an error message regarding the ole object. Is there anyway to fix this problem or a possible root cause. Thank you
I am a little lost here. My prorgam has a form where I added a button. When clicking on the button, it is supposed to use some fields from the form and add them to an email with additional info which is added when the email opens up and is about to be sent. My boss uses Mozilla for his email account. What would be the code on the Onclick event be and do I have to set up anything else??
So far I have this code but it is for Microsoft Office Outlook not for Mozilla:
Set objOutlook = CreateObject("Outlook.Application")
Set ObjOutlookMsg = objOutlook.CreateItem(olMailItem)
With ObjOutlookMsg .To = str_Recipient 'str_Recipient is obtained before this code .Subject = str_Subject 'str_Subject is obtained before this code .Body = str_Body 'str_Body is obtained before this code .readreceiptrequested = lb_ReadReceipt .Display 'to display the message instead of sending it End With
I'm sending an email from a form to Outlook express. But before it opens Outlook I get a question that states "a program is trying to access email address you have stored in Outlook" I then have to click ok and then another window opens and askes the same question. How can I eliminate these warning messages?? Thank You
So far I know there is a wizard for being able to create a button that sends a Form Report. What I really want to do though is when the user clicks the button on the form, just the form is sent/attached to the email, effectively giving the viewer/receiver a screenshot of the Form in question.
I have looked through the forums for an answer to a problem I am having, but I can't seem to find the complete answer.
I just started work on an inventory database that was made by other people; it is a fairly large database. One of the forms is for equipment maintenance and in it, you fill out several fields. What needs to be done is an email sent out to 2 people in the department; they are selected via a combo box and this runs a query that fills in a table with the proper email addresses and matches it to the proper job in the table. A due date is inputted in a standard text box. The emails are then supposed to be sent out on the due date provided.
For some reason, there is no code at all (that I can find) that even runs Outlook, although it supposedly worked a while back. I have read that timers would help with this, but I am not quite sure where to go with it. Also, does the email have to be sent from the person that is logged into Outlook at the time the email is sent, or can it be sent under another email address no matter who is logged into Outlook at the time.
Hello, I am just starting to use the sendobject action in Visual Basic in order to send e-mails that contain information of tables. The e-mail is sent when a button is clicked by the user of the database. However, I noticed that the e-mail is sent away via Outlook (which is fine) and the person who gets it gets the e-mail from the person who clicked the button (which is logical). However, Outlook has the option of changing the from part so the person who gets the e-mail receives it as if it was from a different sender. The thing is that I want people who receive the e-mail to get it as if it was sent from the group account and not from the individual who actually clicked the "send e-mail button." The Visual Basic Help said: Syntax DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
However, there is not an option for a default "[, from]" as there is for "[, to]" or "[, cc]" Is there a way I can make a default sender even though individual people are the ones sending the e-mail by clicking the button? Thanks.
I have two tables in MS access, both are same but diffrent name like DataTable and DatatabelHistory,
what i have done is develop a form of DataTable and now want that the data entered in the textboxes of this form should copy/transfer to other table (DatatableHistory) by update event or some other event
But if I download these files and look at them they are only partly there - sometimes the titles are gone, sometimes the scales, sometimes the data. It's very inconsistant.
Since the files are created ok and are viewable on my pc I think this part is ok. So I'm guessing that something goes wrong during the ftp upload though I can't imagine what - the files are quite small and surely ftp doesn't care what's in a file - it just sends it?
I have a DB that runs on a user's pc. It creates a pdf from a report automatically at a specific time of day. The user now wants me to automatically send this pdf to his web site so that his customers can view the report over the internet. The pc that the db runs on has an internet connection but no email system (they do not want email on this pc).
I have not been able to find code to do this. I can find code for sending email but this is not what I want to do. I'm sure it must be possible but I've never done anything like this before.