Recent content by jen1701

Please help me how to call a transition page from vb application. I have a vb application which has a timer control to display 2 web pages. I would like to have a transition page which can have fading effect and also displaying error messages if there is a problem displaying the 2 web pages...

Thanks Isadore. I will try your suggestions. Jen

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

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

Thanks Duane for the quick reply. I will try your suggestion. Thank you so much for the help. Jen

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

Thank you so much for FancyPrairie, PHV and MichaelRed's replies. I tried your suggestions and worked well. Thank you again for your help. Now I have another problem. I have many records of audittime. I need to add them together to print it out as Total audit time per job in a report. But I can...

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

Thank Willir and Aerin so much for the replies. I will follow your advice and try it. I am working on another project right now. But I will go back to work on this problem and try your suggestions. If I have any problem i will ask you again. Thank you so much for your time and help again. Jen

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

Thanks again PHV. I do have an AutoExec macro. It detects the idle time and open the main menu. I guess I can add OpenModule to run the importing excel data code in this macro. Right?? Thanks, Jen

Hi PHS, Thanks for the quick reply. I am reading the DoCmd.TransferSpreadsheet method and just wonder where should I put all these code. I guess I need to create a module, so when the Access is opened, the code can be excecuted and the data can be automatically imported into Access table. Is it...

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

Thanks again PHV. I tried varX = DLookup("TestedKey", "TestEvent", "SerialNumber = '" & Forms![frmInput]![SerialNumber] & "'") It worked this time. Thank you ever so much for helping me out. I gave you a start for the help. Jen

Hi PHV, Thanks again. I tried your suggestion it did not work. I still get compile error. Jen