Search results

Good advice. Thanks. But I don't see how this is basic. Here's an event with error trapping code that's not trapping errors... And I've already bonked my head on the desk, and it hasn't helped.... ;)

Hi All, I've decided to start from scratch, and build a new database that demonstrates the problem I'm having. The test database, attached, has one table with two columns, "FirstName" and "LastName" along with one Form, named "Test1." I created five record navigation buttons on the Form, by...

No, you didn't. I should have said I tried OnErrorNext first, and it didn't help. It just seems to die on DoCmd.GoToRecord , "", acNext no matter what I do. I think that all I've accomplished was to move the problem over to VBA, but not solve anything. If my feeling is correct about the...

Ummm... I'm thinking I'll wait on that, but thank you for asking! :) I've got enough trouble on my "Can't find a way to trap an error" thread! I think that I'll self-implode before that's finished and working... :|

Hi spikepl, I did what you suggested, and removed both the "On Error GoTo btnNext_Click_Err" and the "On Error Resume Next." However, it still errors on DoCmd.GoToRecord , "", acNext This thing is making me (more) crazy! Should I just put in code to move to the next record, rather than rely...

Hi MSAR, Thanks for the kind words. I suppose I won't slink, then. Just sulk... :) Seriously, I'm glad that you all corrected my post, and I did learn more by having participated in the discussion. Some members in other forums are quick to tear apart someone who offers bad advice...

OK, so you can't get rid of me this easily... I converted the macro to VBA code. Here's what I did: 1) Open the form in Design View 2) Click on the DataBase Tools tab up top 3) Convert Form's Macros to Visual Basic 4) Accept the defaults in the msgbox, and click OK. 5) Macros are magically...

Hi All, You are all correct! I was thinking that the network traffic wouldn't be a big deal, since it was only the application front-end that was moving, but that's a valid concern. I was also thinking about some code that would compare the application date on the server with the one on the...

Hey spikepl, Good question, and exactly why I was confused! I'm guessing that the sequence of events is: 1) Make a change to the record 2) Click "Next" 3) The macro behind the Next button fires, and starts the "move to next record" process 4) The "Move to next record" process detects a...

One more thing... I have no code in OnCurrent. And setting a breakpoint in Form_BeforeUpdate showed me that the error message was popping up after Form_BeforeUpdate was done. Further, single-stepping through Form_BeforeUpdate showed that the error message was not being generated by VBA, since...

OK you two, I think we've got it! I'm using a "split form" with the datasheet below the form. On the form, I have First/Next/Previous/Last buttons, each of which has a macro attached to it to move the record. It is in the macro that I have the msgbox pop up if there's an error! If I use one...

Hi vbaInet and spikepl, I really appreciate your help! I think we're zeroing in on the problem! "I don't think the error message is coming from that event. It's kicking off some other event." Yes, that's what I've been thinking. But I couldn't figure out where this error message is coming...

Hi Trueness, I have an idea. Why not put the application in a shared directory on the server, then point each workstation to the application there? This way, when you need to change the application, all you have to do is update it on the server. One possible problem with this scenario...

Hi Again! Thanks for your continued replies. I have done as you suggested, and still get the same error message. I'm out of ideas! ;) Thanks!

Hi Aron, How's this project going? I think that LagBolt has given you the best plan, setting up tables as he suggested. (Though in addition to Benzine and Grenadine he forgot to add Chocolate Syrup) You want to have this set up so that the entries can be made at any time, and can refer to any...

Hi, Thanks for the reply! I've tried all of the following keys, and nothing happens: F9, F8, Shift+F8, Ctrl+Shift+F8, Ctrl+F8, Ctrl+F9 Is there another "Debug" key I'm missing? Note that the error msgbox has only an OK button, not even a Close "X" button, so there's nothing else I can think...

Hi! Good that you've got this one already figured out! I've got another method to add to the great responses you already received, for anybody else that may have a similar situation. Whenever I'm faced with something like this, I make a quick copy of the database, then use the copy to try out...

Hi Benjamin, Sounds like you're starting on a fun project! It also seems that your questions fall into two categories: (1) How best to set up the tables and their relationships and (2) How best to retrieve the data. First, you're on the right path by asking questions about the tables and...

Hi, Some more detail on the Replace() function: This should do the trick: Replace("B25601 - 111128 - 1"," ","") If the string is in a variable strReferenceNumber, then this should work: strReferenceNumber = Replace(strReferenceNumber," ","") Note that there's a space between the first...

Hi Everyone! I've been looking at this forum for a while, but hadn't registered until today, since I have a question. I've been using and programming Access since 2000, have a long-standing hate-hate relationship with it! I also program in SQL, VB, as well as web-related languages such as PHP...