Search results for query: *

Hi All does anyone know how can i able to print a value in a cross tab if the currentfield value is null For example i want the value 10 to be display if the currentfield value is null. does anyone know how this can be done? Thanks

Hi Kerryc i had the same problem. i basically created a new formula using the field and add that formula to design the graph, if you do that then you can able to tick the don't summarize box. R

Hi LB I am using an Advanced Layout Chart and all the calculation for the Chart are done on access query Example Total Calls = Count (Call No) Total Answered Calls = sum( Total Calls) - (Total Abandon Calls)) I would like the Legend to appear as Total Calls and Total Answered Calls. but...

Hi I am having problem changing the Legend of the Chart. does anyone know how to change the Legand???? Thank you

I got a report that calculates the total number of calls received for each months using cross tab format. But I only need to get the last 12 months data from last month. Does anyone know how can I do this? RB

sorry Paul ACC: Main Form Record Edits Saved When Subform Gets Focus http://support.microsoft.com/default.aspx?scid=KB;en-us;q132033 ACC: Unable to Undo or Rollback Main Form and Subform Changes http://support.microsoft.com/default.aspx?scid=kb;EN-US;131535

Hi Paul You may want to have a look at this site and down load the undofr.mdb hope this will help u R

Hi Guys I have added an Undo command Button on a Parent Form, and it's works fine for that Parent form only. but is there any way that i can also undo a record in the subform using one cmd Button? can someone direct me in the right direction Thanks Heaps

Thanks Guys I worked out why i was getting that message and it's working fine. i just needed to remove the Forms(strStartupForm).SetFocus from the Code Thanks again it really helped me i got an another question is there any way that i can use the same form "frmSearch" but...

Hi FancyPrairie and Rick Sprague Thank you so much for helping me out. i am using the method Rick Sprague described. when i type the username and password it is taking me to the define form for that particular user but i am getting the InvalidForm message where it says to contact the security...

Hi All I have developed a login form for one of the database to control the access of users who can use the database. and this is what i am using to check the UserName and Password. Set Curdb = CurrentDb() 'If your table and form are in same database other wise change it SQLStmt =...

Hi I got a drop down list (Type of Customers - Subscriber, Agent, VIP) and I need to assign a value based on the value the users select from the drop down list. Eg: If they select customer type as VIP then the subscription value should be $0.00 other wise it should be $62.95 Can someone...

I need to setup a password protection for one of the database i am working on. there will be multiple users who will be using that database and i need to restrict the users who can look at certain information. can someone point me to the right direction where i can get articles or information...

I got a database where only the Administrator have full access control (Ready, Write and Modify) and others have only Ready only access. I am having a problem when ever Administrator got the database open others can't open and database and when ever others got the database opened the...

Hi Bob Thank you for ur help it works tx again Reghita

I got a field which calculate the year and month of a employee in the company Eg: 1 Year, 4 Months but i need to get only the month when the year is 0, so when : 0 Year, 4 Months it should appear only 4 Months so is there any way that i can do this?