Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    269

    Constant Back End Corruption

    Hi guys --

    I've posted separately about this before, but the issue has seemed to have gotten worse so I thought I'd try again.

    I created and administer an MS Access Application -- 20 + users --...
  2. Replies
    3
    Views
    512

    Re: Report Queries Back End vs Front End

    Thanks for the suggestions guys -- I do a version of both of your ideas -- appreciate the feedback.
  3. Replies
    8
    Views
    1,249

    Re: Maintenance of MS Access Back End

    Thanks for all the suggestions -- I only have Tables in the Back End, and I do use the full network path in linking my tables. The point about shutting down automatically and the issues it might...
  4. Replies
    3
    Views
    512

    Report Queries Back End vs Front End

    Hello All~

    I created and administer an MS Access DB. Back End sits on a Network Drive, 20+ End Users have the Front End on their respective Desktops. The Application has a Reporting Tool where...
  5. Re: Batch Script for New Versions and Shortcuts

    Thanks for the advice guys -- I ended up using that template and created a batch script that puts the application in a separate folder on their c drive and puts a shortcut on their desktop. I'm...
  6. Replies
    2
    Views
    578

    Re: Bound vs. UnBound Forms

    Thanks For that Perspective -- Unbound Forms seems like far more trouble than it's worth.
  7. Replies
    2
    Views
    578

    Bound vs. UnBound Forms

    So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive.

    The primary data entry form...
  8. Replies
    8
    Views
    1,249

    Re: Maintenance of MS Access Back End

    Thanks for the suggestion -- however when the Back End is in this 'locked' read-only state, it cannot be renamed -- I think we're going to go ahead and simply create a new back end every week as a...
  9. Re: Batch Script for New Versions and Shortcuts

    Thanks for the tips guys -- when I have a version working, I'll post it on here for future reference.
  10. Replies
    5
    Views
    730

    Re: AccesS Formula help

    If you have multiple conditions you have to separate with 'And' or 'Or' --

    [DaysAged]>30 And [DaysAged] <=60, so it would like something like this --

    IIF([DaysAged]<=30,"<30...
  11. Replies
    8
    Views
    1,249

    Maintenance of MS Access Back End

    Hello~

    I've created and administer an Access DB application -- 20+ end users -- split db -- each user has a copy of an accde executable file on their desktop, while the back end is on a network...
  12. Batch Script for New Versions and Shortcuts

    I administer an MS Access DB with approximately 20 end users. Each user has a copy of the FE on their desktop. When I need to make changes, the Form_Load Event of the initial form identifies that a...
  13. Replies
    2
    Views
    791

    Back End Only Opening Read Only

    So this has happened now 2 days in a row --

    I administer an Access DB with 12-15 users -- each user has an .accde copy of the front end on their desktop and the back end is on a shared server.
    ...
  14. Re: Copying and Pasting Between Word Docs from MS Access

    Thank You!!

    I don't know why I made it so complicated -- for anyone looking to do this, this is the code that worked for me:

    Set objWord = CreateObject("Word.Application")
    Set docbase =...
  15. Copying and Pasting Between Word Docs from MS Access

    I'm having a hell of time with this -- I'm sure it's something simlple I'm missing -- but from an Access application, I'm trying to combine up to 4 word docs into one word doc, and then convert it...
  16. Changing Values of Text Box on Main Form from Sub Form

    I want to change the value of a combo box on a main form based on the update of a combo box on a subform. I have the following:

    Private Sub cmbSubCombo_AfterUpdate()
    If Me.SubCombo.Value = 1...
  17. Re: Timed Upload Function with Multiple User Access DB

    This is very helpful. Thanks.
  18. Import Specification -- Cannot Find??? I'm sure it's there!

    I'm trying to execute this line of code:

    DoCmd.TransferText acLinkDelim, "TheUploadSpec2", "ltUpload", upPath & upFileNm, True

    I keep getting Error '3625' -- Specification Does Not Exist.
    ...
  19. Timed Upload Function with Multiple User Access DB

    I have an MS Access Based DB, which has a dozen or so users. The database is split, each user has an executable .accde front end on their respective desktops. The Back End is on a shared Network...
  20. Replies
    2
    Views
    433

    Re: Error 462 When Re-running Report

    Ahh...Of course. Thanks so much!
  21. Replies
    2
    Views
    433

    Error 462 When Re-running Report

    Hi All --

    Apologies if that has been covered somewhere -- but I cannot seem to find it while searching.

    I have an Access Based Reporting Application, where a user can select a specific report...
  22. Cannot copy Recordset After Using VBA Function

    I have an MS Access based Reporting Applications that outputs reports to Excel. In the back-end I have a table similar to this:

    ID, Comment
    1, Comment1
    1, Comment2
    1, Comment3


    And from...
  23. Replies
    1
    Views
    844

    Access DB Randomly Shutting Down

    So I have come across a very peculiar situation --

    I've developed an Access 2016 DB for my team -- there are about 10 end users -- each of them have their own executable on their respective...
  24. Re: Order of Looping Through Files in Folder

    Thanks Guys -- it seems putting them in a list/array is the way to go.
  25. accde file not working on specific machine

    I created and administer a Microsoft Access Application -- there are about a dozen users.

    I created an accde file that i distributed to all the users to put on their respective desktops.

    Every...
Results 1 to 25 of 104
Page 1 of 5 1 2 3 4