Recent content by oblivion86

If I set it to long integer then it won't be populated when the user does the data entry, unless I set it to look up the same field In tblevent and tbl person. ?? Still confused??

Hi guys, I went through some of the posts on this forum and I think i got an idea how to complete my database and I just need some confirming from you guys. I would like to populate my junction table during my data entry. The junction table would include 2 fields, i.e.Event ID and Person ID...

Hi guys, I found a sample database that keeps a record of artists and the albums they appear in. I understand that this is somewhat similar to what I am trying to achieve with my event participant database. However, the greatest difference would be that for the artist-album database, it is...

Hi jdraw. I understand that I have to link the event tbl and the participant tbl with a junction table. However, my database is set up such that the user will key in the event details and participant details. I won't have a fixed data on which participant belongs to each event. So for data...

Thanks for your reply. However, I am a little confused, for this junction table that I require, what data is it supposed to contain? My database allows people to enter the event and the people associated with each event. What data then shall I input in this junction table (i.e. eventpeople)...

Hi all, I am designing a database for users with little to no knowledge of Access. Therefore, I would like to lock/disable the design view for my queries to prevent them from inadvertently making any changes to my query criteria. Is there a way to accomplish this? Thanks.

Hi all, I have 2 tables, Event and Person Particulars. In an event, groups of 2-5 persons may be tagged to this event by a randomly generated number (using autonumber). Let's say Tom (social security number: 12345X) is tagged to events 2, 5 & 6. There are of course other persons together...

hi guys, Thanks for your help, the bracketing method worked! I would like to also apply this to search for persons' age (e.g. Age from 14 - 25), just to verify the above stated query should also work right?

Hi, I some questions about how to query between 2 dates. I have a multi field search form which has [Startdate] and [Enddate] as one of the 2 fields. I understand that I have to use >= [Forms]![searchform]![StartDate] and <= [Forms]![searchform]![EndDate] in the query. This works fine if...

Thanks guys! Sorry for the long break between posting and replying, been busy with work, i shall try the solutions offered and get back with results. Thanks again.

Hi all, Is there a copy and replace existing records function in access? I.e. I would want to copy records from one table to another (with same structure) and replace similar records with in original table in the new records (which have minor ammendments made). Thanks.

Hi basically what I need is to import new records and update existing records that were updated in database A to database B without replacing them in database B. Thanks

Hi guys, I have 2 identical database in terms of structure but it differs in data. Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records. I have used the "link to datasource method" through importing the tables to have the...

Hi guys, I have 2 databases which are exactly the same in its structure but differs in its content/records. I would like to append data from 3 tables from database A to the same 3 tables in database B on a weekly basis without the duplicates. Each of these 3 tables contain the same unique...

yes anything they want with it. But usually it is just for attaching to email etc.