Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds.

  1. I'm curious as to why some companies are not...

    I'm curious as to why some companies are not represented in the test result. For example, I didn't see any recent testing of Symantec products in the AV Comparative results (apparently last tested...
  2. Replies
    2
    Views
    169

    For a box, are you coloring the border or the...

    For a box, are you coloring the border or the background?

    Here's one example: Me.YourControlName.BorderColor=RGB(YourRedValue, YourGreenValue, YourBlueValue)
  3. [SOLVED] It might not help, but you can try to run JetComp...

    It might not help, but you can try to run JetComp to repair the database, it can be found on Microsoft website.

    Were you able to import anything to the new database? What are you trying to...
  4. Replies
    11
    Views
    422

    [SOLVED] All form_Load does is set the rowsource of what I...

    All form_Load does is set the rowsource of what I assume is a listbox. I'm not even sure why that is necessary, just set the rowsource of the listbox in design mode.

    When do those other procedures...
  5. Replies
    19
    Views
    857

    The Watch may truncate; so in case it might, try...

    The Watch may truncate; so in case it might, try this:

    Assuming you had some existing query (maybe something like "qrySelect"), I'd do this prior to opening the recordset:
    ...
  6. Replies
    5
    Views
    548

    If all 4 notes records have the same value, then...

    If all 4 notes records have the same value, then this seemingly would be solved by just putting a control in the header where its controlsource is that NoteDateTime field. When Access prints the...
  7. If your combobox is on your main form, requerying...

    If your combobox is on your main form, requerying it is as simple as:

    Forms!frmEntries!cboIDNames.Requery
  8. Many local colleges often have "Business...

    Many local colleges often have "Business Education" programs that offer courses on topics like Access. Often they are held at night or on weekends; depending on how often they meet, they usually...
  9. Replies
    16
    Views
    1,804

    Thanks for stopping by to lecture us on all the...

    Thanks for stopping by to lecture us on all the things we obviously didn't know because we only started using Access last week.
  10. I'm guessing you were sitting at a new record,...

    I'm guessing you were sitting at a new record, which is why you got the error. Here is the code for both buttons:



    Private Sub cmdNext_Click()
    If Me.NewRecord = True Then
    DoCmd.Beep...
  11. "Next Record" button: ...

    "Next Record" button:

    me.recordsetclone.bookmark=me.bookmark
    me.recordsetclone.movenext
    if me.recordsetclone.eof = true then
    docmd.beep
    else
    me.bookmark=me.recordsetclone.bookmark
    endif
  12. Aha! Another old Compuserve member! Is each...

    Aha! Another old Compuserve member!

    Is each of your forms a single, continuous form (perhaps with your page up/down buttons in either the header or footer)? Or are the records in a subform with...
  13. Replies
    10
    Views
    963

    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.
    ...
  14. 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.
  15. 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...
  16. 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.
  17. Replies
    16
    Views
    1,804

    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...
  18. Replies
    11
    Views
    684

    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.
  19. Replies
    2
    Views
    424

    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...
  20. Replies
    2
    Views
    198

    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
  21. Replies
    9
    Views
    1,532

    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...
  22. 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...
  23. Replies
    3
    Views
    937

    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. ...
  24. Replies
    6
    Views
    1,185

    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...
  25. Replies
    6
    Views
    1,185

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4