Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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

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

Thank you for your information.

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

Thanks to all. It is working !

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

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

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

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