Search results for query: *

Hi both, Thanks so much for helping PHV: Your code works! I just copy and paste into my code and it works fine now. Thanks. docjohn: Guess ur's couldnt work might be due to the "00".Anyway, U'vr also provided a good start-off. Thanks too!!

Hi docjohn52, Your code doesnt work in my outlook form. I'm using vbscript in my outlook form to achieve that scenerio, and outlook doesnt regconise the $ sign. Anyway, thanks for the help. Any alternatives you can think of?

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

Hi Lightning, It dun work. Whenever you haf a numeric value there, it will take that value as the date. EG if put: Field1 Between Today and (Date()-30) The outcome will be: Field1 Between Today and 05/30/04 If put -5, date will become 05/05/04 Which is obviously wrong. I'vr already tried...

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 Ken, Then how do you set the value in cmbbox2 to the first record listed instead of a blank one in cmbbox2 when it first started to requery?

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 Aceman, If I wana use wizard to insert data into different tbls in a form, I MUST have relationship (like foreign Keys) thgy? Any websites to teach u how to use Access wizard?? Pls recommend..Thanks alot!

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