Recent content by SwingXH

great, thanks lot! SwingXH

Hi, everyone, I got a problem in the C++ programming when reading data file. The codes are attached below. In the for loop, the data file can only be opened once. When j=2, it does not open the file. I don't understand why. Is there anyone can give me a hand? I've been struggling for a while...

Hi, I have some date fileds on several forms and I want to pass the date from calendar control to them once any of them is in focus. The calendar will be created on a separate form. Date fileds are on several different forms. I hope once one click the date field and then pick the date from the...

Thanks, great:) SwingXH

I created a macro to open the hidden form, works well. Just curious, where is the AutoExec macro? Thanks, SwingXH

Thanks, Ken. SwingXH

Is there an event that we can use when Access is closing, like windows is saving settings after one hit turn off computer? I want to write out some infomation when Access is closing. Thanks, SwingXH

Type mismatch for Dim MyDate1, MyDate2 As Date MyError = Int(MyDate1- MyDate2) & Format(MyDate1 - MyDate2, " hh:nn") I found this one helpful MyErrorhh = DateDiff("h", MyDate1, MyDate2) DateDiff returns a Variant (Long) specifying the number of time intervals between two specified dates. SwingXH

Thank you PHV, assume I have two dates, MyDate1 = Format(Time(), "dd/mm/yyyy hh:nn") MyDate2 = Format(Now(), "dd/mm/yyyy hh:nn") how can I get the difference between them, in terms of days, hours, and minutes? Thanks, SwingXH

First of all, thank you very much! I used the following codes, MyTime = Format(Time(), "dd/mm/yyyy hh:nn") Open "TESTFILE" For Append As #1 Write #1 MyTime Close #1 And I got "30/12/1899 08:14" The date is not correct(should be 08/09/2004). And how can I remove the quotation mark? ( I...

When I use Time(), it gave me 1899-12-30-06:42:14. The hour is correct. How to get the correct system time including dates? Also, I want to write an output file with append property, how to write the right code? Thanks a lot! SwingXH

This works, stLinkCriteria = " ID = " & Me.ID.Value & " And " & "Name = '" & Me("ComboName").Value & "'" Anybody give me a star:) Thanks, SwingXH

when I change both field to numerical fields, i still get the same tyoe mismatch error. for example stLinkCriteria = " ID = " & Me.ID.Value And "ID1 = " & Me.ID1.Value DoCmd.OpenForm "form1", , , stLinkCriteria Both mainform and form1 have fields ID and ID1. SwingXH

looks like i still got type mismatch error when using "Name = '" & Me("ComboName").Value & "'" That's strange. Any other idea? Thanks a lot! SwingXH

I got type mismatch error. ID is integer, and Name is text field.