Search results

  1. alkrm

    conver number to date

    BUG i though that solved it but.... THIS WAY IS ONLY ADDING THE MONTHS WITHOUT TAKING CARE OF THE MONTHS WITH 30 DAYS OR 31 any extra directions thnx in advance
  2. alkrm

    conver number to date

    that's fair enough THANX
  3. alkrm

    conver number to date

    hi, i have this main three fields date of buying "date/time" formated duration "number" formated maturity"date/time" formated doing this formula, Maturity = [date of buying]+[duration] where duration is in months how can i convert the number to date/time format , so i can make the formula...
  4. alkrm

    transfer field contents to another field

    YAH, THAT SOLVED MY PROBLEM LOT OF THANKS FOR THE GREAT HELP I GOT , FROM BOTH OF U
  5. alkrm

    transfer field contents to another field

    the data in the action field , i want it to transfer to the task subject when i press the button. am using this ,n still it just open the Task assign form without sending the content of action as new task subject !! Dim x As String Dim y As String x = "TaskAssign" y =...
  6. alkrm

    transfer field contents to another field

    DX this ain't working ! i need the button so i can count some choosen actions as a tasks , so when i press the button ,it takes me to the task form with the action as new task subject. in ur answer , it will take count all the actions as tasks, n there 'll be no need for the button. is there...
  7. alkrm

    transfer field contents to another field

    hi , i have two forms of two seperate tables. Form 1 , has these fields : Name "Text", Issue"Memo",Action"Memo", Form2, has these fields : Task ID"Number", Task Subject"Text of 200 characters", what i want to create is : to create a button at form1 that when i press it opens me form2 with...
  8. alkrm

    Disable F11 key

    great. thanks
  9. alkrm

    Disable F11 key

    hi there, does any one knows how to disable the F11 Key ?? thnx in advance
  10. alkrm

    query report

    hi, i created a repot for a query which has the field catigory in the creteria of the catigory field , i wrote this [enter the catigory], so when the user run the query he get he data related to this catigory he wrote, my question is , can i change the label which he enter the catigory name to...
  11. alkrm

    toglle buttons

    check the Northwind database , it has a form with such thing
  12. alkrm

    login then filter by user

    what i mean is, all the forms that has information about the user will be filter upon his log in name, so he can't see the others records , not only the one form "filter all the forms without open it " , caz the forms r closed , but the user might open it later , so is there is a way to do that...
  13. alkrm

    login then filter by user

    hi , thanx for ur reply , check this out, i used the wizard and i could filter one form upon the text box i am using for entering the user name, this is the code"text1 is the user name ","name a field in the info form": Private Sub log_on_Click() On Error GoTo Err_log_on_Click Dim...
  14. alkrm

    It must be obvious but not to me!

    solving ur problem without activex controls check the attached db. copy the module, the zncalendar form to ur db , check the testform properties 2 assign the label to this calender. and that's it
  15. alkrm

    login then filter by user

    hey at the start of my data base, u have a log on form, and then u will go to another form where u will have the information . can we sort"filtere" the forms by the log in user ? i mean , if the user name is "X", this is on a log in form. then the other forms will be filtered Related to X...
  16. alkrm

    My Database

    first part: Creat a query of the table your form is based on , at the query design of it, select the fields you would like ur query to include, "include the Table id" , at the criteria of the id"or any other unique" field type [] or [enter the id] , Run the query , u will type the id and u 'll...
  17. alkrm

    report to destination as txt file

    Thanks for ur help, and for the Great Idea of timming
  18. alkrm

    report

    .. Sure you can create a report based on a form , as the form is based on a table "or a query" so u can creat report based on the table"query" ur form is based on , use wizard!
  19. alkrm

    report to destination as txt file

    hi , i need help with my code, am using this code to send a report as txt file to the desk top, dim x as string x="the report name" docmd.OutPutTo acReport, x with that code am going to the output window to choose the file format ,and then to another window to choose the destination"desktop...
Back
Top Bottom