Search results

Function AutoEmail(MySQL As String) Dim objOutlook As Outlook.Application Dim objEmailItem As MailItem Dim rs As DAO.Recordset Dim rssent As DAO.Recordset Dim Reccount As Long Dim i As Integer Dim SID As String Set rs = CurrentDb.OpenRecordset(MySQL) 'count the Records Reccount =...

i have tested the db many time, it working well, but when i convert it to .accde it will not work.

I have an option in my DB to send an Email, and the project display the Email before I send it. in the original file (.accdb), the function is works well, but when I save the project as ( .accde) the function does not work ( the project will not display the Email). Thanks

thanks for All, I have used @CJ_London solution, On the (On Open) event of the report you can set the order in this way [Private Sub Report_Open(Cancel As Integer) Dim sort As Variant sort = Forms!frm_name.combo_name.Value If sort <> 0 Then Me.OrderBy = sort Else...

Hi; I have a form that has a few parameters on it, and it has a button to open report; I want to add a combo box on the form (cmbsort) to allow end user sort the data on the report based on the combo box value. Thank you

Thank you @Pat Hartman, you've described the perfect solution. Since I'm not a programmer 🥲, I thought that if I connect the parameter inside query in "Criteria" OR by writing VBA code inside the form, I will got the same results.

It's very important to display the query result on "Form Detail", because I need to select some of the students (from the query result) to send an Email for them

Thank you @Pat Hartman; I have tried your solution, but the query results will not be displayed on the form detail; I attached a picture from the database, it may help to explain my post.

Thank you @jdraw, I knows how to set a parameter in query, but I want to run the query ( after entering the parameters) and to show the results in the form detail

Hi, I want to enter a parameters (ex. date range), then to click on a command "Execute Query" (All of them are available on form header) to run a query on a form detail. kindly see attached Pic. Thank you

I really appreciate your efforts, fantastic.

@arnelgp ; @MajP Now, how I can send an Email for the selected employees. I want to put all of them in field "To".

@MajP you did a great jo, but the "Add All" Not working all the time. :)

Thank you arnelgp, your sample is what I asked about.

Thank you for your response; The Email address is already available in the data, any way, I attached a small video from the database

Hi; I am trying to add a checkbox on a continuous form in order to select "employees" that I will send an Email to them. the data (on the continuous form) comes from query, now if I checked or unchecked the checkbox on the form detail, all of them will have the same behavior. I don't want to...

this will be manual

Thank you, i do not need to manage the booking, i want to manage the items in the rooms

The Receptionist will enter the data, and i do not want to manage the booking issue

thanks for all your support, i would to describe my objective of this project; i have 3 buildings each building contains floors and each floor contains rooms each room contains beds (from 1 bed upto 6 beds). When reserving a bed for a guest, a set of materials becomes in his custody...