Search results

Piece of cake. Set the criteria for your ExpType to be the value you want. You can either do three different queries, or perhaps point it to a field on your form and let your user choose which value. Click on the totals button to show the totals row. For ExpAmount, instead of 'Group By'...

There you go - split it and you will be fine.

I'm guessing that your database is not split.

I'm not sure what it is you are trying to do, but the Left, Mid, and Right functions should help you out. These function return only parts of a string - for example: X = left(MyString,1,1) returns only the first character of a given string.

The enter key is probably being processed after the after update event occurs. So after all your code runs and sets the focus where you want it, then the enter key is processed and the focus is moved to the next field. Try using the OnKeyDown event to 'capture' the enter key and then cancel...

First of all, you way want to get some basic VBA skills. Do a quick Google search and some VBA primers or tutorials. That being said, you will probably find the Weekday Function to be helpful. It can take a given date and determine what day of the week it is. If you want a date field to...

Allan Browne's 'eLookup' function can be must faster than dLookup. Some people don't agree with this, but in my case it made things run 2 to 3x faster.

You've got a point there - Access isn't going to write it for you, you'll have to do some work - but it's certainly doable. I shouldn't be any harder with one location or thirteen - make the query and form once. Sounds like your table structure is already good to go. Just add a splash screen...

How does Access know where a user is from? Do they 'login' to an account that stores their location in a table? Do they choose their location from a list? If either of these scenarios could be used, then it's an easy matter of building a query that returns only records with a matching location.

Gemma, by 'ending' I meant that the code did not even get to the 'End Function' statement. No value was returned, and the calling procedure did not resume either. Turns out that the eval statement was not the culprit. It had something to do with the msgbox. At certain times on my form a msgbox...

Glad it worked for you.

OK. Conditional formatting is just about the only thing that allows you to have any difference in the layout of records on a continuous subform - but, you are right it can't make things visible or not - it can only change text colors and properties, etc... There is one other way that I know of...

To my knowledge, conditional formatting is just about the only thing that will individually format records on a continuous form. You may want to give it another try.

You could try Conditional Formatting.

I suppose it could be possible that it was an external application, however, as the bug was 100% repeatable, when certain conditions were met, it seems unlikely.

Good tip, Banana. This could certainly help me out with the "data has changed" errors I deal with frequently. My bug seems to have gone away... I'd feel better If I had solved it in a concrete manner, rather than it just disappearing - but at least it is gone. Thanks! Evan

I stepped through the code line by line. After the msgbox event it simply goes nowhere - just ends abruptly.

I too have encountered this error many times. While I never was able to get back into a form once it was corrupted, there were a few tricks I learned: 1) Backup often 2) The VBA code for the corrupt form was still viewable, so I was able to copy and paste my latest code into the backup...

Banana - thanks for the reply. First, I've ruled out the eval statement... Just a plain old message box will do the trick. It appears that something happens on my form, and then the next message box event will cause code execution to stop abruptly. MsgBox "1" MsgBox "2" In one...

This is really weird. I've been using this little function for years with no problem. It generates a message box where the first sentence is in bolt type (similar to the built in MS Access messages.) It has always worked until today. Now (and only in one case on one form), it will generate the...