Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    6
    Views
    591

    True, the Rich Text formatting features are...

    True, the Rich Text formatting features are somewhat limited, but I think it is still pretty useful. I guess that after all those years we finally are able to do things like underline a single word...
  2. Replies
    6
    Views
    591

    As Boyd said, you must set the control Text...

    As Boyd said, you must set the control Text Format to "Rich Text".

    Actually, I don't think it matters that the field in the table is set to "Rich Text". Perhaps it matters only if you were...
  3. I'm hoping the table behind the listbox has a...

    I'm hoping the table behind the listbox has a PrimaryKey. If so, that should be part of the rowsource of the listbox (make it a hidden column), and the listbox bound column property should be set to...
  4. Replies
    6
    Views
    537

    [SOLVED] If you look at the property sheet for form...

    If you look at the property sheet for form [Progress Report] (btw, you should get out of the habit of embedding spaces in names), you will notice that it doesn't contain anything in the Before Update...
  5. Replies
    6
    Views
    537

    [SOLVED] OK, I downloaded you db, but which form is...

    OK, I downloaded you db, but which form is causing you the problem, and where is the "lame button" you created?
  6. Replies
    1
    Views
    156

    Assuming each item is a record in the detail...

    Assuming each item is a record in the detail section of your report, I create a blank image control. Then in the Detail Section's Format event, I then use something like this:
    ...
  7. Wouldn't it be simpler if you just had a 2 fields...

    Wouldn't it be simpler if you just had a 2 fields for each Employee: DateJoined and DateLeft?
  8. Replies
    5
    Views
    280

    I want to second what Joe said. I've had...

    I want to second what Joe said. I've had situations where some IT guy (who just upgraded their hardware) will say "You have a 64-bit O/S, you should use 64-bit Office". Yeah, and they had problems,...
  9. Replies
    5
    Views
    280

    There is really very little you need to do. No...

    There is really very little you need to do. No conversions are needed, basically you should be able to just using Access 2010. Berton mentioned the 32-bit and 64-bit versions; if you are currently...
  10. When you use a reference to a form in a query,...

    When you use a reference to a form in a query, and then try to use that query in a form or report you frequently run into this error. This can usually be solved by using the Eval() function. For...
  11. Replies
    4
    Views
    388

    [SOLVED] I think you may also have to set .FilterOn = True

    I think you may also have to set .FilterOn = True
  12. Replies
    4
    Views
    646

    Oop! DateSerial is an Access function. There is...

    Oop! DateSerial is an Access function. There is now a comparable function in SQL 2012 named "DateFromParts" (actually, there are several variations).

    But for SQL 2008 you might try this (it is a...
  13. Replies
    4
    Views
    646

    Date2 = DateSerial(Year(Date1), Month(Date1),1)

    Date2 = DateSerial(Year(Date1), Month(Date1),1)
  14. Based on what you described, I don't understand...

    Based on what you described, I don't understand the reason for that first query, nor do I understand the need for all those intermediate tables! In your 2nd query, can't you just join to the table...
  15. Replies
    2
    Views
    223

    From the Access side, you might try: Update...

    From the Access side, you might try:
    Update tblValuation SET OMDone=False WHERE OMDone=False
  16. Replies
    3
    Views
    573

    The usual reason for a parameter box popping up...

    The usual reason for a parameter box popping up is that you've misspelled a table or a field name.
    Best thing to do is to use "debug.print mySQL" before you run the query to show exactly the...
  17. Well, sometimes dealing with queries can be...

    Well, sometimes dealing with queries can be overwhelming. Forest and trees situation.
  18. The simplest way would be to start with a couple...

    The simplest way would be to start with a couple of queries, one for each year. So your qryShipmentsIn2013 might look like this:

    SELECT ProductID, Sum(Quantity) AS QuantityShipped2013 FROM...
  19. To need to execute the runtime.exe on the user's...

    To need to execute the runtime.exe on the user's PC, which will install Access. You will probably then have to create a shortcut to your frontend.accde file which the user can double-click to bring...
  20. First of all, did you download the 64-bit...

    First of all, did you download the 64-bit runtime? Unless you REALLY need the 64-bit version of Access, you are better off with the 32-bit version. This has nothing to do with your operating...
  21. Look again at what I first wrote. You had to...

    Look again at what I first wrote. You had to create another query which just returned the ID# and Min value (or Max value if that is what you needed). You then join that query to the original table...
  22. When you log-in to your LinkedIn account, you...

    When you log-in to your LinkedIn account, you will see a menu bar with "Home Profile Connections Jobs Interests". There is a dropdown menu under "Interests" for Groups.
  23. You shouldn't be using an aggregate function in a...

    You shouldn't be using an aggregate function in a query. It is very inefficient.

    The best way is to create query which just returns the min year for that batch:
    SELECT BatchID, Min([Year]) AS...
  24. I'm not sure of the context in which you are...

    I'm not sure of the context in which you are using it (in a query, in code, etc.). But this is most likely what you need (notice I removed the quotes around the tablename:

    DLookup("[ACCT_NO]",...
  25. Have you considered LinkedIn? There are a...

    Have you considered LinkedIn? There are a variety of Groups there that specialize in Access.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4