Search results

Hi Gina I tried to figure out what is going on in the questionnaire response section but it seems I am completely missing something. I am baffled by the fact that when I look in the design view, I only see a single line but in the form view I see all the lines for that subject. Looking closer...

Good afternoon. I am struggling to get a data entry form to work the way I want it. Basically I have a number of questions that have been answered by a number of participants. Still being new with access I have set up the tables and relationships as I believe they should be. I have attached a...

Just today I learned something about using networks to link FE and BE. Apparently if you use the UNC path it improves the connection speed. In my case between Denmark and India. Search wikipedia for the explanation as I can't insert a link yet. I am sure some of the gurus in here can shed more...

I hope Irene will not be too bad when she hits you After thinking on how you solved your problem, I think I have a way of solving mine. By arranging the tables as set out below, do you think it would work? Table for inspection type: Autonumber (PK) Inspection type (Could this serve as the...

From the relationships it also seems complicated.... In some way it seems similar to what I am trying to do so I will see if there is something I can learn from thinking on it.

Since I am at the level of an apprentices apprentice that sounds quite complicated. Would you mind enlightening my a bit on how you cracked such a nut?

More or less. I initially thought the title of the subchapter could serve to differentiate the subchapters but since the same title can occur more than once in the same chapter that idea is out. The problem occurs when we receive the observations. They are just listed by the number and it would...

Not sure why line breaks refuse to work so apologise for the messy text

Hi everybody. After giving up on my last attempt at learning access, I have decided to come back for more. I have decided to try to make a database that will help us analyse the various inspections that are carried by outside companies. I got most of the basic tables needed for this figured...

Hi again MStef I have been studying the example you created for and think I got it more or less worked out. From what I can see, this is what you have done. You made a module that could count to for each member and species using the of command. When either the member of species changed, the...

Thanks MStef, that actually look pretty simple. I'll be looking more closely at it and see how I can adapt it for my use. I have never been friends with access before but decided it must be something I can learn from making a fish catch database.

I have decided to try and build a database in access 2000 for keeping track of the catches we get in my fishing club. We have yearly competition where the top 20 catches of each species give points to the overall competetion. Each member can only participate with his top three catches. While I...