Search results

Thank you for your reply, I have tried your segestion however it is not working for me? Although i gave the example of ECDL, i do have many may qualifications, some of which are very similar. When searching for someone who holds a qualification i am using a Like criteria in my query. I...

I have a db that holds many thousands of records. Predominantly it is showing me an individuals name and what courses they have attended. (It is basically an excel spreadsheet which I have imported into Access in order to utilise the Queries to give me the results I need) If for arguments...

Hi, I hope that someone out there can help me with this I have a Spreadtsheet with dates in column E. What i need is for the cell to change colours based on age for example, if more than 18 monthes have passed then it changes red If it is only 12 monthes then it changes yellow and less...

Thank you for your reply, however I am lost with your advice. I have simplified things by createing a query based upon a querywith only three fields: Employee number First name Last name Now even though I am not querying the other data, I am still receiving many instanced of the same name...

Hi, I have a main table that holds names and qualifications. multiple qualifications can equal the same trade so i have created a query that shows me all of the names that hold the one trade. my problem is, if one name has three qualifications then it will show three rows with the same name...

I was curious to know if i had explained myself correctly or not? and the answer is that i obviously did not. my table has many column that all contain data however i wish to run a query that is based upon two of them. The first criteria will just select one entry from colum one, however i...

Gentlemen, I am having a little trouble with what seems to be a complicated query. My problem is that I have a table that has a column with 23 unique entries. And a column with 6 entries. When I run my query I need it to first filter by the column with the 6 entries and then subsequently...

WAZZ I think we are thinking along the same lines, even if i didnt explain myself correctly in my first post. My solution would be to have a tbl_qualifications and to use a combo box, but as highlighted i did not creat this and am now just trying to ascertain if it is possible to achieve the...

I have been asked to help with a database that someone is writing. He has a Table that has 200+ columns and approximately 70 of those columns are Qualifications. The first few columns are Title, Forename, Surname. What he is trying to do is query the table to find all people with a specific...

Gentlmen. I am sorry for not replying sooner, I wanted to inform you that i have implemented the UNC Path and my db is working fine. I now have my FE / BE working fine, although a little slow but this i beleive is due toi my network and not the db. thank you once again for your help. regards Bev

Gentlemen, I have done the compact and repair option and it has reduced my db size for 100 + MB to just 2 MB which is fantastic, Can anyone tell me exactly what it is that has happened by conducting the compact and repair procedure just so that i know in my own mind? I find it amazing that...

Bob, I do have a few macros, forms queries and a couple of modules but all of this is standard! My forms are straight out of the can with a plain white background and no inages in the entire db. I have not as yet tried the compacting databse but shall do when i get back to work tomorow (I...

Gentlemen, I have split the db by going to "TOOLS > DATABASE UTILITIES > DATABASE SPLITTER" This created the backend with just the tables in it and the front end has everything else with linked tables (table symbol with an arrow on it) does this change anything????

Ladies and Gentlemen, I have my db stored on a server and have split the db so that i can have a front end back end scenario. Prior to splitting the db the size of it was 104 MB (yes quite large) after splitting the db my back end is only 7.5 MB with the front end sitting at 104 MB? this...

Phonic, Rabbie, Thank you for your guidance, I shall try the UNC version as my network is a security clamped design that I personally have little controll over. All going well this will work? By doing this, will there be any limitations to the ammount of users I can have accesesing the db at...

Gentlemen, I have a single database that I would like many people to use concurrently. The db will be stored on a security clamped network with my users logging on with there own individually user accounts. Does anybody know the simplest way of creating a distributable user front end that...

OK, I have sussed it, and in doing so have highlighted the age old statement of "RTFQ" Read The ........ Question...! Amazing as it is, when i re read what had previously been posted and digested it, i surprisingly managed to get it working. Thank you once again.

Erm.....???? Rural Guy, This is good news, however i have just tried this and my pea for a brain is not getting me to a working solution? I have a query based upon a table that looks at the field DOB which is formatted as dd/mm/yyyy I have placed the two different types of code in...

Bob, Could this solution work for what i am trying to do? I have posted a question in the Modules and VBA Section. Regards Bluenose

Hi, My db amongst other things hold date of birth information for many people. What would be great is if I could somehow get the db to automatically inform me, say, a week in advance of an impending birthday so that my user of the db could then fill out a birthday card and pop it into the...