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...

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...

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...

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...

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 =...

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...

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 want this query to count all of the different types of order (Clase de Orden) and if a type of order isn't found, to return zero. How do I do this using IsError, since when it doesn't find an order, it gives me an error. This is the query: TRANSFORM Count([E 025].Porción) AS CountOfPorción...

So I am working on this database and it has to do with orders. There are about 15 different types of orders. We download data daily, and replace the source of our Access data from Excel as we download it every day. Problem is, some days we have all 15 types of orders, some days we don't have...

Is this even possible? Let me talk you through this scenario. I have three tables. TableA contains certain order information, such as the username of the employee, type of order, alias number, etc. TableB contains phone numbers, username of the employee, etc. TableC contains supervisor...