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: Tamrak
  • Content: Threads
  • Order by date
  1. 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.)...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. Tamrak

    Project 2003 - Date Filters

    Good morning, I have questions regarding the filters in Microsoft Project 2003 Server. When I went to Project, Filtered for: for example ALL TASKS, and dragged down for more filters, I selected one item, such as Date Range. I edited and there was another window popping up with a Start and...
  11. Tamrak

    Count Unique Record in Report Footer

    Good morning, I have created a report based on table. The table is like the following: Project_ID, Manager, Resources 1234, John Doe, James A. 1234, John Doe, John D. 1234, John Doe, Julie D 1234, John Doe, Juliet C. 1245, Peter T, Paul O. 1245, Peter T, John C 1256, Cory T, Ken T. 1256, Cory...
  12. Tamrak

    Using Queries from another database

    Good morning, This might be a simple question. Is it possible to link the queries from another database, without having to import them? I created a query from Database A, which links to the almost the same tables that Database B has. However, there is only one field that I really want obtain...
  13. Tamrak

    Multiple Selections List Box in a Form

    Hello, I browsed through several topics in the thread. The closet one that I came out was: thread702-1109346. My issue is very similar to the previous post. I created a form, "frmProject", with an unbound listbox. This listbox has a column count of 2, Project_ID and Project_Name. I had...
  14. Tamrak

    Records Selection Query (Last or Max)

    Good morning, I have a question that might look simple but I cannot figure it out. My actual table has over 25 fields. I will pick up six (6) fields toward this example, of 23 records – Flat File – Table Name: Project_Info Project, Status_Date, Activity_Date, Status, ChangedInfo, Changed_by...
  15. Tamrak

    Change the fonts after comparing the records

    Good morning, Is there anyway we can change the fonts on the report when we see any different after comparing the previous record versus the current record? I am uncertain whether the conditional format will be working. Example, on my tblProject. I would like the report to look like the...
  16. Tamrak

    Update the date to match the first record changed in a group

    Good afternoon, I have a table consisting of the following fields: PO DateAppended Status ShippedDate ReceivedDate I created another field that concatenate these five fields together in order to prevent any duplication. This ConCat field is the 6th field and it is my primary field. I have...
  17. Tamrak

    Using the Control Source in Report Footer

    Good morning I was brain-dead on something that might look very simple. Let’s say I have the following data from a query (two fields) Type Qty A 3 B 10 C 50 D .. E .. .... My query name is: qryTest I would like to list this information into the Report footer...
  18. Tamrak

    Simple VBA coding needed to extract data on specific timeframe

    I have been testing on the queries and VBA and got a headache how to resolve this task. I have a table that contains thousand of records and would like to ask for a simple VBA code to accomplish the task. Since the real table has over 100 fields, I will use three fields as an example...
  19. Tamrak

    Open an Excel file from Access Macros

    Hello, Just want to see whether I can open a static Excel file using Access Macros. I could not find the command that will work on this one. I might miss a few things. For example, my Excel file that I would like to open is in the following path: K:\Excel\Data\Myfile.xls If we could not do...
  20. Tamrak

    Download data to have the graph generated automatically

    Good morning, I would like to add a “nice to have” feature into my bubbles chart. I download text data into Datasheet1.xls. It contains four columns: Project_Name (A), Cost (B), Score (C), Labor_Hours (D). This file will be overridden each time the download occurs. So, the number of rows...

Part and Inventory Search

Back
Top