Formulate Index Value

[NeoPa]

Did you run a Compact & Repair on the db before zipping it. This can also save much space.

If the size is small enough you can attach it to a post (assuming it's not sensitive). If it is let me know. I have been trying to arrange an email address that I can give out more freely, but it's not arranged yet.

I'll get back to you when I can, if you are unable or unwilling to leave a copy in the thread.

[NeoPa]

I found your instructions on how to post a reply with an attachment elsewhere. Let's see if I can follow these instructions accurately.

I did it. Here is a copy of my database.

Forget my last post - I hadn't seen this.

I will get that downloaded and shipped off home (I don't ever look at member DBs at work).

Let me know if you would like the attachment removed after I've downloaded it.

PS. Well done for attaching the db :)

[MNNovice]

Yes, please remove the attachment after you have downloaded it.

May I know where you are located? The reason I am asking you this is because if I respond to your feedback after 10am (CST, USA), I don't get the responses until the next day.

Take your time. I am avidly looking forward to your responses and comments on how did I do on my first Database job. Thanks.

[NeoPa]

This would make sense. Click on my avatar to be directed to my profile.

I will probably get a quick look tonight. Very busy evening with TWO UEFA matches including English clubs live on the TV.

Before I get to that, can you post some quick instructions as to what I need to do to get to the relevant part of your database when I open it?

[NeoPa]

May I know where you are located? The reason I am asking you this is because if I respond to your feedback after 10am (CST, USA), I don't get the responses until the next day.

Reading that again, that seems unusual. I'm GMT (or +1 ATM = CST+7) and I do some posting while at work (takes me up to 18:00 typically), particularly during my lunch, but I'm also frequently at my PC until 01:00 / 02:00 of an evening.

That's not true of every day certainly, but more often than not. Last night was a Wednesday so I was out most of the evening mind you.

[MNNovice]

My database opens with a switchboard. Select the first item from the Main Menu (ie., Enter/View CD). This will take you to the form called frmCDDetails. Let me know any questions you may have.

So what is your favourite team? When I was back at home (Bangladesh) we could watch football on weekends. I remember watching Liverpool, Arsenal (sp?), Manchester...bu t that was 21 year ago. Soccer is not that popular here and I don't particularly like American sports. Used to watch cricket a lot too.

Thanks.

[NeoPa]

I support Tottenham Hotspur (The Spurs).

Not a good night for us - we won 2 - 1 at home. A poor start to the season.

[NeoPa]

I suspect you have some VBA Editor settings set wrongly (not helpfully to find problems).

Select Tools / Options / General from the VBA Editor. Make sure Error Trapping is set to Break in Class Module.

Now when you run this do you get any more information?

[MNNovice]

Based on your instructions I checked the box for "Break in Class Module". It was set to "Break on Unhandled Errors". What's the difference between these two? Just curious to know.

No compilation error. Nothing displays in my txtCDID box either.

Awaiting your response. Thanks.

[NeoPa]

I suggest going to the screen and pressing F1 for the details, but for interested parties, the relevant exerpt is :

Error Trapping

Determines how errors are handled in the Visual Basic development environment. Setting this option affects all instances of Visual Basic started after you change the setting.

Break on All Errors — Any error causes the project to enter break mode, whether or not an error handler is active and whether or not the code is in a class module.

Break in Class Module — Any unhandled error produced in a class module causes the project to enter break mode at the line of code in the class module which produced the error.

Break on Unhandled Errors — If an error handler is active, the error is trapped without entering break mode. If there is no active error handler, the error causes the project to enter break mode. An unhandled error in a class module, however, causes the project to enter break mode on the line of code that invoked the offending procedure of the class.

[MNNovice]

Sometimes for a novice like me it's easier to undertand when things are explained with examples. I get lost in jargons. "Unhandled" , "Class Modules", for examples, in this chase. Eventually, I am sure, I will get there.


Thanks for posting the HELP note. I sincerely appreciate your time.

[NeoPa]

The difference is that Break on All Errors will not break within a class module. You will simply get the code stopping at the line that last invoked a routine from a class.

You need Break in Class Module if you're developing any classes.

[MNNovice]

Hello NeoPa

Did you get a chance to download my Database? I am waiting for your instructions for the next step.

Thanks.

[NeoPa]

I did. I have been having some very strange experiences with it.

Ultimately though, I can tell you a number of things which are wrong, but not test it properly, as you haven't yet explained how it should work (from post #49). Your instructions take me to the form, but how to use the form is not immediately obvious (I wasn't able to work out the logic of it).

What I will do, until you can explain this, is to drop in a few observations on your database in the hope that it will be helpful.

Firstly, the switchboard effect is really impressive. I've never used an automatically generated switchboard myself. I will think about using it for my next database.

Secondly, all for now, you can arrange for the main database window to be hidden completely if you would like (I do in my dbs). Simply go into Tools / Startup... and deselect the CheckBox. Using F11 will show it for you if you need it.

[NeoPa]

On your form (and in your table) you have a Serial No - AS WELL AS a CDID. I can't make any sense of this.

I thought we were looking at ways to create an index value for a new record. I can see no way to get to where a new record is added. Instead, the code seems to be executing for EXISTING records. I cannot see why this would ever be necessary.

This database seems to be a great idea, and, from what I can see of it, is well implemented with some good ideas at the heart of it. HOWEVER, there seem to be some misunderstandin gs in the technical design of it that should really be ironed out before proceeding with the niceties. Otherwise you are building on sand.

The basic logic flow of the project is what I have in mind. How are records added? What can/cannot be done with existing records? I think you need to give this some thought (or maybe just explain to me what I've misunderstood).