Search results

In my page i create Unbond text box it's name ttl. Here a columnar field pointTaday . My plane I want to get Summation of pointToday's field with a condition. The condition is , If pointToday contain one or more 0.00 value then unbond text box will show "Sorry" Else Sum([pointToday])...

I have a report. Here a field GradePoint. In this field there are some number that like 2.00 4.00 2.00 2.75 In my report i created a Unbound text box its name GPA. I wanna when GradePoint has no 0.00it will show the result of =SUM([GradePoint]) but when GradePoint field has 1 or more 0.00...

it's just name Percentage (no sign of percentage). it has number like 1 to 100

I have a Field in my query. The name of field is Percentage. I wanna create a new field base on this Percentage field. It will be LetterGrade with the condition below…. 80 or above A+ 75-below 80 A 70-below 75 A- 65-below 70...

will you give me tamplate or video tutorial?

Idea: I have need a simple invoice DB Tables: Order> orderNo,CustName. product > productName,Price (here will stay product with price) I have a form where i can entry many products with a orderNo and Name (If here need Subform but i'm not clear about create subform) I wanna every...

if i don't uncheck special key. what are the sortcuts?

I have unchecked all the funtions in start up options even database window. Now how to will i open database window? actually here any shortcut to open database window? if this possible please help me...

I have a login form in my database. i used vb code for this form Private Sub Command31_Enter() If Me.valita = "abc123" Then DoCmd.OpenForm "start" Else DoCmd.OpenForm "wrong_pass" End If End Sub but after login success entered password the login form remain open. i know...

will it be =SUM([Your_field_name])

May be here is not full code. Would you help me for full code. actually i am not expert in VB and SQL. please give me fully code for insert those value in my tables.

i have 2 table in my database. I wanna insert data into two tables by one command button. command button name is insertData My tables are tbl1 (fields: Name,Pay),tbl2 (CostField,Amount) i wanna insert data for 1st table Name=XXXX Pay=0000 2nd table CostField=XXXX Amount=0000 actually i wanna...

I have done it according to your instructions but it shows Run time error '2465' and it shows error on this code CurrentDb.Execute "UPDATE TableName SET Frequency = Frequency - " & DateDiff("D", [LastDateOpened], Date) & "" i can understand what will i do. how to 'll i solve this? plz

i can do this please help me...... my table is tbl (two fields are 1. Frequency 2. LastDateOpened) form name 1. welcome 2. frm2 i wanna validity for the welcome form just 4 days. after 4days later frm2 always will be open at start up please help me how to apply the code .

It works! but not for day. It is working for every file opening. If i set the value of Frequency 4. It works for just 4 times file opening. But i have need for days not for file opening. Tnx for help if you can give the solution it'll be help for me.

I have a Welcome form which i have set at startup. I want to set this form for a fixed tme (ex: 30days or more or anythings) when the fixed time will expire then another form will show at startup. Any one help me about this problem?

when i set pass in my dbms and open,it shows a default login box. how to can i change it, that mean i wanna create a design form for password

HI every body i am very happy to say that i have made a abbreviation dictionary base on Computer and IT field By access. I got so many help from this forum. That's why i give thanks to all member who has given the solution of my problem and also the admin of this forum. Abbreviations...

Your thinking is right but i don't understand where i'll use it ( IIf([SumField]-Fix([SumField)>.2, Fix([SumField])+1, [SumField]) ) my field name is STOCK i created i query for summation that is SumOfSTOCK

Understanding my logic i attached a photo. Please see this and help me kindly