Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds; generated 55 minute(s) ago.

  1. Replies
    1
    Views
    99

    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...
  2. Replies
    11
    Views
    242

    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...
  3. Replies
    19
    Views
    616

    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:
    ...
  4. Replies
    5
    Views
    462

    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...
  5. 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
  6. 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...
  7. Replies
    16
    Views
    1,580

    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.
  8. 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...
  9. "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
  10. 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...
  11. Replies
    10
    Views
    863

    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.
    ...
  12. 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.
  13. 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...
  14. 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.
  15. Replies
    16
    Views
    1,580

    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...
  16. Replies
    11
    Views
    631

    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.
  17. Replies
    2
    Views
    377

    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...
  18. Replies
    2
    Views
    164

    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
  19. Replies
    9
    Views
    1,367

    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...
  20. 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...
  21. Replies
    3
    Views
    867

    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. ...
  22. Replies
    6
    Views
    1,105

    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...
  23. Replies
    6
    Views
    1,105

    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...
  24. 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...
  25. Replies
    6
    Views
    862

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