Search results

Hi All, Here I'm again, I have a query 1 that sums up each field to get a subtotal, the second query2 sums up query1 my question is can I get this two combined into one and get the same result, or is there a better way? what Qry1 SELECT TempQry_Subtotal_Proj_HC.Type...

I have an unbound field =[July1]+[August1]+[September1]+[October1]+[November1]+[December1]+[January1]+[February1]+[March1]+[April1]+[May1]+[June1]. However some of this months do not have any entries, so I do not get a total unless I manualy ad a zero where needed. How would I approach this...

Hi All, I have a calculated field that reports in percentages Example: 341%. Based on the output anything Higher than >100% should give a message "RED" with a RED background and <= "YELLOW", and =100% should be GREEN Color. Hope it makes sense, anty help would be greatly appreciated...

Hi All, I have form A and form B, in form A I have two cascading combo boxes and a cmd button that once the criteria is selected it open form B in the correct record, however I copy the objects from A to B to eliminate two forms and just using one form, now when the criteria is selected, it...

CMD button to run selected query Hi All, When I use the following code in the cmd button I get a compile error Sub Or Function not defined Private Sub cmbQueries_Click() Dim stDocName As String If IsNull(Me!cmbQueries) Then Call Message("Please select a query to...

Hi all, I have two dates, start date and enddate in a form, would like to calculate working dates between both dates in a third field called Exp: (using a query buider in the form) <code> Public Function GetNumberOfWorkDays(sStartDate, sEndDate) Dim iDays Dim iWorkDays Dim sDay...

Hi all, After updating a text field, I would like a combo box to show a date from its row source, I trying to avoid cliking in the box.. The row source has only one date that remains for a whole month before being replaced on a monthly basis.the text field name is dates, and the combo bx is...

Hi all I have two cascading cbx's, would like the value from them to select the corresponding report. Any help would be greatly appreciated Dennis :confused:

Hi all, Need to update a field from a subforn to a field in the main form. All records in the main frm are captured as pending until the transactions are process in the subfrm and a field is worded "complete" then would like to update the main field from "pending" to complete the main form...

Hi all, I have this code that it does not work just the way I would like to. Here is the problem, Is a cbx in a continous form, when I select the value "Pending Affidavit" a "Noyears" field is visible, unfortunaly it does the same for any other value selected I know it should also reference...

Hi All, I have a cbx with seven categories which represent 7 separate frms. I would like to select a value from the cbx and click on a cmd button that will open the selected frm on the current ID. Any help would be greatly appreciated thanks Dennis

Hi All, Would like a cmd button to open specific form selected from a combo box. Any help is appreciated thanks Dennis

Hi all. I have a combo box ( cbxCode) with 8 rpt names Example ( Pending Affidavit, Affidavit approved etc). Within the form(A continous form) I have a ck box (CKFlag) which is selected for flaging current record for printing. I would like to add a cmd button that once a rpt is selected from...

Hi All; A report based on a crosstab query that when run it shows how many employees type (T, A, E) are on l conference leave on a particular date. my problem is that the report only runs when all three types are present, if one type is missing in a particular report date. It just does not run...

Hi All, I would like to create a logname of people using the database, and being able to report their transactions by date How will I do this thanks Dennis

Hi All, I have 15 Small frms that I would like to select from a combo box. as needed. I have similar code to open reports, but now I is forms So any help will be greatly appreciated. Dennis <code> for reports SELECT [MSysObjects].[Name] FROM MSysObjects WHERE (Left([Name],1)<>"~") And...

Hi All, I have a combo box [Pytable1] with the following values( 01, 02, 09, 15, 23, ) Based on these values when selected I need to update couple other fields [ Position]and [ID_L] provided [EffDate] and [CompDate] are present (Not null) Now in order for the update to take placed [Lane...

Hi All, What will be the best approach in this case.. 1.) I have a combo box with these values (name of combo bx) cbxPytble [1, 2, 23, 32, 9] Example; When I select Pytable [1] I want to update a field called [ Position] with [Regularly Appointed Teachers] and a field called [ID_L] with the...

Hi All: I have 4 fields Id AutoNo. A. text1 B. Text2 C. Text3 Once these 3 fields are validated I would like to see field D. populated with the correct info any help would be greatly appreciated thanks Dennis

Hope Pat reads this one ( need your help) I have six fields in my form Only 3 are required When Approved then Effective and completed date is required, if Approval is missing but Effective and completed date are not then I need a warning. Approval, Effective,completed dates, triggers...