Recent content by jgnasser

Forum, I have an array that has 821 values. I need to shuffle this array so that the elements are rearranged randomly without being repeated. I have seen a couple of codes which claim to do just this but do not seem to work well, I end up with some values missing. One such code is here...

I am trying to use a VBA code in access which has this subroutine that opens a dialog to select a folder. However it fails on the first line saying Runtime error 429: ActiveX component can't create object. I know this has to do with a library reference missing or something but I am unable to...

Thanks, this worked as intended.

I have this simple table with three fields - Date, User and Amount. I want a summary to show the total amount per usser per month. How do I do this?

I lost a replica master and converted on of the replicas to a master. I am now creating new replicas but one query does not run in the replica saying runpermissions are denied for the user. How do I sort this. I have also read of a 'Replication Manager' that should be used when moving a...

Actually this lists one article as many times as the number of authors but I needed it listed just once.

I have three tables; Articles, ArticleAuthors and Authors. The Articles table has a list of journal Articles with a primary key field of article_id. The Author table lists all authors, with a primary key field author_id. The ArticleAuthors table links the two, it has foreign keys for both...

I have a table (result of query) with three fields; sampleID, taxonomic group and locations. The data is similar to this: SampleID Location Group 1 Mpala Ascarid 2 Segera Cestode 3 Mpala...

Pat, I have searched and found the thread om Many-tomany relatioships and downloaded the zip file but just like all the other zipped files I have downloaded from this forum, I cant open it, I get an error that its an invalid archive. I hope the fact that I am downloading into Linux and opening...

Thanks The_Doc_Man for this contribution. The third table you added was really crucial. I have taken a shot at it and it works but with 2 wrinkles. First, when I query for a particluar book, in order to get both (or more) authors, the book has to be listed twice. Any way round this? Secondly...

Here is a fundamental database design question. I have learnt that one of the elements of good database design is to avoid redundancy by creating more tables and referencing them using foreign keys. The query I have then is what is the procedure of data entry? Take a look at this example...

I am trying to create a family database and all I can figure out is one table with details of each member. The difficulty I have is how to create relationship eg two persons (records) would be related like x IS CHILD OF y, a IS WIFE OF b etc. I would like to be able to do queries like to...

I have a replicated database that exists at two sites. The users enter data and periodically synchronize. There are chances of duplicate data entered by either user and I would like to drop one of the duplicate records after synchronizing. I would base this on selected fields (say 3 or 4...

Thanks all for the input so far. I'll give this a try and see how it goes.

Database deisgn I have been given a task to create a small database to keep track of the activities of our small group in which the members give contrinutions per month and borrow money. One table I'm sure I need is 'Members' which shall have details of the members. When it comes to recording...