Search results

  1. arnelgp

    Error on Creating a Query after changing LongTextField to Short Text

    create a new table with same structure but with short text rather than long text on the new table. append the record from the old table to the new and delete the old. rename the new table as the old table.
  2. arnelgp

    Text boxes - Grow and shrink

    only on report, it is possible.
  3. arnelgp

    Unable to connect to Remote (LAN) SQL Server Instance where both SQL Express and SQL Developer Edition are installed

    maybe the link on post#8 can help: Cannot connect to SQL Server on a network | Access World Forums (access-programmers.co.uk)
  4. arnelgp

    basic ticketing system design - suggestions welcome

    maybe you can consider, ticket seat mapping? demo on post #30. Solved - Seat Reservation / Grafik Programme | Page 2 | Access World Forums (access-programmers.co.uk)
  5. arnelgp

    Filling in Repeated Data from Excel source Table

    ' arnelgp Private Sub sbUpdateBranch(ByVal workbookName As String, Optional ByVal sheetName As String = "sheet1") Dim rs As Object Dim sBranch As String Set rs = RecordSetFromSheet(workbookName, sheetName) With rs If Not (.BOF And .EOF) Then .MoveFirst...
  6. arnelgp

    Solved VBA Code/Formula to find left most value(s) and paste them descending

    see this demo.
  7. arnelgp

    Finding missing No

    Autonumber can easily be "missed", when a users enters a New record and start typing and eventually bail out and discontinue adding the record. it is not similar to a Cheque number where a missing 1 is very impotant. what matters is that our teeth should not be gapped!
  8. arnelgp

    Solved Error with Input Mask

    maybe add code to the Change event?
  9. arnelgp

    ODBC error before delete keyDown event

    can you use "other" keys to use for your "custom delete"?
  10. arnelgp

    Access query design help

    column count can be of max 255 only. you need VBA to update your Crosstab query with the latest Year to add. make to copies of this query (name the queries, qryOrig and OriginalNameOfYourQuery): TRANSFORM Count(tbl_GoodsInAndStockData.JobNumber) AS CountOfJobNumber SELECT...
  11. arnelgp

    Solved the expression you entered is too complex

    table, tblRiskCode: RiskCode Sovernity 1 1A 2 1B 3 1C 4 2A 5 2B 6 2C 7 3A 8 3B 9 3C 10 4A 11 4B 12 4C 13 5A 14 5B 15 5C 16 6A 17 6B 18 6C 19 7A 20 7B...
  12. arnelgp

    Help with Macro or VBA

    from which form do you have a button that has the code: DoCmd.OpenForm "frm_stk_IngaveStock
  13. arnelgp

    When you choose a year in the form fill in the right records

    the original form does not have the Year field on it, i just added it. on the BeforeInsert event, i set the Year field to the value of the combo.
  14. arnelgp

    Solved Move/Tab to next control

    you should also add validation if the "next" control allows you to Tab by checking it's TabStop property and that it is Enabled.
  15. arnelgp

    Opentextfile leads to error 5

    or you can set it once in VBA (tools->options)
  16. arnelgp

    Opentextfile leads to error 5

    see post #2, Error 5 is Access Denied (pertains to file).
  17. arnelgp

    Adding and detecting new records

    you can also Check if your PK is Null for New record.
  18. arnelgp

    When you choose a year in the form fill in the right records

    you try this Abo
  19. arnelgp

    Inserting multiple rows into an email created by VBA

    you need to use Outlook automation or CDO, if you don't have the code yet.
  20. arnelgp

    Limit the number of entries to a table with a specific value (preventing overbooking in airline)

    see again the form frmBooking.
Top Bottom