Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds; generated 44 minute(s) ago.

  1. Replies
    30
    Views
    1,539

    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?
  2. 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.
  3. Replies
    30
    Views
    1,539

    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...
  4. Replies
    30
    Views
    1,539

    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...
  5. 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,...
  6. Replies
    30
    Views
    1,539

    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...
  7. 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...
  8. Replies
    30
    Views
    1,539

    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...
  9. Replies
    30
    Views
    1,539

    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...
  10. 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#]
  11. 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?
  12. Replies
    6
    Views
    675

    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:
    ...
  13. Replies
    6
    Views
    675

    I put a Me.FilterOn = True prior to the Me.Filter...

    I put a Me.FilterOn = True prior to the Me.Filter = .... command and it seems to work fine
  14. Replies
    6
    Views
    675

    Haven't heard that one before, would you send the...

    Haven't heard that one before, would you send the database zipped with test data only.
  15. Thread: Combining records

    by patt
    Replies
    13
    Views
    967

    This may be of help, let me know.

    This may be of help, let me know.
  16. Thread: Combining records

    by patt
    Replies
    13
    Views
    967

    Does that mean there are always 10 pairs of...

    Does that mean there are always 10 pairs of Categories and percent fields per Excel sheet line or can it vary from 1 to 10 pairs.
    You say "with other fields", what other fields and what is to be...
  17. Thread: Combining records

    by patt
    Replies
    13
    Views
    967

    Will there be only 4 Categories and their...

    Will there be only 4 Categories and their associated %'s in the Excel sheet?

    If so, then it is very straight forward to split these into another table and do the report using another query.
  18. Thread: Combining records

    by patt
    Replies
    13
    Views
    967

    Maybe a crosstab query might be what you want?...

    Maybe a crosstab query might be what you want? But you would have to massage the tables first.
    I would like to see a database of this.
  19. Thread: New Record

    by patt
    Replies
    5
    Views
    402

    You can the use the ESC key to fully erase the...

    You can the use the ESC key to fully erase the new record from the subform.
    If that doesn't work then send a zipped copy of the database.
  20. Thread: New Record

    by patt
    Replies
    5
    Views
    402

    Have you tried putting a test in the subform's...

    Have you tried putting a test in the subform's BeforeUpdate event to cancel the write to the database.
  21. Check out what Google has to offer, I came across...

    Check out what Google has to offer, I came across this link:
    http://stackoverflow.com/questions/512143/error-could-not-find-installable-isam
  22. Replies
    30
    Views
    1,539

    Required help on the below: 1. I am planning to...

    Required help on the below:
    1. I am planning to create a 2 backend tables for Dated & Undated checks, but not sure whether the limitation of Access applies for Table size of 2GB is for back end...
  23. Replies
    3
    Views
    410

    Thanks for the invite, but I have moved to the...

    Thanks for the invite, but I have moved to the Philippines
  24. Replies
    30
    Views
    1,539

    1. We will import both dated and undated checks...

    1. We will import both dated and undated checks into Database once but can it get moved to 2 different tables automatically?
    You could import them into a table, then use 2 append queries to populate...
  25. Replies
    4
    Views
    568

    In the lastname control, the change event gets...

    In the lastname control, the change event gets called for each character keyed in, the BeforeUpdate event occurs after all changes have been made and the afterUpdate event is called after moving to...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4