Search:

Type: Posts; User: patt; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    10
    Views
    615

    I opened one the other day using TeamViewer, I am...

    I opened one the other day using TeamViewer, I am in Philippines the remote computer in Melbourne Australia.
  2. Why not have another field for title, say...

    Why not have another field for title, say TitleAlternate where you don't store these words, the query using the new field.
  3. You don't have table tblTaakRapporteringDetail...

    You don't have table tblTaakRapporteringDetail defined for the 2nd subfom.
  4. Replies
    9
    Views
    1,264

    Browni has nailed it, you said that the shortcuts...

    Browni has nailed it, you said that the shortcuts were for the table, forms, etc, not the database file itself.
  5. Replies
    9
    Views
    1,264

    I don't know what you have because the Northwind...

    I don't know what you have because the Northwind database has no shortcuts (what ever that is), they may link to another database for it's tables though, it's been a long time for me there.
  6. Replies
    9
    Views
    1,264

    Look at the NorthWind database that MS has, it's...

    Look at the NorthWind database that MS has, it's free, it may have been installed with your version of Office.
    Off the top of my head the schema I think you need is:
    Customers, OrderHeader,...
  7. Replies
    7
    Views
    1,065

    A point against the 2 table approach is what...

    A point against the 2 table approach is what happens if inactivity is flagged incorrectly, it's far easier to unflag records as against transferring these records back again.
  8. Replies
    2
    Views
    358

    Thanks Satrow, what I did before I saw your...

    Thanks Satrow, what I did before I saw your message was to reset the defaults in Google Chrome and all is ok.
    I will check out that link though.
  9. Replies
    2
    Views
    358

    iStartSurf virus removal

    I have the above virus on my computer.
    I have eradicated it from IE (I hope).
    How do I do the same in Google Chrome?
  10. Replies
    7
    Views
    1,065

    Another way is to use just one table for both...

    Another way is to use just one table for both active and inactive records, you will need another field to distinguish between the two. Makes querying easier.
  11. Replies
    4
    Views
    493

    [SOLVED] Does using the Me.Filter command work?

    Does using the Me.Filter command work?
  12. Replies
    4
    Views
    995

    check references to see if any are missing.

    check references to see if any are missing.
  13. Replies
    1
    Views
    253

    From memory, I think the Choose command does what...

    From memory, I think the Choose command does what you want.

    The correct command is Switch.
  14. Replies
    30
    Views
    2,723

    Have you linked the excel sheets to Access, that...

    Have you linked the excel sheets to Access, that may be the problem.

    What is the switchboard meant to be doing?
  15. if the field is always like (A/1/1 or 2 digit...

    if the field is always like (A/1/1 or 2 digit number) then why not create a calculated column that converts A/1/8 to A/1/08, then sort on that.
  16. Replies
    30
    Views
    2,723

    You can't just say no it didn't work, what didn't...

    You can't just say no it didn't work, what didn't work, please be more specific else we have no idea how to help.
    Did you do what I suggested about creating a new query?
    Are those fields text...
  17. Replies
    30
    Views
    2,723

    Is ContractNo text? If not remove the surrounding...

    Is ContractNo text? If not remove the surrounding single quotes.
    Is Cheque No text? if not remove the surrounding single quotes.
    The format for the dates is "mm/dd/yyyy".

    Take the query of the...
  18. Are all the queries that form the source of all...

    Are all the queries that form the source of all reports the same except for the DROT code.
    Are all reports the same referencing queries with differing DROT codes?

    If the answer is yes to both,...
  19. Replies
    30
    Views
    2,723

    Need ideas on below; 1. Any suggestions on...

    Need ideas on below;
    1. Any suggestions on capturing the Date & Time for each Import along with Username for each Import?
    Where do you wish to capture the Date & Time for each Import along with...
  20. What I would have done presuming all the queries...

    What I would have done presuming all the queries are the same except for the DROT code is to populate a single record table with the DROT code then include that table in your query.
    Then all you...
  21. Replies
    30
    Views
    2,723

    1. have you tried importing the excel spreadsheet...

    1. have you tried importing the excel spreadsheet to a non-existant table? It should bring all the fields in. If that works, why not delete the table before importing the spreadsheet.

    2. Use...
  22. Replies
    30
    Views
    2,723

    I did something like this many years ago, I would...

    I did something like this many years ago, I would generate a UNION query on the fly to access all the databases (84 in all, each with 2 million records).
    So I would tend to use a UNION query as a...
  23. Does this do what you want? SELECT d.[Date] as...

    Does this do what you want?

    SELECT d.[Date] as ItemDescription
    FROM Dates as d INNER JOIN FINAL as f ON d.[WK#] = f.ItemDescription
    ORDER BY d.[WK#]
  24. I don't understand what you want, a diagram would...

    I don't understand what you want, a diagram would help.

    Maybe some form of crosstab query is what you need?
  25. Replies
    6
    Views
    1,051

    In the switchboard where the Select Case...

    In the switchboard where the Select Case statement is for option 1 which sets the Filter for the form.
    In the Private Function HandleButtonClick(intBtn As Integer) you will see the following code:
    ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4