Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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...
  2. Re: Timed Upload Function with Multiple User Access DB

    This is very helpful. Thanks.
  3. 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.
    ...
  4. 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...
  5. Replies
    2
    Views
    383

    Re: Error 462 When Re-running Report

    Ahh...Of course. Thanks so much!
  6. Replies
    2
    Views
    383

    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...
  7. 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...
  8. Replies
    1
    Views
    538

    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...
  9. Re: Order of Looping Through Files in Folder

    Thanks Guys -- it seems putting them in a list/array is the way to go.
  10. 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...
  11. Re: Help Getting Started on First Database

    Hello,

    From what you are describing, I'm gathering there is a One to Many Relationship between Assembly (1) and Products (Many). A Form that shows all the 'Products' in an 'Assembly' would...
  12. Order of Looping Through Files in Folder

    I have a sequence of code in an Access Application that loops through files in a specific folder -- using For/Next:

    For Each File In Folder.Files
    Code
    Code
    Next

    My question is -- what...
  13. Data Validation -- Numbers in Text Field

    I can't seem to figure this out -- any help would be greatly appreciated.

    I'm trying to validate a column in my excel workbook with the following criteria:

    Length of 9 characters
    Each...
  14. Re: Copying and Pasting Excel Sheets From Access

    That seemed to be the issue. Thanks!
  15. Re: Copying and Pasting Excel Sheets From Access

    I couldn't find a syntax that wouldn't error out, so I ended up writing a Loop copying and pasting cell by cell, essentially coping and pasting A1 to Z250. There has to be a better way of doing...
  16. Re: Copying and Pasting Excel Sheets From Access

    I'm not trying to import data to Access. I'm trying to use MS Access VBA to copy and paste an excel worksheet from one workbook to another. I am able to do this on a cell by cell basis (Copy Cell...
  17. Copying and Pasting Excel Sheets From Access

    I'm working on an Access Application -- through this application, I would like to be able to copy and paste a worksheet from one Excel workbook (which I'll call 'Previous' to the identically titled...
  18. Re: Error 3343 Unrecognized Database Format -- After Running Saved Import from VBA

    Here's a snippet of my code...with comments. I find that if I step through the code slowly it *usually* works. But if I just run it, it usually does not. It's strangely hit or miss --

    Do While...
  19. Error 3343 Unrecognized Database Format -- After Running Saved Import from VBA

    I have an Access application that has a saved import of an excel spreadsheet which I run through code --

    DoCmd.RunSavedImportExport ("SavedSpec")

    Through a loop, I actually change the XML of...
  20. References Excel Sheets Named As Numbers

    I'm building an Access application that needs to populate an Excel workbook. The sheets of the workbooks are named numerically as the days of the month ("1", "2", "3" through "31").

    I'm...
  21. Re: Concatenating One To Many Relationship

    Actually, I figured it out using this function:

    How to concatenate multiple child records into a single value - Microsoft: Access Queries and JET SQL FAQ - Tek-Tips

    Thanks!
  22. Concatenating One To Many Relationship

    Apologies if this has been answered before -- I cannot seem to find it here.

    I'm trying to convert the following table:

    Company, Email
    ACME, email1@email.com
    ACME, email2@email.com
    ACME,...
  23. Altering PowerPoint Footer from Access VBA

    I'm trying to alter PowerPoint presentation footers from an Access Application, I keep getting a 'HeaderFooter (unknown member): Invalid request' error. Perhaps I have the wrong Reference? This is my...
  24. Highlighting Rows in Excel from Access VBA

    I'm exporting a query to an excel spreadsheet. Through Access VBA, I would like to be able to highlight certain rows in the excel output -- specifically rows where a particular column equals a...
  25. Replies
    1
    Views
    889

    Creating Hyperlinks in Report

    Apologies if this has been covered but I cannot seem to find it. So I have a table something like this:
    <caption></caption>

    <thead>


    ID

    Hyperlink
Results 1 to 25 of 89
Page 1 of 4 1 2 3 4