Recent content by aronw

That is exactly what I was after. Thanks PaddyIrishMan for the rapid response. Aron :D

OK, I need to be able to change the control source (query) at the click of a button on / for my forms. I have 3 tables that are joined with a query and populate my forms currently. I have created copies of these 3 tables which are identical except the name of the tables. Basically I wish to be...

The answer to you questions is yes, the Pk & Fk are the same ID (autonumber) fields, which due to the fact I have no unique data are in each table. Both the forms record sources are a query (the same one). All my forms are form in their own right, connected together via command buttons. Thanks...

I have a problem. I hope this is the right forum to mention it in. It appears to be a problem with my form writting data to 2 of the three tables I have. This problems only occurs with the new records that create through my forms. What happens is that although the forms seem to retaining the...

Just wanted to know if by creating a simple query i could get / copy all the details attached to a record even if they are not displayed in the query. Thanks for the help, I now have a number of methods to exprienment with. If they don't work I will be back. Aron

Some of the users on the DB have been working on the backup version of the same DB whilst others have correctly been using the original copy. Here lies my problem, I don't want to overwrite the work that has been done on either DB. Simply update a few hundred records.

does Access link the fields? The second option sounds much more like my Access skill level. Thanks, there are about 20 fields attached to each record spread over 3 tables. If I created a query which I have done, would it need to include all the fields? Or would Access link the relevant data to...

Hi, this might be a simple bogal but, I created a query that selects some records bases on 3 fields. (I have a number of fields in a number of tables. All my data is linked together via Accesses very own ID auto-number PK.) Out of my 75,000 odd records 251 pop up fitting my criteria. Now, I...

just to check, Thanks, have changed the global record locks setting to 'editted locks' you mentioned checking the record lock properties for the forms. Just to check, where you suggesting these be changed to editted as well? They are also currently on 'no locks'. One of the main conflicts...

yep Thanks once again, thought so Aron

it is strange... My default record locking was and is set to 'No Locks' and my default open mode was shared. Is that always the case, (if another user is using) is there a way around this. I'm not very Access knowledgeable yet but I have setup this DB and about 6 people are using it. I get all...

I wish to create a query that only displays the records that have a certain piece of text in a field. Query syntax is not my strong point. I have an 'interest status' field which has about five options to choose from, one being 'top ten'. So how do I query all records where the interest status...

I created a DB a while ago, now coming back to it I want to make some changes to it. However i'm not allowed. Firstly if another network user is using the same DB it says, "Couldn't save; currently locked by user Admin on machine ..." Secondly, when every other instance of the DB is closed i'm...

thanks ;) Aron

Thanks