Recent content by dominicgingras

Yes my question was answered but my second post is refering to the same problem. I know that to have two contact field is "bad practice" that why I am trying to find an alternate solution.

I did setup a recepient policy. I created a recipeit policy my public domain name. I updated everything but I still get the error? I am still searching!

I can send email without any problem. I can also do an external nslookup on my public IP without problem and resolve it. I can also telnet my server. So far so good! When I send a email I get an unknown recipient error. The receiving domain name is not the same then my internal domain name so I...

Thank you! Its working

I have a database desing for a transport company picking up people in different place like a taxi. Sometimes they schedule a pickup and at the sametime they schedule the return of that person: Private Sub Retour_Click() On Error GoTo Err_Retour_Click Dim IntersectionArrivee As String Dim...

Yes

Yes I did place the code on the on form load but when I put date() the () seem to disapear. I think I read something about date() and access 2002...

Maybe it’s a simple question... I have a pop-up form used for entering a date for my user. When I open that pop-up, I want the active x to display today’s date. I tried this code: Me.DateDépart.Value = Now() No success Any help will be appreciated.

Its still let you enter only a time!

I tried this litte piece of code and I have put it in the before update. I need to to the oposite so if my user only enter the time he gets a message. I tried to lookup in the help but its kind of confusing. Thank If Format(HeureDépart, "dd/mm/yy") = "00/00/00" Then MsgBox...

The shipping date is never now() anyway. The bottom line to this is that a user can enter any kind of date in access and their is no way to make sure that he took the time to enter the time. I will try some of danvlas option.

That will just make sure that he has enter a date but he could enter a date without a time ex: 12-03-2003. I need this format: 12/02/2003 11:00:00 PM. Tell me what you think!

I have a post somewhere related to that but this time I will try to refine my question. I need to enter a full date in a field called "shippingtime". How can I make sure that my user are entering a date and the time. My user are pesky one. I dont want to use an input mask because its...

I guest they must be a lot of people having this problem. I wonder if anybody else has more Idea. I tried several ways using before update and after update and combining the field using & "" & but so far I did not get very good result.

That why I wanted to use two field on the from and combine the result after. But I dont know how to do this.