Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bvbowes

  1. bvbowes

    FreezePanes in Export to Excel Doesn't Work

    Wow PHV - your xlApp. suggestion seems to be working - everytime you respond it's golden...thank you both.
  2. bvbowes

    FreezePanes in Export to Excel Doesn't Work

    Well I'm doing all this code in Access, not in Excel, thats why I stated Compact and Repair. I'll change the code back to the way you suggest. I guess the problem lies with Excel and not Access, and I didn't know Excel had it's little repair thing like Access does. I might try that as well...
  3. bvbowes

    FreezePanes in Export to Excel Doesn't Work

    I've tried that one already and it did not work. I did however compact and repair, and my same code worked! So I tried it again, and it did NOT work. So I compacted and repaired again, and it did NOT work, so I tried a 3rd time, and it DID work. What is going on?
  4. bvbowes

    FreezePanes in Export to Excel Doesn't Work

    I can't figure why my workbook won't freeze panes at A2 so that my column headers are always showing in a scroll. Everything else works. Here's the whole code: Private Sub cmdExport_Click() On Error Resume Next Dim xlApp As Excel.Application Dim xlSheet As Excel.Worksheet Dim...
  5. bvbowes

    MsgBox won't display custom fields

    you da man pwise...
  6. bvbowes

    MsgBox won't display custom fields

    After inserting records from Oracle into a table in Access I want a msgbox to display the count of records inserted. I thought this would work and it doesn't, what am I doing wrong? daily_count = "SELECT Count(tblDaily.VENDOR_NAME) AS Count From tblDaily" MsgBox "Daily table import has...
  7. bvbowes

    riddle picture

    I'm having a hard time justifying reading this rather then finding some code that I REALLY need right now, but I have to say that philosophy is always bound to the limits of language, not thought, and the bible says that God's knowledge has made mankinds knowledge absurd (definately you have all...
  8. bvbowes

    Commit Action During Record Navigation

    I have a note table that is linked to the main form where the case number is via case number. But in order to have a one to many I just insert the max note id + 1 and insert the current case number at the same time. Here is the code. Function AddNotes() Dim SqlAddNote As Variant Dim...
  9. bvbowes

    Commit Action During Record Navigation

    Allow Edits = Yes Yes it is updatable I have it unbound so that I can pass the notes to a tbl that houses only the notesid, notes, windows user name, and timestamp where any form can pull the notes data into itself.
  10. bvbowes

    Commit Action During Record Navigation

    Same error...
  11. bvbowes

    Commit Action During Record Navigation

    What I meant to say is that dirty only works with bounded items....
  12. bvbowes

    Commit Action During Record Navigation

    It fires great...I get this error message though in the after_update: Run-time error '7768': In order to change data through this form, the focus must be in a bound field tha can be modified.
  13. bvbowes

    Commit Action During Record Navigation

    Yeah I tried that already, only bound fields can be modified with BeforeUpdate.
  14. bvbowes

    Commit Action During Record Navigation

    Nice, thanks, I didn't know about the "On Current" event I've added some code to just pop up a reminder to add the text (via a cmd button that already exists) but the form goes to the next record any way. Any way to stop it? Here is what I've built so far. Private Sub Form_Current() If Not...
  15. bvbowes

    Commit Action During Record Navigation

    I want to be able to add some code that gets run every time someone uses the embedded "go to next record" navigation arrow at the bottom of the form, is that possible? When users add some notes to an unbounded text box on the form the text will stay in each record they navigate to until the...
See more

Part and Inventory Search

Back
Top