Search results

Hi, I have a simple form that has two buttons on it. Button one closes the form Button two opens another form What i would like, is, When i click on button two, it opens the form i want but closes the current form. Can anyone offer any advice? Thank you Rgds Bev

Hi, I have created a form to be used for data entry, Where i have identified standard data, I have set the Combo Box on the form to be a "Value List" so as to standardise the data entry. This creates two problems for me. 1. When Using the form, instead of saving the text value to my table...

Hi, I am seeking a little help with a query. I have a master table that holds all of my data. The table details what qualifications someone is holding. I would like a query that would enable me to produce a list of people who DO NOT hold a qualification. Is there anyone out there who may be...

Hi, I am trying to create a new DB from scratch and need a little advice. I have asked the same question in the query section, in the event that my answer lies there and not in the report. My aim is to chart the career history of many people in my DB and my intention is to achieve this with...

Hi, I am trying to create a new DB from scratch and need a little advice. My aim is to chart the career history of many people in my DB and my intention is to achieve this with two "Main" tables with many smaller tables linked to it. Table 1 will contain the generic data about the individual...

:banghead:Hi, I ahve no idea where to start on this one so I am wondering if anyone could help me with a task that I have? I have a list of names that I need to split down and allocate to days (Work Roster) this is a very time consuming and mundane task that i have each month so am looking to...

Hi, A general curiosity really, My current DB I am working on has 4 tables, 5 queries, 3 forms and 4 modules. At spent I have less than ten records stored, with only 15 columns per record. My curiosity is to understand why my DB is close to 6MB in size when there is little to no data within...

Hi, I need a little help please with form validation. My form is linked to a table for the purpose of recording vehicle details, owner, make, model, van etc.... I would like to have a button on my form that ensures all fields have been populated, confirms that the VRN does not already exist...

Hi, i have a simple table that is populated from a form. what i would like to do is have a button that when pressed would add the new record but then subsequently run a report that is linked to a query to pull up the latest record entered and then print. i would like all of this to happen...

Hi, I am writing what is a very simple DB to issue parking permits. I have a form that when loads goes to a new record. What I would like is to have a button that when pressed, does the following 1. validates that all required fields have been populated, 2. Runs a report based on the new...

Hi, I have a workbook with several worksheets. The first sheet is the summary page that purely shows percentages that are cells displaying the contest of the cells on all other pages. What I would like to do is use a little VB to shade the cell dependant upon what percentage is displayed...

I need a little help please, My workbook has many worksheets, all of which contain various pieces of data. each sheet has its own formulas and are working well. the first worksheet in my workbook is a summary page to show graphically how each of the sheets are doing eg: sheet 1...

Hi, I have a Workbook that contains 6 sheets. five of those sheets are updated regular and the 6th is there to consolodate. the 5 sheets are updated using a Module that deletes the existing sheet and imports a new one that is more up to date. all sheets remaind named exactly the same at all...

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

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

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

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

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

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