Search results

  1. B

    Run Reports using VBA or Local table

    The Access database has a SQL backend with tables, views, SP's. I have reports to run based on rptArea and I am currently using vba but wondering if it's better to use a report table. For instance, sample vba code: if rptArea is "Mktg" then Case M1 rptName = "Mktg1_rpt"...
  2. B

    How to run the output of Access vba SQL statement to a temp table

    I'm trying to step through VBA code to look at the data that is being created. How can I get the output of a VBA select statement to show it as I step through the code? For instance, a select statement sSQL="SELECT ........ Is there a way to create a quick #Temp table that takes that vba...
  3. B

    How to remove password protected from VBA modules

    I inherited an Access database that is password protected. I can open it, view tables, queries and forms. But, when I click on a form event to see the code, I am prompted with enter the password. I do have the password, and it works. My issue is that I want to copy the forms from this database...
  4. B

    Solved Remove certain parts of a concatenated textbox

    I have a form with a concatenated textbox with string information separated by a comma. Example: (2)01-1210,(6)388108,(4)75342 (2) within the parenthesis is the qty, and the remaining number is the part#. There can be a string one or more of this qty and part # separated by a comma. When I...
  5. B

    Solved From Access VBA an Output to Excel that filters the Output

    I inherited code from another developer. The code works fine to export to Excel as shown in CurrentOutput.jpg example. But, now they want to break up the output to filter by fixture category. When the fixture category changes, then write out a new header row'(see example attached on...
  6. B

    Edit a row on continuous form while the other rows are locked.

    I have a continuous form with an edit button. On the continuous form, there’s an edit button for every row. I want to be able to highlight the row of the continuous form, store the row ID in a string, and then click the edit button to edit just that row only with the other rows locked. Is this...
  7. B

    Write to next row in continuous subform

    I have a popup form that has data entry input for the fields Trail_Code and Trail_Desc. The form has a “+” sign button to add the data to my continuous subform, which it does. The problem I’m having is that it only writes to one row of my subform. When I do another manual entry and click on the...
  8. B

    Mapping VBA Code to show tables affected by VBA

    I have been given a legacy database and need to map what the VBA does and what tables are affected when a button on a form is clicked. I used the object dependencies, but it doesn't get down to what happens when buttons are clicked to show when tables are updated. Is there a way to map this? I...
  9. B

    Import Excel CSV Specific Cells to MS Access Table

    I have a CSV delimited file with row data that I want to transfer to MS Access columns. MS Access is already open; I have a button on Access form to import Excel to the table. For instance, In the CSV file cell b1 and b2 have this data: JPWestfield 8/1/2019 Customer and date are columns in...
  10. B

    Insert a blank row in Excel after Access export to Excel

    I have created an Excel Template. In Access I export data from a query to the Excel Template which works fine and it opens the Excel template so I can see the data that it exported. With the Excel template still open, how do I, with VBA, insert a blank row when column A date changes? Example in...
  11. B

    How to create a temp table from concatenated fields that vary in length

    I have a parts table. In it there are two fields that have string info (Customer and CPN). For instance: Parts Table Example: PartNo Customer CPN 1678 Yen/Stick/Pearson Yen: 2321*Stick: 52344J/45*Pearson: Hy45 1679 Carson Cy8911 1680 1681 Harry's In the example...
Back
Top Bottom