Search results

Is it possible to develop a genealogy app in access? :D

Relationships are betwen tables. Entering date is made using forms (this is the idea of an app: user dont have to access tables). Viewing data is possible by reports (same logic). To answer your question, you can see the payroll data using a report (or a form).

Back on topic: i suggest ono to one relationship betwen notes table and junction table. Judging by the main discution in with you talk about a field in junction table, i guess that is only one note for each transaction.

I understand the balance that you bring into discution, but what i am saying is that you dont have to do it by putting yourself in Jon shoes (no offence, Jon). None of us should do that. Why? Because we dont have all the infos to do it. All we can do is debate the merits of the suggestion. So, a...

Da, din Bacau sunt. Ma bucur ca mai este cineva din Romania pe aici.

My recomandation

I think that you should use AND because you want the message "data missing" if all the fields are empty. This is the way i see it. Am i wrong?

Off topic: when you know that you know a little access? When Pat Hartman agrees with you! :D Dhalsim, you know that the suggestions are for a better normalization of your db, right? I'm glad that you found a solution for your problem, but maybe you should take some time to look over Pat's...

Right, Mihail. That is the idea. Like a market where buyers and sellers can meet, without pretending that there isn't a transaction happening. @Pat, be sure that the site owner's offer is much to expensive for my cd collection app that I need (just an example). On the other hand, i am willing to...

Here is the place whre wesuggest things and the owner and/or admins make use of our suggestions or not. I think is wrong to assume what they can or can't do, what they are willing to do or not, what they can afford or not.

I dont see the use of 2 tables. You can add a few fields like ILL and DEAD (names are only for exemplification), Yes/No fields.

In table 2 you dont have to enter car number, because the is a link betwen car and card. You should mention that a card is used by only one car or by many (drivers, whatever). Also, a car can use more cards? This kind of info are mandatory for db design.

You can use a unbound textbox to enter the date and a bound textbox in witch you use a formula to add 12 hours on the value you entered in the unbound field.

Take a look on this thread and see if it helps you.

I understand Mihail's sugestion. And i suport it. The people has to understand that they still can copy the code and put it in there db without having to delete the line number. I guess that is the fear of the against-people.

Pat Hartman is one of the reason i suggested a freelance section on this forum. http://www.access-programmers.co.uk/forums/showthread.php?t=249717

Suggestion: the badge on the donnors should be linked to membership page.

Like everyone here, i suggest also not to use a separate table. If you insist on doing so, you will have to take in the consideration the possibility to move records from sold parts to (unsold) parts also. Too much unnecesary work.

But if i tell you that i need a database for a dental lab, and i would like for someone else to do it, will you do it for free, the hole app?

I think that such a section will be appreciated. I guess that are a few members willing to pay for a app, or a part of an app, and there are a few mwmber that will like to be paid for this kind of things. I would like to practice my skills on real projects, with credit for my work. What do you...