Search results

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...

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...

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...

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...

URGENT between criteria Does anyone know the criteria (code) for a query that only displays the records that have values between what I specify Any Help:o TIA Aron

Does anyone know how to insert a date field into an already existing report (todays date). This maybe a very simple question but it has vexed me! :o TIA Aron

(Hope this is the right forum) I have a database which I created with about 1000 records. (Records imported from Excel). These records are all in one table, I have another couple of tables with no data waiting to be filled via a form. My problem: Now that I have added more records to my main...

I have a form with fields like Company Name on it. I wish to be able to type a company name into that field when it is blank and Access pull up that record. Is there any way of doing this? TIA Aron

(Hope I'm the correct forum) I have a template (word dot.) with field names in all the right places. I want to create a button on my form that when clicked will throw open this word template and populate the fields with the currently active Access record. However I am unsure of how do this. If...

I hope this is the right forum. I wish to insert a few fields from my database, such as address, into a word document. However when I try the "merge it with MS Word" and "Create new document" option I get the message: File could not be found. It suggests trying another file and checking the...

Hi, I'm relatively new to Access. I have a form with customer details applenty. I want to be able to have a button on this form which, when clicked increments itself by 1. This represents the number of phone calls a particular record has recieved. (The value held by this counter then needs to...