Recent content by Alira

Hi! I'm getting this error... Here is my code: Dim db As Connection Dim rsLog As ADODB.Recordset Dim comLog As New ADODB.Command Set db = New Connection db.CursorLocation = adUseClient db.Open "PROVIDER=MSDASQL;dsn=mydcn;uid=Win2000;pwd=;database=mydatabase;" With comLog...

Hi All! What would be the best way for "removing from table1 - appedning to table2" couple of thousand records at a time? Have a great day!:-)

Thanks a lot!!!!!!!!!!! Have a great day!:-)

Now it's "H:mm:ss" But it was "H:mm:ss tt" In this case distribution is not needed... I'm safe now:) But have no idea what's wrong with a query... Have a great day!:-)

More problems! It tells me "Incorrect syntax near '22'"!!! Why??? event_time BETWEEN #5/27/2002 22:43:24# AND #5/27/2002 22:47:24# Have a great day!:-)

I've changed system time and it worked. Have a great day!:-)

I use: myDate2 = Format(rsAllPart.Fields(3), "m/d/yyyy h:m:ss") and myDate2=5/27/2002 10:43:24 PM is there other way? Have a great day!:-)

if I'll use shortdate I'll loose hh:mm:ss. I need everything... Have a great day!:-)

Hi! Can't find any help with formating am/pm date/time to 24 hour format. Have a great day!:-)

Hi All! Can some one tell me how to delete duplicate records from the table? Have a great day!:-)

There is no flag for that. To find out the difference we had to through his log and partners log and compare date/time for ssertain number... All dated should be adjusted to local time. Name of the country will not help, there are three partners in one country who uses different date/time for...

Hi All! My friend asked me to help with a database. His company provides long distance services with oversies contries. The way it works: He has his log with client numbers, phones dialed and time of calls. His partners send him their logs with phone numbers and dat/time of calls. The problem...

Unfortunately it's not possible... and there is another thing. In this initial data table date and time are two separate fields. I'll have to update both fields if needed... How this statement should look like? Have a great day!:-)

Hi all! Here am I... never worked with SQL server before and old version doesn't help eather... I have to update dates in two similar tables. Data for those tables comes from Europe with their GMT time/date. How can I create conditional update for two tables... if I can? Where I can find...

Hi all! I never really worked with FMP, but it never seemed to be too complicated. And here I am:) I have this job... to create web based app. with FMP. I don't have any books and I never did it before... First of all .. is there a big difference between versions 4 and 5? What I should know...