Search results for query: *

Hi, I have a spreadsheet with a cell (D13) which AVERAGES a column of data. This data column is updated frequently but not on a routine basis. I want to capture the value from the AVERAGE cell(D13) and copy the value and current date to a table on another sheet each time the data column is...

Hi, I have an excel spreadsheet with some conditional formatting based on expiry dates. The column headers are: Column E - Date Defeated Column F - Expiry Date Column G - Date Re-instated The conditional formatting covers column F and changes format based on the following: If cell is blank no...

Hi, I have an excel worksheet that I use to list stock. The sheet is laid out to mimic the shape of my stock room i.e. the data is not just listed in rows. I have multiple blocks of cells which include date for product name, amount, delivery date. What I would like is to be able to highlight a...

Hi on my worksheet I have 6 columns. The first column is a date 'ddd-dd-mm', the next 5 are general text. Each Date cell is a merge of 3 rows (example: A2 covers Rows 2,3,4 and so on). So for example today covers the cells A2:F4. I would like to create a macro (activated by a button) which...

Hi, I have an Excel workbook which is password protected. Majority of users use read only but a few are allowed to edit. Is there a way to make some cells read only even to those with the access password? The reason I want this is that on the worksheet there are cells which are duplicated on the...

Hi, I am trying to populate a field on a form automatically from a combo box selection. I currently have 2 tables: tblPIDList - PID Number (text & key) & PID Title (text) tblEIPList - lots of fields When I create a form for the tblEIPList I want to have a combobox which looks up the PID Number...

Hi, I have a table tblPersonnel - containing Number, Name, Manager and a form frmIdeas On the form I have 3 text boxes - txtNumber, txtName and txtManager I want the form to automatically fill in the txtName and txtManager fields when someone types their number in the txtNumber box Hope you can...

Hi, I am trying to set the default value for a form field to the last value entered in that field. For example if somebody uses the form today and enters ABCD then when a new user opens the form tomorrow the field will automatically have ABCD inserted. I have tried using the following code in...

Hi, I require a way to only show a worksheet if 2 designated users log on on their networked PC's. I think I would use the Get username routine but get stuck with how to use this username to perform an IF routine to show the specific worksheet. Any alternative method would considered Thanks If...

Hi, I have the following code for a query SELECT TOP 25 ID, Question, Answer FROM RefresherQuestions WHERE (((RefresherQuestions.[Plant Section ID])=2)) ORDER BY RND(ID); What I would like is to have the facility for the end user to be prompted on How Many fields should be generated. At the...

Hi, I have the following code for a query SELECT TOP 25 ID, Question, Answer FROM RefresherQuestions WHERE (((RefresherQuestions.[Plant Section ID])=2)) ORDER BY RND(ID); What I would like is to have the facility for the end user to be prompted on How Many fields should be generated. At the...

Hi, I have a table with a list of questions and answers. The questions and answers are split into different subjects. ID, Subject, Question, Answer I can generate a random number of questions using the code below: SELECT TOP 25 ID, Question, Answer FROM RefresherQuestions ORDER BY RND(ID)...

Hi, I am creating a database to record golf competition results. I have created tables for, Members (ID, name, handicap, classification) Competition (ID, Title, date, format. These 2 tables have look-ups for their content. I am stuck on how to record results for the competitions. I require the...

Hi, can anyone help me with a script. I want someone to be able to select options from dropdwon boxes and be able to press a button to calculate the total. If they wish they can then submit the form to a script which will mail the contents to me. I have the mail script but I cannot do the...

Hi, could any of you guys recommend any good literature or sites that may explain normalisation in a better way than I've been told so far. I am really not grasping normalisation at the moment. Cheers Liam If you can help, GREAT If I can help, EVEN BETTER

Hi, Im setting up a database to monitor surveys on Emergency Showers. I have the following requirements. Shower number - unique ID Shower type - 1 of 3 Location - address Person doing survey - defined list of names Date survey was carried out Comments picked up from survey Do I create six...