Search results

Anyone has got any ideas how to tackle this?????????? Thanks

Hi Paul, Thank for you time. The form is designed to display results from my search query (name: AircraftSearch). It has 8 text boxes one combo box used only to display info from the query. It is a continuous form and it display multiple search results. One of the text boxes contains a...

Is any of this code would be helpful to solve it: Dim strSql Dim db As Database Set db = CurrentDb() Dim rs As Recordset Dim Lrs As DAO.Recordset Dim Outlook strSql = "SELECT primaryemail FROM tblGoldMine WHERE pipeline=-1;" Set Lrs = db.OpenRecordset(strSql) Do While Not Lrs.EOF Outlook =...

Paul, Do you think is possible to place a check box that is bound to the source of e-mail address info (in my case, table: AircraftOperators, field: EmailToOperator) and use to find a match in the undying table. Then have those matches embedded into Outlook BBC field? thanks

Hi Paul, Thanks for a quick answer. I'm really new to Access and I do not have a clue how to tackle this. Would you be so kind an guide me through the steps needed to resolve the issue? Thanks pabloUSA

Hi, I really need an urgent help. I have got a form (name: SearchForm) that displays results of a query (name: AircraftSearch). It is a continuous form displaying multiple results of a search done by the query. I need to be able to send an e-mail to multiple recipients chosen from...

I've been searching through forum's posts and didn't find (or missed it) anything that could be directly applicable to my situation. I found this code for report generated from dynamic query: Dim strDocname as String Dim Criteria as String Dim i as Variant strDocname="myReportName" If...

OK. Thanks for info. Although my coding skills are quite poor I'm always up for a challenge. Could you please let me know if I have to start the entire query all over again or I can build up on stuff that I already have (e.g. in other words, I have to delete the entire query and start building a...

Hi, Could anyone please help me to modify my query to accept parameters from a multiple choice list box. This is the SQL code behind my search query: SELECT AircraftOperators.RegistrationNumber, AircraftOperators.PassengersNumber, AircraftOperators.ManufactureYear...

Hi guys, I'm absolutely new to Access and I'm trying to build an database for aircraft operators. I've got the basic tables structure and relationships but I'm stuck on building an search form to filter records by user input. I've got following controls on my form (unbound): 1. AircraftType...

Hi guys, I'm absolutely new to Access and I'm trying to build an database for aircraft operators. I've got the basic tables structure and relationships but I'm stuck on building an search form to filter records by user input. I've got following controls on my form (unbound): 1. AircraftType...

Hi guys. I'm completely new to Access and I'm currently forking on aircraft operators database.