Search results

Hello. I have a table that is displayed as a sub form of a main form (ie main form is cleint details, the subform are the results from a medical test) Anyhow, some of the data (medical tests) in this table requires a number to be recorded with 2 decimal places. This has been set as such in...

Really stuggling – novice building a database. Hello. I’ve posted a few times in various forums, but I feel I really need to go back to the start with my database here. I am rebuilding (from scratch) a database where you can track an employees’ health measures. These include things such as...

Hello. I’ve built a database. I have two main data entry tables; one called “personal details”, one called “testing”. In the personal details table, I have fields such as; Surname, Name, DOB, Phone number etc…..there is also a staff ID number field (this is unquie to that staff member). In...

hello all. I am rebuilding a database that I set up years ago and have therefore forgotten most of the stuff I learnt. I have two tables, one for “personal details” and one for “test data”. I have set up a relationship based on the link between staff numbers (these are unique to the staff...

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

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

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