Search results

  1. M

    nested dlookup 2 tables with true false

    Hi all, I'm trying to get a create a nested dlookup as I think this is what I need. not sure how it works and all examples I can find are not relevant to what I need. I need to compare 1 field from 1 table to another field from a second table, I the record is also on the second table, I should...
  2. M

    merge pdf files till 5mb size

    Hi all, I have some code to merge pdf files that are in a folder and including the subfolder. I use Acrobat Pro and works pretty fine. What now turns out, there is a limitation on the size of the pdf files. They will be uploaded to an intranet site and the max size is 5mb. I would need to...
  3. M

    finding a particular date on a row

    Hi all, I got an excel file where the employees are and the days they are in the office. this excel file has all the dates in the columns starting from the Monday date and then next column on the same row has the next day. as example: C2 has 03/09/2019 and D2 has 04/09/2018 There will be only...
  4. M

    calculate passed days on current status

    Hi all, I have a datasheet inside a form. in this datasheet, the current status is visible and the phase initial activity date. Now I need to calculate the days passed of the current selected status. There are 13 status in available to choose from. For example Status 1 till Status 13. Whit this...
  5. M

    use Contains rather than Like

    Hi all, I needed to create a query that will check in 2 different tables for the first name and surname if there is a match. The trouble is that there could be a typo and a first name or surname would be missing or having to much letters. for example McCanna vs McCana or with the first name...
  6. M

    show PDF image from pdf file stored as attachment on table

    Hi all, I have been trying to play with the attachments in the table. in a table where there are some records, there a few attached pdf files. I can add it to the main form and it will show me this field that when I click on it, it will show the attachments, and then I can add, delete, view...
  7. M

    finding text inside html page

    Hi all, I need to fix a part of a function that takes a piece of text from html page. The current function will only take the first string of numbers that come after a 0 href=javascript:LinkCase(0,123456,'Daltonia Limited',0,654321) so I will get only 123456. I'm trying to get now the company...
  8. M

    error with the <= in dates

    Hi all, I'm going nuts on this one. I use a query to get a balance ledger that is less or equal to the day passed and only interested in the TOP 1 ORDER BY set to DESC. SELECT TOP 1 BALANCE_LED FROM CUSTACCT WHERE ACCOUNT_MVT_DATE <=#2/1/2015# ANS BRANCH_NO =12345 AND ACCOUNT =123456789 ORDER BY...
  9. M

    don't open workbook if it is already open

    Hi all, Today I have a voodoo day where all is hard to fix or find answer. at the beginning I had only code to open one excel workbook and do something with it. Now because of new process, I have to do something more to it, so if the workbook is open, use it and don't open another. I can't...
  10. M

    error 94 when passing the sum of a query

    Hi all, I have some code to get the sum results from a table that I want to pass as a variable in the rest of the code. I have the trouble that when there is a 0 because the query can't sum null values. 'run query to get the results to sum up later DoCmd.SetWarnings False...
  11. M

    sum the total from a count query

    Hi all, I have a query that will give me the results from how many countries come from a criteria. HK AE 18 HK CN 1 HK TR 1 HK VC 1 I try to get the sum from all inside a separate query that will give me simply: 21 I use the below query but I don't get it :-( SELECT COUNT(*)...
  12. M

    get results from query and put them into one line of text

    Hi all, I found some code on the web that almost does the trick I need. I only got lost in how to get all the results from a query that now comes in a few lines into one line, separated by a coma. this is the results I get now (in the immediate window) HK AE 18 HK CN 1 HK TR 1 HK...
  13. M

    sum from initial values minus values used in other table

    Hi all, I have a table where I have all the rewards people got. We have an initial budget for this for example like 100 dollars. 3 people got 10 dollars each. This means I should have 70 dollars left. Can I do this in a query and feed the initial value from a field in the main form? I have the...
  14. M

    error in insert into table

    Hi all, I have the below code to insert some data from a search form into the table according the record_id that is on the current open record from the from. CurrentDb.Execute "INSERT INTO tbl_recipients (forname, surname, employee_id, team_leader) Values ('" & strListResult & "', '" &...
  15. M

    use the name of a month to query in a date field

    Hi all, I'm looking into passing a month name from a combobox in a form to a query and get the results for that month. If I would use November, I should get all the records that fall in November. Is this possible? the field that I try to do this is called "pickup_date" Greetings.
  16. M

    pass record_id to row source of combobox

    Hi all, I have a subform with a combobox. the combobox will need to get me a selection of a participant that has her/his name in one of the records. For example in record 3 I have 3 participants "John Potter, Amelia Blake, Peter Cetera" If the form is showing the data for record id 3, then...
  17. M

    Search form to populate datasheet instead of listbox

    Hi all, I have the below code to do searches for example the creator of some minutes. The results are shown in a listbox. Is it possible to show this in a datasheet instead? Private Const BASE_SQL As String = _ "SELECT record_id, subject, date_of_meeting, invitation_status, time_of_meeting...
  18. M

    return only one record where dates are differnt byt 2 columns same results

    Hi all, I came across a silly thing that I can't figure out. I have 3 almost same records, the only difference is that they have a different time (hour and minutes) in the field "created' as you can see from below: 15/09/2017 09:25 John Secada Started 05/09/2017 15/09/2017 11:59 John Secada...
  19. M

    Creating, open folders with Polish characters

    Hi all, I have a form with a button that is used to create or open a folder. It works OK when I use English names, but when I use Polish names with the characters, it simply does not work and opens my folder instead. Any clue how this could be solved? Private Sub btn_cv_candidate_Click()...
  20. M

    access coopy paste only text into textbox

    Hi all, I have the below code to copy from a textbox into another one but only as text (no formatting). I need to use the text for an invitation in Outlook as the invitation will not work with rich text format in the body created with vba. Me.acctions.SetFocus DoCmd.RunCommand acCmdCopy...
Top Bottom