Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: liamm
  • Content: Threads
  • Order by date
  1. liamm

    Excel - Capture value from cell and copy to a table

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

    Have excel send an email alert automatically based on conditional formatting of a cell

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

    Highlight oldest date in excel worksheet

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

    Select Cells based on Todays date and print selection

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

    "Read Only" in excel

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

    Automatically populate a field from a Combo box selection

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

    Auto fill one text box from another

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

    Default value for field

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

    Get USERNAME then IF Routine on Excel

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

    Displaying random fields. How do I determine how many?

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

    Displaying random fields. How do I determine how many?

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

    Random selection

    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)...
  13. liamm

    Table for a results database

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

    How to calculate a form total

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

    Normalisation - not understood

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

    Table definition and Relationships

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

Part and Inventory Search

Back
Top