Recent content by Dummy

  1. D

    subreport wont even display!

    i guess ur subform is null with no records, try to fill something then view
  2. D

    Deleting table Record from Listbox

    you said something right, i dont want to delete the EmployeeName, but i asked the question generally since when i get the code i can use it for good purpose. i have put other command in this Unbound form to open a Form for new record entry, and lets say the user clicked it wrongly and a new...
  3. D

    Deleting table Record from Listbox

    hi, I have in an unbound form a List box with Row SOurce of EmployeeName from a table, im selecting one of the names of the employee and loading form of specified Employee name using filters I want to create a command button to delete the selected EMployee Name from the list Box (which in its...
  4. D

    Removing Blank Subforms

    maybe i was not clear enough, i have something like 7 subforms in my Report, its data is taken from a Form input, they both have the same Source table. when some subforms are not filled with record in the form, they are not appearing in the Report, but just their Caption is appearing which is...
  5. D

    Removing Blank Subforms

    i have many sub forms in my form, but not all subforms are filled with records on my form, so the ones not filled with record is leaving the report blank and displaying only its captions (my subforms are viewed as Datasheet in the report), Can i do something so that those Captions that i am...
  6. D

    On Change Data

    hi, i have a formula where i want to calculate it each time im doing next with the data navigation button... i tried to put the code in "on change data", "on after update" of the form and its not calculating... the formula is correct and its working in other fields. where i shall put the code...
  7. D

    Where Condition in Report

    Thank You Sir, this is it:)
  8. D

    Where Condition in Report

    i have a form of Employee Info, where with navigation button i move to the next employee. i have put a Command button to Preview Report on Single Employee Info that i am reading currently. So i want to Filter the Report with Single Employee Name and records so im coding on click even of the...
  9. D

    1 form 2 queries

    hi, i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent can i assign in One Form's Record Source 2 Queries? not at the same time for sure...let me give the correct figure i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent when i click cmdOld i will load a...
  10. D

    Screen Resolution

    hi, i was worked on Access with my screen resolution 768x1024, and i took it to run in another PC of display 600x800, and as a result form sizes where changed and many many things to edit again, is there a coding so that when i run the access it checks the display size of the system screen...
  11. D

    Calculating Date

    hi, Check the attached File, i have a form with 2 text box, one is entry of Date Employed and after update the second text box calculating the current system date will subtract both years to display how many years Employee worked i've put =Date()-[DateStartedJob] After update of first text box...
  12. D

    onLoad View as Datasheet

    thanks :)
  13. D

    onLoad View as Datasheet

    check the attached file...its a stupid thing...but in all cases u know my name hehe
  14. D

    onLoad View as Datasheet

    yes sir, i am surprised why
  15. D

    onLoad View as Datasheet

    hi i have created subforms and set the Default View to Datasheet Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW. Any Clue? Thanks
Back
Top Bottom