Search results for query: *

Hi, I would like to display date in a textfield in the format 'yyyymmdd'. If I use: strGetDate=CStr(Year(InvoiceDate) & Month(InvoiceDate) & Day(InvoiceDate)) It gives me yyyymd. Tried use formatDate but it says type mismatch. Any ideas how to do it?? Thanks in advance

Realise DTPicker by default will display today's Date. Is there anyway to set the control to always display NULL until I clicked on the calender?? Read from somewhere that I need to set the CheckBox property to True inorder to have NULL value. But I doesn't want checkbox to appear in my control...

Hi, I need to use the DTPicker in a form in my outlook application. But I cant seems to find this control in my toolbox. I have the MS Office cd with me but how do I install this additional control into my outlook?? Pls advice. Thanks

Is there anyway to set the rules for the view such that the view will display field1(type is date) row in RED when field1 is 10 days later from TODAY?? In my automatic setting rules condition, I put: 'Field1' 'Between' 'Today and 10 days later' This condition ONLY works for if today is 04/27/04...

I have a combo box bound to a custome field in a form that I do not allow user to edit or type in new items. User can only select whatever item that is in the combox box. I have tried the read only option but once I checked it, I cant even select the combox box item. Pls advice. Thanks

Hi, I have a form in a sub folder called "Project Profiles". It has a coding in the form that goes like this: Function Item_Open() Dim objNameSpace Dim objProjectProfileFolder Dim objAllProfiles Dim objFormPage Dim objComboClient Dim objProjectProfile Set objNameSpace =...

Hi, I have a form with 2 cmbbox1 and cmbbox2. Both are bound to a table. How do i do such that when I click cmbbox1, cmbbox2 will show all data related to cmbbox1 and then after select the desired option from cmbbox2, both will save into the tbl. EG: cmbox1 values are: Red, Green, Yellow...

Hi all, I need to create a form in access using wizard.However in the form, I have many textfields which to need to be bound to different table. How do I do it using wizard? EG: txtbx1 data go into tbl1 txtbox2 data go into tbl2 etc... Pls advice. Thanks