Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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
  9. D

    Stretching Form

    Hi, I have 2 command Buttons under each other in a Form, I will click the Top Command Button and it will open a subForm between the Command Buttons and Stretch the Form Down, and when i hide the subform, i want to see the 2 command buttons on top of each other again. Can anyone tell me what...
  10. D

    1 Command Button 2 actions

    In a Form i have a Command Button where with it i want to Load and Unload a Subform, and each time i Click its caption changes, to Load or Unload. shall i do 2 command buttons and play with visible property?....like 2 command buttons on top of each other when one is clicked its visible property...
  11. D

    one to many

    I have a Main Table recording Employee Info Fields lets say: Name, Sirname,Address, ChangeDateID i have second table to track changing address fields lets say: ChangeDateID, changeDate, AddressChange i created a subform of second table. i created a Main form with RecordSource the Main...
Back
Top Bottom