Search results

Hello Martin, Thanks for the quick reply. I just dont get it to work, How do I solve my problem when a user uses outlook 203 or another email programm? Please help me.

I have written an application containing a textbox where an email address is displayed. When the user clicks the send button the "new email" window of outlook openes and the email adres is displayed in the "to" textbox of outlook. I use the following code: Function EmailAdressToOutlook() Dim...

Hello, I have searched the web and there are a lot of opinions about this. I have the following variables: curMoney as currency datDate as date strString as string intInteger as integer What is the best way to empty these variables? I always use these: curMoney = "" isnull (datDate)...

Ok.. that is correct when aligning horizontal. I want to align vertical. Is that possible to?

Hello, This may be a very stupid question, but how do I align the text in a combobox to center? Thanks in advance guys.

Thanks again Bob, I tried that and still I get the access error message. I think I am just to forget about my own messagebox that tells the user that the value he entered is false en go with the Access 2007 generated error message. If I do that at least I get the datepicker. Thanks again for...

Thanks for the reply bob, Unfortunately that doesnt work for me. When I format the textbox on gotfocus or on before_update using this code: Me.txtDatumVan.Format = "Short Date" The datepicker appears when I enter the textbox. But when I type in something that is not a date I get an error...

Thanks bob, The thing is that I am using an unbound form and NO inputmask. Docmd.setwarnings false doesn't work either. What am I to do?

I think we are not on the same page anymor... LOL I just want a message box to appear if a user enters anything else then a date using this code: Private Sub txtDatumVan_LostFocus() If Me.txtDatumVan = "" Or IsNull(Me.txtDatumVan) Then Exit Sub Else If IsDate(Me.txtDatumVan) Then Else...

Thanks again for the quick reply. I tried this: Private Sub Form_Error(DataErr As Integer, Response As Integer) Response = acDataErrContinue MsgBox ("error") End Sub When I type in the letter "a" in my date field I only get to see the messagebox containing "error" but not the error message...

Thanks for your reply. Could you please give me a little example how to use the response bit? Thanks in advance

Hello, I have an unbound form that I use for searches. On that form I have a datefield called "txtDatumVan". I have written some code to check if the user filled in a date. This is the following code: Private Sub txtDatumVan_LostFocus() 'DoCmd.SetWarnings = False If Me.txtDatumVan = "" Or...

Hello, I have searched and searched for this but I dont seem to find a solution that suits me. This is the situation. I have a a database wich is used by multiple users through a front-end. The back-end resides on a server. Is it possible to select an attachement (word, excel, picture, etc)...

Does anybody have a solution for this?

Hello, I am building a databse that registers all communication between a company and a customer. here is my question. If customer A sends an email to the company how can I store that email in my database. I dont want to copy and paste the contents of the email to a memo field. Is there a way...

No...sorry but I cant find it. I just want to limit the user to 1 attachement and control the size of the attachement.

Someone????

BTW.. I think its better to store my pictures outside of the database. Only thing is how. I get brainbusted on that later. The question above still applies (lol)

I know all about the developer extensions and the A2007 runtime. the thing is this: I want to sell my programm licence based. Only the number of licenced users have rights to use the programm. So if a buyer buys 1 licence I want that user only to use 1 user at a time. I hope that I gave...

Hello, On my form I have an attachement field. In that field I want to store pictures. However I want the picature to be less than 100 kb. Also I want that for each record only 1 picture can be inserted. I hope that you guys can help me. thanks in advance...