Search results

I have a table that has four columns. Column 1 had people's names, column 2 has their email, 3 has a category, and 4 has their office. I have a form with radio buttons, When you check a radio button and press OK it will display the e-mails for the people selected. Problem comes when it's by...

I'm nearly done creating an application on Access. After I'm completely done it will be put in a shared folder and everyone where I work will have access to it. I want them to be able to use the forms and view the reports and such, but I don't want them to be able to modify the codes or queries...

It's right in the code I posted, If Me!chkAGDLLA = True Then Forms!email.lstName = Null Forms!email.chkComercial = False Forms!email.chkOperacional = False strAGDLLA = "email1, email2, email3, email4" strMail = strAGDLLA & ", " & strISA & ", " & strMAYA & ", " & strSANGER & "," & strSANSE &...

When a checkbox is true I designated it to have a string in which I entered the emails manually. A check box is an office, and each office has several people, therefore when I check the checkbox for that office, it will send the email to everyone in that office.

I have 8 checkboxes. Each checkbox has several e-mail addresses as string. Therefore, each checkbox has a string variable declared. I was wondering what should I do when selecting multiple check boxes. This is my code: If Me!chkAGDLLA = True Then Forms!email.lstName = Null...

How do I incorporate this? I tried using a .Fields(2), which seemed to work with other things, without success.

Hello! I need help with this: I want to use an array to store data from a list box into a variable. I want it to be able to store one value, or multiple values, depending on what is selected. Main problem: this list box feeds off a table which has employee names and their e-mails. The list box...

The list box has the names of the people I can choose to send emails to, and from there I select. Yes, I want one e-mail with attachment sent to multiple recipients. This query selects the name of the person and the email address from a bigger table. So no, it doesn't select exclusively the...

I have this code that I want to work the following way: I have a list box, and I want the code to loop through the records, and populate the "send to" area of the e-mail. Private Sub Command39_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As...

Okay, I have one table that has the fields ID, Name, Email, Office & Category From this I made three listboxes from which I can choose people to send the emails to. The one in the code is from a listbox that contains everyone's name, and you select from there and send the email. I have...

I replaced it and it seems to be working! Thank you! (Don't have a lotus account so not 100% sure) Do I have to code something else if I wanted the program to login automatically, or would it do that after I log in for the first time? Edit: I have three listboxes. How could I validate so...

I have this code that should loop through a query and populate the "Send To" field based on selected values in list boxes: Private Sub Command39_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As String Dim sMessageBody As String Set MyDb =...

Can I do this on the Load part of the report? Won't my email form take over the focus? Thanks!! Edit: Scratch that, if I can, I'd like to make it set the focus when I click the email button. Also, I have no idea how to set focus to something (noob here!)

I have created a form that will print the active report. I have managed to make it look for the active report, but it won't find it because there's no report active, even though I have the report open. How do I make my report be active when I open it? (In a way that whichever report I open...

Because that means that for every report I have of this (5) I'd have to create 3 sub reports. One for all the data, one for null data, and one for all - null data, making it 15 different reports. Edit: did the whole "OpenArgs" thing to use my already existing reports for this while using...

This is actually the first format I tried :/ Could it be that PN isn't on the report itself, but it's in the query the report feeds off of?

Had tried that already, no luck.

Thanks for your input; however, what about in the case where I need three criteria instead of two? Like this one: DoCmd.OpenReport "rptPrecintosMAYA", acViewReport, , "[Username]='" & Me.[Username] & "' AND [Order Type]='" & Me.[Order Type] & "' AND [PN] is not null & " '" Got a runtime...

I want a code like this: DoCmd.OpenReport "rptPrecintosAGDLLA", acViewReport, , "[Username]='" & Me.[Username] & "'" But after the "Me.[Username]" part, I want it to also filter to only show me data that has null values on a column called "PN". Alternatively, I also need a code that...

I wish you'd posted this 3 hours sooner! After a long time researching I figured this out and it did in fact work. Thanks, regardless! :D