Recent content by jpstroud

I've never had a problem with modifying the events. As long as you know what syntax Access uses to name the events, it's fine. The only problem that comes up is knowing what parameters, if any, it asks for (which I had forgotten to remove in my case). If it turns out that things aren't working...

I came across a problem this morning where my DB code would display the error: "The expression On Load you entered as the event property setting produced the following error: Procedure declartion does not match description of event or procedure having the same name." as described in post...

I'm attempting to help a friend with their computer and I'm at a loss as to the cause of the problem as I've never seen this before in Windows XP. Whenever we attempt to install drivers, software, (almost) anything, we get program hangs and end up having to quit the program. This is primarily...

Sorry, I went into the locations in the next sentance. We have categories that libraries are filed under, and in the majority of the cases we've filed folks under one category only. I'd like to be able to have them listed twice when the information is queried. The person who is in charge of...

Actually, the header is a bit misleading. I need to duplicate specific data from the same table, while changing only specific data. Let me explain. I have a directory database that I maintain (note, I can NOT change the database structure - just the data) on a SQL server. I have made an access...

Let me know how it turns out for you. It worked fine on my machine, but I have v2002. Not sure what you're running.

Sorry, place it on the Form_Current event for your form. If you just drop it into the form's VBA module itself, I've already included the Private Sub.... lines. Just make sure the On Current property is set to [Event Procedure]. The code will check the current form whenever the form has the...

Try this on for size, adjusting fields for what you need of course: Private Sub Form_Current() Dim MaxOrderNo As Integer, NextOrderNo As String, rs As DAO.Recordset, db As DAO.Database Set db = CurrentDb 'initializes values Set rs = db.OpenRecordset("SELECT...

It would have to be a text field in that case. To increment the number, you would need to write some code. What is the table name and the field for the Order number? I'll post some sample code here for you.

It would save as the number itself, ie.. 1234, 1235, but would display with the leading O. Also, if you have less than 4 digits, it will substitute zeros for the missing digits (ie, O0023, O0024). Again, this is in the display only. This has the added advantage of not taking up as much space...

Forgot to say, use the code I posted above (without the comment) in the data property of a text box to get the desired result. Not sure how familiar you are with access, so I just wanted to drop that piece out there :-)

If it's just for display purposes, you can make the field an autonumber field. On forms and reports, instead of using the field itself use: =Format([fieldname],"\O0000") 'first character after slash is the letter O The autonumber field will increment with each new record, and the data will...

I've normalized as much as I'm able given the constraints. The issue itself is merely a matter of attempting to concantinate stings together. What would you suggest that would help me accomplish this?

The data that I have has certain options. I've normalized everything as much as I can while still staying in the guidelines that have been set forth. Since I'm not the end user on this, I have to stick with what they will be able to understand and utilize. The form that sets the data requires...

Essentially, I want to compile a list of options that were checked into one text box instead of having to list out each and every check box. Instead of having: ___ Academic _X_ Public _X_ Government ___ Special on the report, I want one field that says: Public; Government Any thoughts on how...