Search results for query: *

In my project, I use a DropDownList to display the values. The value list is populated from a table. The list is over 1000 values. I can not type the part of the value and jump to the value in the list. There is also autopostback validation on the dropdownlist. I hope someone can give me some...

Hi all, I have a main report with 2 sub reports. Each sub report has summary of Total in the report footer. I would like to add the sub reports summary of total together and displayed in the main report footer. How to get the value pass from sub report to the main report?? Please Help! Thank...

I am trying to time calculation using DateDiff. ie. 2:07:34pm - 9:33:25am = 4 hours 33 mins and 09 seconds. I used following code: Days = DateDiff("d", Me![AuditStartDate], Me![AuditEndDate]) Hours = DateDiff("h", Me![AuditStartDate], Me![AuditEndDate]) Hours = iHours - (Days * 24) Minutes =...

Hi Friends, I have a entry screen which has MainForm and a Subform. If the user select the status of "Repeat" in the subform, it should create a record in 2 tables with all the information in the Main Form and sub form. I guess I should use DAO.recordset to achieve this, but I am not sure where...

Dear All, I would like to have the function to directly importing Excel data into the Access application when the application is opened. The Excel data file is updated all the time. I want the table in the Access application also being updated when the Excel data is updated. I am not sure where...

Dear Friends, I am trying to use Dlookup function to find a value. ie. varX = DLookup("[TestedKey]", "TestEvent", "[SerialNumber] = " & Forms![frmInput]![SerialNumber]) I get compile error on the above code. I can't find out where is the problem. Please can someone shine some lights on this...

I have a combo box which uses a value list. I want to set one of the value as default value. I set the value "Final" under the combo box Default Value property. But when I run the form, there is no default. Is there anything else I have to set in order to see the default value? I remember I set...

I have some problem to make the conditinal formating working the way I wanted. I have 2 fields on a subform: [SsheduledHours] and [ActualTime]. If the [ActualTime]< [SsheduledHours], forecolor of [ActualTime] is red otherwise is black. I added the condition on the form under Format. But...

I would like to print a daily report without asking the user to enter the date by using NOW in the query. In the report query, in the date field, the criteria is like *formatdatetime(now,dd/mm/yyyy)*. So the report will print all the records with that date. It seems I have problem with the...

I want to use IN function to validate the EmpNo. whether it is in a list on a form. So on the employee no. field, after update event, I have the following codes: If Forms![Entry]![Employee Number] In ("001","177","148","110","224") Then Forms![Entry]![0 Defects].Locked = False End But I can...

I have created some more new tables and added to the split database FE and BE. I right click on the table name in the talbe list in FE and the link talbe manage is grayed out. I can not do the link. Why? Is this the right way to link new tables to the BE? Please help, it is very urgent. Thank...

I have a report which I need to distinct count within several groups. e.g. JobId SN 0Defect 2345 12345aa No 12345aa No 23456bb Yes 23456bb No So within JobId 2345, there should be 2 SN, 2 0Defect. In order to achieve that, I grouped on SN and...

I have gouped summary which I would like to print them in the report footer section. So the user can go to the end of the report to view the summary on the group and the total report summary. for example: The report is grouped on location. So the following infor is on the group footer. Locatiion...

I have a report grouped by Top/Bottom. I want to calculate the time between each record within the group. I also want to calculate the total duration within the group. e.g. Top 2/3/2004 08:34:23am 2/3/2004 01:23:56pm 2/4/2004 03:12:35pm I want to calculate 2/3/2004 01:23:56pm-2/3/2004...

I have 3 fields in a form [PartInDateTime],[PartOutDateTime] and ActualTime(duration). eg. 1/20/2004 1:30:20, 1/24/2004 3:50:40. I want to calculate ActualTime: 1/24/2004 3:50:40 - 1/20/2004 1:30:20 = 4days 2:20:20. Please give some ideas how to do that. Thanks in advance. Jen

I am trying to calculate the time based on the condition in a form. The user will select the bake condition at 125C or 40C, thickness (<1.4mm, <2.0mm, <4.0mm) and level(3,4,5,). So when the part is in the over at 125C, thickness <1.4mm and level 3, I need to calculate the ScheduledPartOutTime...

I am using CR 8.5. I am trying to set up a cross-tab report. I set up a formula field called shortage. I want to calculate (on-hand-qty) - sum(balance due). After I created the formula field, it is not listed for me to select as row or column. Why? I am new to CR. Is there limitations of using...

I tried to set up a cross-tab report. The report likes like this: Component Id Job ID Bal Due On-hand Qty Shortage 876 P21 40 30 -10 The shortage was calculated by fomula. But when I try to use this formula...