Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    10
    Views
    456

    From my experience, Access (any version) doesn't...

    From my experience, Access (any version) doesn't work particularly well over a VPN. There are exceptions, but it would have to be a really good (fast) VPN and the distances can't be too great.
    ...
  2. No problem. Good luck with it. If you need help...

    No problem. Good luck with it. If you need help with the function, just give a holler.
  3. You could create a public function that accepted...

    You could create a public function that accepted the original Title and returned a string suitable for sort, and use it in queries, reports, and such.

    But I think having an Alternate Title as patt...
  4. I assume you've tried to compact/repair? ...

    I assume you've tried to compact/repair? Regardless, it is better to be proactive here. I'd create a new database and import all the items. You might want to redo the relationships.
  5. Replies
    13
    Views
    1,043

    I don't think the problems you have described...

    I don't think the problems you have described will be solved by going to an SQL Server backend. In my experience, as companies experience growth in their databases, the forms the worked just fine in...
  6. Replies
    11
    Views
    447

    I've used a similar function for years and not...

    I've used a similar function for years and not had any problems. Have you checked your references? A Missing Reference will cause what are seemingly unrelated problems.
  7. Replies
    2
    Views
    233

    Depending on whether you select portrait or...

    Depending on whether you select portrait or landscape, the report design may make the page very wide or very long. You might want to Preview the report and then switch to Design mode. That might...
  8. Replies
    2
    Views
    127

    This should be fairly simple, requiring an Append...

    This should be fairly simple, requiring an Append query (substitute your real table/field names for mine):

    INSERT INTO Table2 (Field1, Field2)
    SELECT Field1, Field2 FROM Table1
  9. Replies
    9
    Views
    961

    This is a perfect illustration of what happens...

    This is a perfect illustration of what happens when you have a denormalized database! You have to jump through hoops to get the information you need. The committees should not be fields in the the...
  10. I don't think you can use IN in that situation. ...

    I don't think you can use IN in that situation.

    Rather than nested IIF statements, I think you should investigate the Switch function. It is much easier to use and read than all those nested...
  11. Replies
    3
    Views
    708

    You are not wrong, the mantra used to by "Don't...

    You are not wrong, the mantra used to by "Don't store images in Access"!

    My understanding is that Access changed how it stored those attachments, so that it does it much more efficiently now. ...
  12. Replies
    6
    Views
    971

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

    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...
  14. 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...
  15. Replies
    6
    Views
    708

    [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...
  16. Replies
    6
    Views
    708

    [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?
  17. Replies
    1
    Views
    232

    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:
    ...
  18. 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?
  19. Replies
    5
    Views
    383

    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,...
  20. Replies
    5
    Views
    383

    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...
  21. 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...
  22. Replies
    4
    Views
    484

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

    I think you may also have to set .FilterOn = True
  23. Replies
    4
    Views
    773

    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...
  24. Replies
    4
    Views
    773

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

    Date2 = DateSerial(Year(Date1), Month(Date1),1)
  25. 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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4