Search:

Type: Posts; User: IkkeEnGij

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    9
    Views
    1,688

    Re: Taking the number from a string

    tested with access 2003 :
    just changed the field-type from text to numeric
    and access did remove the prefixes automaticly
  2. Replies
    4
    Views
    428

    Re: LAST date update on linked table

    if the table is updated at every day
    i would think that the last date of update is always today or yesterday
    depending of the time of the day
    seems logical to me
  3. Replies
    4
    Views
    428

    Re: LAST date update on linked table

    if the table is updated at every day
    i would think that the last date of update is always today or yesterday
    depending of the time of the day
    seems logical to me
  4. Re: SQL server - Update table based on values of another table

    it is just a crosstab query of the table A of your first post
    notise that not all Course codes are included, because not all Course codes that are in your Table B, are also in your Table A
  5. Re: SQL server - Update table based on values of another table

    did this in access 2003:


    TRANSFORM First(Status) AS TheStatus
    SELECT [Course Code]
    FROM TableA
    GROUP BY [Course Code]
    PIVOT Persons;
  6. Re: SQL server - Update table based on values of another table

    did this in access 2003:


    TRANSFORM First(Status) AS TheStatus
    SELECT [Course Code]
    FROM TableA
    GROUP BY [Course Code]
    PIVOT Persons;
  7. Replies
    17
    Views
    2,948

    Re: Database design

    I'm wondering, what is the problem, this is supposed to be a solution for :confused:
  8. Re: SQL date search returning dates outside search criteria

    yes,as confirmed by MS
    question is: if that is so, then why does the op get wrong results ?
    using international format (YYYY-MM-DD) for dates, there can be no confusion

    also, be aware of the...
  9. Re: SQL date search returning dates outside search criteria

    depending where you live in the world, (9/1/2018) can be the first day of september, or the 9the day of januari
    (2018-09-01) is the first day of september anywhere in the world
  10. Re: How to design this query for monthly report?

    exactly, that is why s/he is creating a problem, where there is none
    it is as simple as pie:
    both shifts start at the same day
    so why not make that day the production day of both shifts ?
    and the...
  11. Re: How to design this query for monthly report?

    Why are you creating a problem where there is none
    both shifts start on the same day,so why not count their production as produced on that day
    (what you already seem to be doing judging by your...
  12. Re: move dinamiclly a label to the top of shape ....

    just replace all those shape controls by label controls with a center alignment

    why would you use a shape and a label to do what can be done with just a label alone ?
    the only things i can think...
  13. Re: move dinamiclly a label to the top of shape ....

    Have you considered using just a label control to make a bar
    instead of a shape and a label
  14. Re: How to using like operator and wildcard with Mysql ?

    yes,it works in MSaccess, provided you tell MSaccess to use SQL-92
    (SQL-92 is an option since MSaccess 2003, if i remember correctly)
    but i am almost 100% sure it will not return what vbgedo...
  15. Re: dgv losing maskedtextbox textalignment

    if i understand correctly, you want users to fill in times (hours,minutes,seconds) in a grid
    why does that grid not have 3 columns to do that ?
    1 for hours, 1 for minutes,1 for seconds
  16. Replies
    24
    Views
    2,559

    Re: [RESOLVED] Year Slowdown

    may (or not) exclude a day's worth of data
  17. Replies
    24
    Views
    2,559

    Re: Year Slowdown

    maybe yes, maybe no
    2018-01-01 00:00:01 is later than 2018-01-01
  18. Replies
    16
    Views
    10,500

    Re: Convert string to date format

    ????
  19. Re: Converting a string range of number in a string to individual integers

    have a look at the SPLIT and JOIN functions
  20. Replies
    15
    Views
    2,249

    Re: PERFORMNCE Old DAO project

    you are realizing you are opening the .mdb in full shared read-write mode ?
  21. Re: In a DataGrid, how to identify what record got clicked (or double-clicked) on

    try the rowrolchange event ?
  22. Re: Run Time 3134: Syntax Error in INSERT INTO statement

    kimaleah,
    the most important line in your code is:
    Debug.Print Query1
    is the result really what you expect it to be ?
    if you really want someone to help you:
    show the result
  23. Re: Multiple instances of the same form and manage those form instance

    a possibility:
    have a module:


    Dim TheForm(1 To 5) As New Form1

    Sub Main()
    Static TheLeft As Long
    Static TheTop As Long
    For i = 1 To 5
  24. Replies
    3
    Views
    3,152

    Re: adExecuteNoRecords....

    how many records were affected:
    run the procedure twice to see what the responce is when no records are inserted

    Sub AffectedRecords()
    Dim db As DAO.Database
    Set db = CurrentDb
    ...
  25. Replies
    10
    Views
    1,872

    Re: Access database application

    so you did not
  26. Replies
    10
    Views
    1,872

    Re: Access database application

    could you please post the code and the program used to create a new database
  27. Re: Crash course in using the Find method (or a better way of doing this)

    if you want to search on a name,
    why not just put an index on the name field
  28. Re: AccessRuntime or AccessDatabaseEngine or another alternative

    i suppose:
    if you create the database with code (DAO)
    then the version that is included by default in windows will be used
    i am on windows 10
    with access 2003
    if i create a database with DAO, a...
  29. Re: AccessRuntime or AccessDatabaseEngine or another alternative

    i suppose:
    if you create the database with code (DAO)
    then the version that is included by default in windows will be used
    i am on windows 10
    with access 2003
    if i create a database with DAO, a...
  30. Re: Access reports that databases are in an 'inconsistent state'

    please explain step by step how these RDP users, who also have Access installed, open the same database from the same location.
    such as:
    1)user starts computer
    2)user starts RDP
    3)
    4)
    5)
    6)...
  31. Re: Access reports that databases are in an 'inconsistent state'

    i see


    i see,but confused, what has Remode Desktop Protocol to do with this ?
  32. Re: Access reports that databases are in an 'inconsistent state'

    am i interpreting that correct ?
    there is 1 computer with msaccess installed, that 1 computer also holds the database
    multiple users start that copy of msaccess via RDP, to access the database
    so,...
  33. Re: [RESOLVED] Make empty all tables of database

    I see, each year copying an empty template database is to easy ?
  34. Re: [RESOLVED] Make empty all tables of database

    Why ???
  35. Re: syntax error in number in query expression number and date in vb6

    https://www.cl.cam.ac.uk/~mgk25/iso-time.html
  36. Re: syntax error in number in query expression number and date in vb6

    there is no mysterious reason at all
    what is the date 05/06/2018 ?
    that depends on the part of the world you'r in
    it can mean the 5th day of June ---say in belgium
    or the 6th day of may ---say...
  37. Re: syntax error in number in query expression number and date in vb6

    does the following succeed ?


    SELECT Numéro, Date FROM Histo WHERE Numéro=4 AND Date=#2017-06-29#
  38. Re: syntax error in number in query expression number and date in vb6

    siadly,
    can you place your database here (with only the needed tables,and compacted, and zipped)
    and please explain clearly what you expect as a result
  39. Re: How to calculate ID after adding a new record

    i can not test this at the moment
    but if memory serves me well, the autonumber is given right after the addnew,for ado and dao
    try


    rs.AddNew
    MsgBox rs("ID")
    rs.CancelUpdate
  40. Re: Create array from tables in different MS Access databases

    ??
    maybe use the merge method of the datatable object ?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width