Recent content by Eckerslike

  1. E

    VB Libary components

    Hi, I have made a database for use by some of our sales and marketing team whom all have laptops. The database works fine on my PC, but when I try on their Laptops they do not appear to have the correct VB library's installed. The follwing does not appear to work: Transferspreadsheet Date...
  2. E

    Msgbox triggering an event

    I had the same problem once, and below is an example of how I fixed the problem: Dim X X = MsgBox("There are " & nrecords & " occurences of this mpan in the database" & Chr(13) & "Would you like to filter by these records?", vbQuestion + vbYesNo) If X = vbYes Then...
  3. E

    Formula/ expression for filtering out character length

    You can use Length: Len([Nameofyourfield]) In a query and then do a >11 and <11 on this new field
  4. E

    Surname, Forename problems

    If you was to use a query you can just put the below in an empty field. Full Name: [First Name] & " " & [Surname] And then append it to the other table.
  5. E

    Filtering to display most recent

    If you create a query using this table, go to the view menu and click on totals. This will put an additional row called total in your query expression. Everything will be set to Group By, go to the column containing your date and select Max. This will return the latest goal scored for each...
  6. E

    select querry sum

    I made a bit of a mistake :eek: in the above code, in that when it calculates the day it will round it up to the nearest day if greater than .5. To resolve this problem, please see amended code. Function freformat(Inthhmmss As Double) As String Dim Temp As String Dim day As Integer Dim...
  7. E

    Use of EXCEPT command in Access

    Hi, Create a new query and add both the Accnt_All and Accnt_Some tables to it. Now drag the document type field from the Accnt_all table to the same field in the accnt_some table. Right click on the join between the 2 tables and click on the join properties. Select option 2. Now select the...
  8. E

    select querry sum

    Hi, To do this first create a query and do a sum of the column that contains these time's. The result of this will be a number. If you was to format this number as a date it would be fine if it was less than 1 but if it is greater than one it will return a date as in dd/mm/yy hh:mm:ss, which...
  9. E

    Use dates & Append Query to populate table

    The easiest way to do this, would be to simply create a table with all of the pay dates in. Then create an append query using this table and put in the criteria: Between [Start Date] And [End Date].
See more
Back
Top Bottom