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 derfloh 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 Shiner83

  1. Shiner83

    Form closes when ESC is pressed - How to disable this?

    That's it RoyVidar that was exactly my problem! :) I knew it was something simple, but I just couldn't get it! Thanks!
  2. Shiner83

    Form closes when ESC is pressed - How to disable this?

    Should be an easy one, but for whatever reason I have a form that always close when the ESC key is pressed. It is weird since all of my other forms don't have this problem, and I've compared the structure of these and I haven't found anything that could cause it. I would prefer that pressing...
  3. Shiner83

    Big problem - ""ME."" doesn't work anymore!!

    I think I found the culprit. The references, and Access 2000! Yesterday I opened my database on the network with Access 2000, instead of the Access 2003 I used to create it. You were right about the reference, I went there, and even if they seemed correct, I modified them a bit and now my...
  4. Shiner83

    Big problem - ""ME."" doesn't work anymore!!

    Hello, I have a big problem with my access project, and it couldn't happen at a worse time. I've been working on my project for 2 months, and it's been working fine and I was supposed to finish today. BUT... I had the horrible surprise to realize this morning that my project didn't work at all...
  5. Shiner83

    2 questions about exporting to Excel

    Thanks for the pointer, I was able to do what I wanted for my first question. However there is some things I don't understand. First, here's the code I use: If fIsAppRunning("Excel") Then Set MyXL = GetObject("C:\Access\table.xls") If Err.Number = 0 Then...
  6. Shiner83

    2 questions about exporting to Excel

    Hello, I need to export data to Excel from Access and then open the Excel sheet. I have been able to find a code that works well enough, but I have 2 problems remaining that I can't solve. 1. If I try to open the excel sheet and it is already opened, I can't and Access freeze. I was able to...
  7. Shiner83

    Writing conflict when updating records

    Thanks! These boards have been so useful! I've been lurking for about a month and I was able to get answers to almost all my questions with the search function. I would have had much more troubles with the project i was engaged for if I didn't find this place :) As for the best place to...
  8. Shiner83

    Writing conflict when updating records

    Perfect it now works just fine! Should I use the DoCmd.RunCommand acCmdSaveRecord command everytime I open a Recordset? I haven't found problems elsewhere where I didn't saved the record, but they might be some hidden problems if I don't...
  9. Shiner83

    Writing conflict when updating records

    Hello, I have a form that lists towns with a control named Reference Date. When I change the Reference Date, a message box appear, giving the choice to apply this date to every town, or just on the current one. My code works, but the problem I have is when I change town, I get a Writing...
See more

Part and Inventory Search

Back
Top