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 derfloh 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: Tamrak
  • Order by date
  1. Tamrak

    Calculated Field on the Form

    Thank you. This seems to work now. I used the following formula: =([QuantityInput])*DLookUp("[Score]","tblTotalScores","[Descriptions] = 'Dinner'") This is for that field. When I change the score in the table, the field in the form is automatically followed what I changed the value in the table.
  2. Tamrak

    Calculated Field on the Form

    I have a form, which required a value to be calculated (or lookup) from a table. Table TotalScores: Fields: ItemNo (autonumber), Descriptions (text), Score (number) Sample Data: 1, Breakfast, 25 2, Lunch, .35 3, Dinner, .45 ………….. (Real data has several records.)...
  3. Tamrak

    Use of the LookUp Command - Please Assist

    PHV Thank you for your reply. I do not have the access to my work computer right now. Just want to ask you whether this query will work only for one record, or it will perform the update, record by record, until the end of the last record. I have approximately 500 records in Table A, that will...
  4. Tamrak

    Use of the LookUp Command - Please Assist

    Good afternoon, I have two tables, unrelated. Table A has the following fields: * Explanation (Text) * New Value (Text) Table B, reference table, has the following fields: * Descriptions (Text ) – Primary Key – no duplicate * Value (Text) What I would like to do, with...
  5. Tamrak

    Conditional Format the text in MS Project 2007

    The criteria that I have is simple. However, this is not Excel and I am stuck. ---------------------------------------------------------- The flat file has a field called, "Type". I associated that field to "Text10". It has some values. All I want is to have the font and background of that...
  6. Tamrak

    Print report only the last record or a specific record

    Hello PHV and ProgramError, I still could not print the specific or the last record. Based on what I have written, here is the code. Could you look at the 4th parameter that you mentioned whether my comma was in the right place? Private Sub PrintPreview_Click() On Error GoTo...
  7. Tamrak

    Print report only the last record or a specific record

    Hello, This is the information: Form name = frmBusiness; Table = tblBusiness; Report = rptBusiness I entered the information on the form. When I save the record, I would like to print preview, based on the report (rptBusiness), for that RECORD only. If I click print report, it will print every...
  8. Tamrak

    Cascading Table - need to update the information

    Thank you for your advice. However, I am unclear regarding your explanation. Can you kindly explain a little bit further regarding the "hidden bound column"? Do you suggest me to create another column? I do appreciate your time explaining further. I am very confusing regarding what information...
  9. Tamrak

    Cascading Table - need to update the information

    Thank you. I am now having another issue regarding this database. I have the cascading database challenges. Let’s say I have a combo box, unbounded, gathered from the table -> Complexity. The values in this table are -> Minor, Medium and Major. I have two more tables that will obtain the...
  10. Tamrak

    Cascading Table - need to update the information

    Good morning, I successfully built the cascading table. However, I am stuck on how to update the information back from the original field. Assumption: tblInformation, two fields -> state, city On the data entry, I created a form to have the information input into the tblActivity, by using...
  11. Tamrak

    Conditional Format the text in MS Project 2007

    I have no successful in converting the code. I would like to email you a screenshot on what I have. Perhaps you will see what I am looking for. You can post the codes in the forum. All I am looking is to have the fonts bolded (Task name) when another column has a "Yes" value. I do appreciate...
  12. Tamrak

    Conditional Format the text in MS Project 2007

    Thank you for your reply. Can you provide some codings in order to bold the fonts? Thanks.
  13. Tamrak

    Conditional Format the text in MS Project 2007

    I constructed a template in MS Project Professional. I downloaded the extract (text) file from MS Excel. Let's say, there are two columns, task name and Milestone. If the milestone = "Yes" on the task name, I would like to have the task name, "bolded". Is it possible to write some types of...
  14. Tamrak

    Right Trim function

    Thank you for your information.
  15. Tamrak

    Right Trim function

    Good afternoon, I have raw data that need to trim the right side of information. The data looks like this: Field name = Name Peters, John (F90780/GA) Roberts, Frank (FG3434H/FA) Perkins, May (Ffd435/AA) .... What query should I write to eliminate the right side of information? All I need is...
  16. Tamrak

    Add on Coding to skip the blank record

    Thanks to all. It is working !
  17. Tamrak

    Add on Coding to skip the blank record

    Good afternoon, Can you assist me with this function? I have several data in the table that have a format + + + + between each string. Sometimes, it looks like, Jeff+Smith+Barber+50+25 etc. Anyway, I can get the information that I am looking for. The following is the code. It is working...
  18. Tamrak

    Timephasing Queries for Actual Work, in MSP 2007

    Good morning, I am working on the backend queries that will produce the timephasing for Actual Work in MSP 2007. (The Web Work tables from MSP 2003, have been eliminated in MSP2007.) I can gather information from total actual work hours (approved hours)in the project fields. However, if the...
  19. Tamrak

    Hlookup and Vlookup questions in Access Queries

    Thank you for your response. It is not what I am looking. I have four fields (reviewer, analyst, specialist and approver) and would like to replace each field with the name. I have problems setting the relationship because each field can link to the value in the table 2. I am uncertain whether...
  20. Tamrak

    Hlookup and Vlookup questions in Access Queries

    Good morning, I am trying to do the queries and I think it can be done in Access. Here are the data samples: Table 1: Project_name, Reviewer, Analyst, Specialist, Approver project 1, 125AA, 1347X, 8905E, 68092 project 2, 1347X, 7908E, 6008R, 1255A (I have around...

Part and Inventory Search

Back
Top