Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    10
    Views
    558

    Re: Report Data Missing (2003 SP2)

    UPDATE: After applying the updates to repair MDAC to no avail, we gave the user a brand new docked laptop with the latest and greatest including all updates and service packs and the user STILL...
  2. Replies
    10
    Views
    558

    Re: Report Data Missing (2003 SP2)

    Hans,

    Thanks for your response.

    I followed the steps you indicated but got the following error:

    "Fatal Setup Error: This setup does not support installing on this operating system."

    The...
  3. Replies
    10
    Views
    558

    Re: Report Data Missing (2003 SP2)

    After reinstalling Access then uninstalling & reinstalling Office 2003 (SP3), this problem continues with this user. He can see the complete report when using another computer. It seems that it's...
  4. Replies
    2
    Views
    344

    Re: Group totals incorrect (Access 2003/SP2)

    Hi Hans,

    I created a query to do the calculations and used that query in the report. All is fine now.

    The problem was within by VBA code. I was resetting the values in the group header...
  5. Replies
    2
    Views
    344

    Group totals incorrect (Access 2003/SP2)

    I have a report that calculates a group total. The total is correct unless the detail records in the group are continued on the next page and Repeat Section is set to "Yes". In this case, the group...
  6. Replies
    10
    Views
    558

    Re: Report Data Missing (2003 SP2)

    The database is located on a network drive (for testing) and is accessed from the same location by all users. Would the references be a factor in this case?
  7. Replies
    10
    Views
    558

    Report Data Missing (2003 SP2)

    I have a report using VBA code to perform calculations. When one user runs a report, the calculated data is not showing. All the other users can see the data. All users are using the same version...
  8. Replies
    4
    Views
    451

    Re: Upsizing and Subforms (Access 2003)

    Thanks Hans! That worked.

    Regards,
  9. Replies
    4
    Views
    451

    Re: Upsizing and Subforms (Access 2003)

    Hi Hans,

    No, it does not have a primary key.
  10. Replies
    4
    Views
    451

    Upsizing and Subforms (Access 2003)

    In Access I have a subform that opens to a blank record to allow adding data if no corresponding record is found in the linked table. After I upsized to SQL server, the subform will not allow...
  11. Export query to formatted Excel spreadsheet (Access 2003)

    I'm exporting data from Access to Excel using "DoCmd.OutputTo" and it works fine. However, I need the data formatted in Excel and would like to know if there is another way to export into Excel...
  12. Replies
    2
    Views
    334

    Re: Database Users (A2K/SR1)

    Thanks, Hans! Works great!
  13. Replies
    2
    Views
    334

    Database Users (A2K/SR1)

    Is there a way to find out who is using a database (or who has locked it)?
  14. Replies
    13
    Views
    514

    Re: Exclusive Access (A2K/SR1)

    Figured it out. The shortcuts on the users desktops were corrupt. We reinstalled Access and recreated their shortcuts. Thanks for all your suggestions!
  15. Replies
    13
    Views
    514

    Re: Exclusive Access (A2K/SR1)

    Hans,

    I'm the only person who can edit these databases in design mode. I have not made any changes in quite some time. The only thing I can think of is that I compacted two (2) of the databases...
  16. Replies
    13
    Views
    514

    Re: Exclusive Access (A2K/SR1)

    That's what I do!!!!!
  17. Replies
    13
    Views
    514

    Re: Exclusive Access (A2K/SR1)

    I don't know why ALL of my databases are doing this. Recently, one user was logged in and shut down his computer and went home. It seems that this is around the time that the problem began. I've...
  18. Replies
    13
    Views
    514

    Re: Exclusive Access (A2K/SR1)

    No one (other than myself) can access the databases in design mode. I usually let the users know if I'm working on their database so they will not login. I've never had this particular problem...
  19. Replies
    13
    Views
    514

    Re: Exclusive Access (A2K/SR1)

    Thanks Hans,

    This has all been checked. Nothing has changed in the databases themselves. And file permission are correct.
  20. Replies
    13
    Views
    514

    Exclusive Access (A2K/SR1)

    I maintain several shared databases. Recently all these databases are getting "You do not have exclusive access to the database at this time...." when opened by more than one user. I'm stumped. ...
  21. Re: Changing control propert is saving blank record (A2k)

    Thanks for your reply. The code is executing from the forms On Current event. I've figured it out... I was changening the value of a checkbox from false to true.
  22. Changing control propert is saving blank record (A2k)

    When adding a new record but before data is actually entered, I'm changing the properties of a control to make it visible and enabled. However, doing this is saving the record with only the primary...
Results 1 to 22 of 22