Search results for query: *

And I'll just stop posting here so that we don't clash further. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

Well, I guess we'll have to agree we disagree (as many well-known Access people agree with me, so I have no qualms about it). Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

MajP - People always assume that errors are bad. They aren't. In fact, you can use them to your advantage. Now, using On Error Resume Next is a HORRIBLE thing to do as it DOES obscure the cause of many things. But, look at it this way - Even Microsoft has determined that ERRORS are not...

I've always just handled the Error 2105 which occurs when you try to go past the last record. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

assets - If you aren't using a split database then you are playing Russian Roulette with your data. Even for a single person use, I recommend splitting the database to a frontend/backend setup. That way if the frontend corrupts, you don't run the risk of losing your data. You can keep a...

It is interesting because I've never used that and have had it work just fine for me before. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

The control doesn't need to be on the main form for it to work but the subform has to have deletions allowed set to yes and the record source needs to be updateable. But what code are you trying to use and where have you put the delete button? On a continuous form I have put a button in the...

Also, you don't need to use the table reference if JobID from the Job Details table is the only JobID in the form's record source. But, you also have a problem with the table reference as it has a space and therefore would need square brackets (your bracketing is incorrect). So this...

Which version of Access are you using? Are you talking about the menu bar which lets you go up to WINDOW > UNHIDE > DATABASE WINDOW ??? If so, then you can set the option in startup options to not allow default menus. But if you do, you'll want to create your own (perhaps) so that they have...

Ebay can have legitimate software but a lot of it is pirated as well. So, it is buyer beware. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

Just a note - InstrRev returns the FORWARD character position (as if you counted from the beginning character) but finds the first instance of what you are looking for starting from the end. So, I'm not sure how you intend to use the Instr and InstrRev in this context. Can you break down what...

We solved this problem for the OP over on Access World Forums (where they posted a sample database). It turns out that Field1 was text and the entries were not consistent. There were some with spaces before the number and so using TRIM to compare worked. You can see the entire thread here...

RED FLAG, RED FLAG!!! New sales data should not be adding COLUMNS but instead should be adding ROWS of data (I hope you meant that and just spaced). Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

I agree with those who say + and & are not interchangeable in VBA. But I have something to say about the single quotes. Many times Business names have single quotes in them (Like Bob's Restaurant, Sam's Place, etc). So using single quotes when looking for company names is potentially an error...

Andy - Access doesn't have a macro recorder like Excel or Word does. Macros in Access are a completely different thing as compared to Excel. VBA is separate from macros when it comes to Access. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools...

Also - no you don't need the developer's edition to create an mde file from Access 2000 for an Access 2000 mdb file. However, your installation would need to be at the same Service Pack level or higher. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free...

Try decompiling first and then recompile. http://www.granite.ab.ca/access/decompile.htm Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free Tutorials/Samples/Tools: http://www.btabdevelopment.com

The controls are not part of the chart so they will not be there when copying and pasting. If you use a PDF copy of the report it should be fine. But just trying to copy and paste is likely just an exercise in futility. Bob Larson FORMER Microsoft Access MVP (2008-2009, 2009-2010) Free...

It could be a phantom breakpoint but it may be hard to find. If you know where it is stopped, if it is stopped on a line of code, then you can copy that line of code, put it above or below the existing one and delete the old line. If that doesn't work, or it isn't stopping on a particular line...

You can add two fields to the tables - One for LastUpdate (date/time) and one for LastUpdatedBy (text). Then in your form's BEFORE UPDATE event, after validating things are right, as long as those fields are in your form's record source (and the record source is updatable), you can use...