Search results

  1. P

    Problem: Linking Text Box to another page

    hi i would like to ask on how to link text box... here is my problem i have inserted a Tab consist of 4 tabs in my forms... in TAB 1 i have with a formula insidelike this (=[text18]+[text20]) now in TAB 2 i want to show the TOTAL came from TAB 1. i tried this already but it dont work error is...
  2. P

    Help:Report in Checkbox

    hi sir, i have a query with a yes/no check box in it.. in my criteria in yes/no i put it only shows the box with check when i generate the report... can anyone help me how to make a button that i can open the report if i select the box with check only in my report only the box with check will...
  3. P

    Problem:How to get Grandtotal of subtotal if the source is in unbound textbox

    hi all, good day i have a problem in my data base getting the grandtotal of my subtotal... i dont have a TOTAL fields in my Table... my TOTAL in my form is Unbound in my form this is the code in my unboundtextbox total First Yr =[first yr male]+[first yr female]Second Yr =[second yr...
  4. P

    Problem: New Table in Back_Ecnd Connecting to Front Databse

    hi its my problem since from the beginning.. i split my database because i use it in Network... now i need to add a new table in my back_end datadase.. i did it! added it but when i try to connect it to my Front Database using Linked Table Manager The new table is not there... i try this method...
  5. P

    Problem:TAB CONTROL

    good day! i have a problem in my database i created 2 table namely tblrecord and tblenrol and in my form i created a TAB CONTROL page 1 is Record (source is tblrecord) page2 is Enrolment (source is tblenrol) i use FORM DESIGN MODE and click Add Existing Field i drag and drop the tblrecord...
  6. P

    Help:DLOOKUP in Unbound textbox

    good day this is my first time i will use dlookup function as suggested by one of the member here. i tried to search to my friend google.com about this function and i learn the syntax and apply it to my sample database. but im having problem in my criteria. attached here is my sample database...
  7. P

    Question: Relationship in FORM

    i have 2 table consist the following: Table1: Field1:Name1, Field2:Number1 and Field3:Address Table2:Field1:Name1, Field2:Contact1 and Field3:Age they are both in separate form Form1:Table1 Form2:Table2 in every table i make a query on them and connect the query to my form as you notice in...
  8. P

    Question: is this possible??

    i split my database now its the formdatabase and the other which called back_end database... my question is... is there a way to make it 1 database again? if there is how? thank you..
  9. P

    Help: How to sum in the Form View

    good day i created a database with the following information: tblrecords field1 Produnt field2 Amount field3 Discount field4 Total and i make a query of my table then create a from base on the query... my problem is in the total field in the FORM is not working... the total should...
  10. P

    Print preview command button problem

    i have a button in my form which named Printpreview, the function on this is to printpreview the current record in the form... i trid this code but its not working my form name is frmrecords Private Sub Command112_Click() DoCmd.RunCommand acCmdPrintPreview End Sub
  11. P

    return to original record when duplicate field detected

    i make a enrolment form i make a button which goto new record what i did to prevent duplicate entry in the form is in in Student Number Field, Indexed i put: Yes (No Duplicate) im searching how to prevent the duplication, raise a custom error message and return the user to the...
  12. P

    Color Fill Box in Forms

    attached here is sample of a form contains name and color code... problem: the color code box should be fill with a color you select now a word... for example if the color code is red when you click the box a set of color will appear and if you select the red color it will fill the box... i...
  13. P

    Printing Form

    hi there... i have a problem, when i print a form the buttons are also included, the following button in my Form header are save,back, add record, delete record and print record... when i click print record i go directly to the print review of the form but i noticed that the buttons are there...
  14. P

    Search form connected to the other form

    hi there ive been trying to make 2 forms first form contains search form then second form contains the record... my problem is i cant get it when i type the value in my search form i go directly to my record form but the value i type is not appearing,, attached here is the sample..
  15. P

    How to put Total in pagefooter in report

    hi attached here is the sample of my dbase consist of the following Table> total here is i just click the auto sum in the ribbon Query>Source Table :total here i just click the auto sum in the ribbon Report>Source Query Form>for searching records here my dbase work: in the form consist of 5...
  16. P

    Form size

    hi i want my form to be manimize the space attached here is the screenshot of minize form... my form is in maximize My Form: i want my form to be like this size.
  17. P

    How to set up log inform with different rights

    hi i have my log in form with 2 user, my problem is they are both admin user... what i want is user1 admin user, can edit fields in the form, and user2 cannot edit in the form... here is the code behind the login button in my log in form: Private Sub cmdLogin_Click() 'Check to see if data is...
  18. P

    Unrecognize Database Format

    ok im using MSACCESS 2010, when i open my database in MS ACCESS 2007 the error occur "Unrecognize Database Format" does it mean the a database save in access 2010 will not open in lower version? how can i import the codes from access2010 to access2007?
  19. P

    Right Click in Form is Disable

    hi anyone know how to disable rightclick in the form it self for security reason so that the users cannot edit the form... any VBA code? thanks....
  20. P

    From Form>Query>report

    ive been looking in google for the answer to this question.... here is the situation: i have a form the source is my maintable... from the main table i created a query for the search button in my form like this... Search by Municipality: "enter the desired municipality to view" Search by...
Top Bottom