Search results

Because thts a stupid cross tab query with no limits to colums thts y Cheers! Aqif

Thanxx Pat but I think i mentioned in my original question also that I can't make a report of it n i have the choice of only printing query. I just want to change the caption of query while printing. Cheers! Aqif

Hi I want to print a query and when I print that it displays the name of the query on the top and then Page# on the bottom. Is it possible to change the name caption of the query at runtime n also the footer remarks?I want this because the same query has got different parameters and I want to...

Hi I've build a crosstab query report which looks like this Tissue 1999 2000 2001 A1 1 0 1 A2 2 3 0 My problem is that the Year fields are fixed in the report. If a...

Hi I've got a query which gives me output like: Stage CountofStage 1a 5 1b 3 2a 6 2b 4 3a 2 Instead of this I want an output in a grouping manner like Stage CountofStage 1 8 (5+3) 2 10 3...

Write the code like: Me.Txtbox1=Null Me.Txtbox2=Null I believe that u've to clear each field by mentioning the name of every field in the code. Cheers! Aqif

Hi I got a question regarding User Group. I have assigned the user group in the shortcut by adding /wrkgtp "Path of work group file" The problem is that When i open my normal access database having default user work...

Hi I tried ur suggestion but it is not working at the moment...maybe i m doing some mistake because it writes smthg like =CheckVal([Me].[ActiveControl]) but its not working can u give a little more detail please Cheers! Aqif

Hi I searched help and u can easily mention >1 fields in ur Insert query, just replace the FirstName etc with ur control names and hope it'll work OK. I m pasting the Access help file portion also INSERT INTO Employees (FirstName,LastName, Title) VALUES ('Harry', 'Washington', 'Trainee')...

Hi I'm trying to build a module as : Public Function CheckVal() If MsgBox("You are changing the value of a field which is reffered in other information forms, are you aure?", vbYesNo) = vbNo Then Me.ActiveControl = Me.ActiveControl.OldValue End If End Function What I want to do is...

Hi I have a table of country codes........where user can add new country which is linked field is Patient table. I am concerned that if someone will edit the existing country name or number then it will disturb...

OOOps....i though u wanted enable disable function....anyhow HTH function is also write....n u can also use visible=true in my code Cheers! Aqif

Hi On After Update event of check box (Chk1) just write If Me.Chk1 = -1 Then 'if check is yes Me.Cmdbtn1.Enabled = True ElseIf Me.Chk1 = 0 Then ' if check is no Me.Cmdbtn1.Enabled = False End If

What u can do is that create a new query based on the running sum query and then just add new colum as runningsum2 which should be like runningsum*1 or otherwise writting expression like Select, IDNO, Amount, Val(Select Sum(Amount) from Tablename where IDNO<=e.IDNO) from TableName as E; i...

Thanxx buddy it worked flawlessly.....searched for list of KeyCodes in help but there the list was diffrent like for F3 it was 0x72...can u please mail me the list of other keycodes also Thnxxxx again...cheers! Aqif

Hi In my form there is a button which open popup form for seeing the avalaible options. I m trying attach a function key to open that form...or any other key for that matter. I m aware or alt+some key...thing....so just want a single function key to be pressed to open a popup form. Cheers! Aqif

Hi I've got a list box on my form and it is attached to a table Contacts. I've got a button beside list box and it generates the latest contact data by make table query ie it updates the contact table. The problem is...

Hi Y dont u consider to build a report which will just looks like a letter head n fill in all the details of doctors. Because thats what reports r meant for. Let me know if u need help regarding reports. Building a report n then exporting it into word could also be one option. Cheers! Aqif

Hi I think this query solve ur problem. SELECT IIf(IsNull((Date()-[ptdob])/365.25),Null,IIf((Date()-[ptdob])/365.25<20,"<20",IIf((Date()-[ptdob])/365.25<30,"20-29",IIf((Date()-[ptdob])/365.25<40,"30-39",IIf((Date()-...

HI I managed to debug my query n now it works fine: SELECT e.ID, e.Name, (Select CInt(Exp(Sum(Log(Id)))) From TblCount where id<=e.id ) AS Product FROM TblCount AS e; Anyway thaxx everyone for thier help which made me able to do that thing. Cheers! Aqif