Search results

Hi Actually my original problem is to get smthng like that ID Product -- ------- 1 1 2 2 3 6 4 24 n...

Hi I am trying to search a function Like Product which will multiply all the values in a field. Like ID Amount 1 2 2 3 3 4 Product=2*3*4=24 Is there any function like this which will do the above job ? Cheers! Aqif

Hi Thanxx for ur reply.....my problem is that I've to export the data for staistical anylysis purposes so thats y i want a query to handle that, they'll access the query through ODBC. Cheers! Aqif

Hi I am trying to figure out how many people are left in query. My problem is something like that. ID Name DOB 1 A 1/1/01 2 B 2/2/01 3 C 3/2/01 4 D 4/4/01 The query I want to write will give an output like ID Name...

Dear Russ Thanxx for ur advice....my main problem is highlighting the labels in any way since i have very few taxt boxes but many check boxes n option buttons on my form which is making difficult to see where ur cursor is rite now. The only solution i could think of is to chnage the active...

Hi Just want to find out that is there any way to change the color of current label in focus to make the current control more visible. I have build a form which mostly contains check boxes and options buttons, so it becomes hard for the user to see where the cursor is at the moment. Any...

Hi What if u do like : [Judgment_Details]![Case_No]=[Forms]![Main Screen]![Case_No] Please let me know what response u get from this. Cheers! Aqif

just ...thinking that if u'll set the password for ur database....i think if someone will try to import tables from that database than access will surely prompt for password. Cheers Aqif

Hi Is it possible that OnCurrent Event of the form or Onclick event of any button I could get the names of the fields which are left null on the form. I have a tab form and want that user can get the information that he/she has left these fields empty for this record. Cheers! Aqif

Hi I've got a table in which I have following fields plus many others: DIAGNOSIS --------- PatientID PrimaryHosp SecondaryHosp I have a Hospital Table also HOSPITAL -------- HospID HospName In access I have linked HospID with PrimaryHosp although I also wanted to link it with...

Nope .....it didn't worked I was trying to accomplish that by using a Control source expression but i think i have to adopt some coding approach behind some event to make it go......thanxxx for ur help Cheers! Aqif

Hi I am using a continous subform and on that form footer I placed a text box and set its control source as =Count([PtID]) & " Records" When the form contains some records it gives proper number of records but when form doesnot have any records it returns nothing instead of returning zero. I...

I tried the same thing and I just wrote one formula on After Update event of my second combo box as TxtDiff = Cmb2 - Cmb1 and it returned the number of days. I dont know that I m understanding ur problem or not but access calculates date difference by default. Maybe in ur combo box the date...

I think its better to put the name of user into a variable and then check the condition using variable like: Dim StrUsr as string strusr = CurrentUser If StrUsr <> "Admin" Then Me.MyTxtBox.Enabled = False Else Me.MyTxtBox.Enabled = True End if Try this maybe it'll work Cheers! Aqif

Well thats a sneaky way...isn't it But i like that..now i can easily set the command button properties to bold.thanxx for ur help Cheers! Aqif

I am not sure y r u using this clause WHERE T2.[Trade Ref] = qryDisplayMainTrade.[Trade Ref]) because u r refering to the same table to the same filed which access will not accept. Try using wthout where clause or brief me a little more about ur requirement. Selecting Max(date) in nested...

Hi Try Creating a OpenForm macro and specify the parameters in Where condition like [MyTable]![MyField]=Forms![MyForm]![CustID] Hope that'll solve ur problem Cheers! Aqif

Hi Create a OpenForm macro and specify the parameters in Where condition like [MyTable]![MyField]=0 and [MyTable]!{MyField2] is null Hope that'll solve ur problem Cheers! Aqif

Hi I am working ona form which has got two tab pages. I want to ask abt two issues: 1. I want that the font style of the active page should turn BOLD, improving the user visability. 2. Is it possible to give tab page a color. I have given my form white color and set tab page property to...

Simple Just create a report based on what records u want to print. Then create a macro of OpenReport and in that macro specify the where condition as [MyTable]![MyField]=Forms![MyForm]![MyField] What will happen is that when u'll call that macro behind the button it'll open the report only...