Search results

Hello On 03-25-2017 sneuberg gently helped me with above code. With this code I export a query to excel. If for example I search by day1 20_02_2018 and day2 20_02_2018 the code assign the exported file name as 20_02_2018_qry_01. I need the code to include in the exported file name the plot...

Minty I enclose the forms displaying 5 charts and one image. The charts are displaying by the combo box. The image is displayed using the built-in navigation buttons. I am looking for that the combo box value will display charts an images.:banghead: Many thanks

I enclose an image

Minty. Many thanks for your reply. My combo already displays the 5 charts, however, I have been unable to displays the 3 images at a time. I Tried with no success. [Private Sub mycbx_Change() Me.Image5.Picture = Me.mycbx.Column(2) End Sub] [Private Sub Form_Load() Me.Image5.Picture =...

Hello In Access 2013, I have a combobox that when selecting a value displays 5 charts, each chart based on query. I need in the same combo box that when selecting a value displays 5 charts and a unique image displayed for each value:banghead:. See example Each image is different and has a...

Hello. The code Works as expected.:) Thank you very much indeed.

In an MS Access Form I have 3 txtboxes to export querys to Excel txtboxd. User picks a day from ms access calendar as dd/mm/yyyy txtboxw. User enters week number as ww, yyyy txtboxm. User enters month, year (mmm, year) If user picks in textboxd 23_03_2017 I have a cmb with code to export query...

Brian and colleage. I apologize por delay in replying you. I was at field work. :confused:I tested the module and the Function, however I have a cmd button for the search. Private Sub Comando7_Click() If DCount("*", "q2") = 0 Then MsgBox "No records Found.Try again" Else DoCmd.OpenForm "Frm1"...

Access 2010 In the text box I need to write at least 4 words separated by AND to search in a field. Could be possible? Many thanks :banghead:

Very interesting. I got more ideas for my database. Thanks very much In my case I need to search at least 4 parameter at a time only in one field of a table. Any idea is welcome :banghead:

Access 2010 Hello In criteria of a Query I have this SQL: Like [Forms]![FSearch].[qb1] & "*" This SQL is to write in a textbox one parameter at a time to search in a table I need to search for more than one parameter at a time and I have been trying to add to the SQL the operator OR or AND but...

Finally the code in the listbox doubleclic event opens the pdf files. I also included the Error Handing to my Code. To Mike Leben and Dave Thank you very much for your help I am happy to share the code Private Sub Listbox1_DblClick(Cancel As Integer) Dim db As DAO.Database 'These two lines are...

Hello As you say I already copy the function in the module. Then I copy and paste the below code. Option Compare Database Option Explicit Private Sub Mylistbox_DblClick(Cancel As Integer) Dim mypath As String mypath = DLookup("D:\Seb\Desktop\GAMMA-BD\pdf", "tblPaths", "[ID] = " & Me.Listbox94)...

Mike. Many thanks AS you said I wrote your code in the doubleclik listbox event. I have been studying in the web some papers about the "ShellExecute API" function. However, due to my little knowlege of vba I don´t understand how to write the function in tjhe module. How the function works with...

:confused:Hello everyone I have a query that opens a listbox in a form In the listbox I want to add a doubleclick event that opens a pdf file document with the selected record in it. The record is in column 1 of the listbox. The path of the pdf files is I can´t use the FollowHyperlink method of...

With your application #22 now I understan how to program the sql instruction in the query and works well. Many thanks. Your application is new to me and I would really appreciate if you explain the above. Why there is no relationship between the tables in the Relation Object? I always use...

jdraw. Many thanks. Your code works well, however, Iam looking a different option. I think I explained my idea in the wrong way. At the moment the sql you sended me and one and that I am using only allow me enter one word per textbox. I hope the next lines will clear what I need. I need to...

Hello In a form I have an unbound textbox to search for a word stored in a table. The sql is: Like[Forms]![FSearch].[qPK] & "*". This sql statement works well and return all records from the table with the field related with qPK. How can I search in another unbound textbox for more than one...

Hello All I am Gippsy and I live in Costa Rica. My hobbies are birdwatching and classical guitar. I am very interest in learning access and share my knowledgement in the forum Regards