Search results

To be honest, where i work, (even though we are a large organisation), we have very poor IT support department. To create the database I had to build it myself. I was therefore unsure as to what Access could do and had already set yup and been working with Excel for months.

Afternoon. I have a spreadsheet where certain cells are formatted to change colour depending on the values in them. For example, one column is for cholesterol and depending on the cholesterol level the text in the cell will change from Green, to Yellow to Red. I have also started managing...

Hello. My Access (2007) knowledge is very basic. I have a form with a sub-form both linked by a subject ID. The form is for Personal Details and also records personal information such as weight, height, Blood Pressure etc. On the top of the form I want to create a filter where I can search...

Hello. I have a form and subform linked to two tables by a unique subject ID. What I want now is; on my main form I want tocreate another subform (again linked to a new table through subject ID) with a list of tick box with questions such as; Urine check normal? Alcohol reduction advised...

Me again.... I get what you’re saying, but I can’t work out how to do it. I’ve built a query, and, in “design view” in the “criteria” field I don’t know what to write in order to get it ask me for, for example, “surname” or “participant number” as a search parameter??? I’ve managed it with...

This is my last question before my world (well, database) is complete. I have made a database that records client’s personal details (name, sex, address, DOB etc) and, in a separate table, personal measurements (test date, height, weight, BMI etc). These are linked by a unique participant...

Right. Situation is; I am using Access 2007 for the first time (and Access in general) for the first time in many a year. I’ve created my tables, forms, quires and reports. However, on one of my report I want more details (text) regarding the value. For example, one of my reports prints...

Right. I’m building a database after not really using them since school (2001). What I’m wanting to do store Personal information (age, DOB, sex, name etc) and track weight-loss details (Height, weight, BMI etc). Therefore, I have 2 tables 1-Personal details 2-Testing details The tables...

geeeeezzzzzzzzzzzzzzzzz where were in last week? you absolute legend next question.... I’ve created the subform from one of my tables. However, when i enter data i want Access to automatically update the source table. I thought i would do this automatically, but its not. any...

Morning all. I’ve been tackling this for a few days now and keep hitting a brick wall. I’ve tried learning MS Access using the video tutorials on the MS website What I’m wanting to do is create a database where you can record the body weight (on more than one date per user) of multiple...

As the title says really. wanting to add a find tool to a form, ie so i can search by surname like the one you can use on the MS Ribbon. many thanks B

Hello. First post so be nice. Not used Access since A Levels and not used 2007 before. I am currently editing the “Contact” database that you can open/download from MS when you open up Access. What I’m wanting to do is create a database with personal details (name, age, sex, job, job...