• WSpbrodsky

    WSpbrodsky

    @wspbrodsky

    Viewing 12 replies - 1 through 12 (of 12 total)
    Author
    Replies
    • in reply to: how to display (2000) #903605

      Have you considered using Excel as the interface with VBA programming to retrieve the data from Access tables and more code to update the tables. It seems too complex for your needs, but would let you keep your current interface.

    • in reply to: how to display (2000) #903606

      Have you considered using Excel as the interface with VBA programming to retrieve the data from Access tables and more code to update the tables. It seems too complex for your needs, but would let you keep your current interface.

    • in reply to: Excel vs Access (2000+) #805261

      Not just data integrity, but if you are writing an application for other people to use, Access gives much more control to ensure that the users don’t do things they shouldn’t. Excel is a much more flexible, but much more open environment – it is difficult to constrain users so that they only do what you expect them to, and much easier for users to mess up an application. On the other hand, knowledgeable users can more easily modify an Excel database for their own purposes..

    • in reply to: Excel vs Access (2000+) #805262

      Not just data integrity, but if you are writing an application for other people to use, Access gives much more control to ensure that the users don’t do things they shouldn’t. Excel is a much more flexible, but much more open environment – it is difficult to constrain users so that they only do what you expect them to, and much easier for users to mess up an application. On the other hand, knowledgeable users can more easily modify an Excel database for their own purposes..

    • in reply to: replace text with special characters (2000/9.0.2720) #580816

      Alt-Enter puts a ‘hard carriage return’ in a cell (its in the Help file under ‘entering text’

    • in reply to: Text not wrapping properly (2000 (9.0.4402 SR-1)) #580814

      You can open the Excel file in Word and get a Word table of the contents

    • in reply to: Excel VBA Formula (2000) #559431

      An easier way to do this would be to use FormulaR1C1
      eg. ActiveCell.FormulaR1C1 = Range(“d10”).FormulaR1C1

    • in reply to: Document vs. Print Preview (97) #553580

      Just a thought.

      From the samples you included earlier, it looks as though Excel may not be the ideal application for this. If the document is just formatted text, you might look at Word, or, if you are using lookups in Excel, you might find Access reports a better solution. In either case, it should not be too much work to move things from Excel.

    • in reply to: Photo Editing #529464

      I like Adobe Photoshop Elements and Ulead PhotoImpact. Either is under $100 (US).

    • in reply to: Printing problem #528815

      I had this situation once when it turned out to be a bad printer cable.

    • in reply to: Can’t Assign Value… #527196

      I ran into this error message recently. I fixed it without really tracking it down, but it looked as though Access changed the syntax for referring to a control on a subform between 97 and 2000.

    • in reply to: Pivot Table Item List Corrupt #526216

      I found (I don’t remember where) the following code to delete unused pivot items. It appears to work.

      Sub deloldpivotitems()
      Set oPiv = ActiveSheet.PivotTables(1)

      For Each oField In oPiv.PivotFields
      If oField.Name “Data” Then
      For Each oItem In oField.PivotItems
      If oItem.RecordCount = 0 And Not oItem.IsCalculated Then oItem.Delete
      Next
      End If
      Next

      End Sub

    Viewing 12 replies - 1 through 12 (of 12 total)