Search results

  1. C

    newbie question: two actions for a command button

    Mike, thanks a lot for the detail explanation on how the macros works. Really appreciate it! So what i understand from post is that i just have to add the below code in blank command button onclick event. Is it correct or am i still not getting something ?:o DoCmd.RunCommand acCmdSaveRecord...
  2. C

    newbie question: two actions for a command button

    Thanks Mike for replying. So you mean i add two actions i.e.save & open form in a macro and then add the command button as a macro. Is it correct?
  3. C

    newbie question: two actions for a command button

    Hi all, I am really new to designing forms in Access and something came up while designing one. I have a form with different fields and theres a command button(save record) whose action is to save the record but i want to add another action to the same button which will open up a form. Is...
  4. C

    How to do these things ?

    Any help ?
  5. C

    How to do these things ?

    Pat Hartman, i really appreciate your help but the problem is that i am kind of a beginner in Access and i would be really greatful to you if you can explain in some steps ( a kinda detail ). Thanks once again for your help and i am really looking to your reply.
  6. C

    How to do these things ?

    ^ it isn't working. I have created two options "Issue Vehicle" and "Cancel Vehicle" and edited the code like this: For "Issue Vehicle" option: If Me.Issue Vehicle= "Issue Vehicle" then Me.Issue Vehicle.Visible = True Else Me.Issue Vehicle.Visible = False End If For "Cancel...
  7. C

    How to do these things ?

    ^ Thanks for the help Pat Hartman. But whats "WhereTo" in the code ? And do i have to put both of these codes in expression builder of both the options control ( i.e. Option 1 and Option 2 ) ? Or first code in the Option 1 and the other code in the Optios 2 ? I am new to these access coding...
  8. C

    How to do these things ?

    Yeah but how do i implement it on my first 1st and 2nd questions ?
  9. C

    How to do these things ?

    Hello all ! I am kinda new to access and made a transport database but it needs some changes which are out of my knowledege so i am hoping that you guys can help me out. There are the 2 things that i would like to do in my forms: 1=, I have a form where all the new cars are added to DB...
  10. C

    transfer data to other tables ?

    ^ I think you didn't get me there. Anywayz, i am attaching a sample of what i am trying to do here. Its examples of comoboxes. Goto the example of "Lookup" and when you select a "employee number", the data below it automatically comes in the fields. Thats what i am trying to do here.. Does...
  11. C

    transfer data to other tables ?

    Pat Hartman, I do understand you but my requirements is to do what i said in my above post. By using the subform the data would increase too much that it will be difficult to manange it as we have to scroll down every time we enter data in data entry fields. So any help ?
  12. C

    transfer data to other tables ?

    Employee and Vehicle will be entered in thier respective tables. Can you please tell me how to do what i said in my last post ?
  13. C

    transfer data to other tables ?

    ^ There is a attachment but i understand. It won't be possible for you. I have to do this myself. One more thing, is there anyway to do this: ? For example, i have 2 fields " Vehicle Code" and Employee Code". I have added a new record, entered Petrol usage ID ( Auto no. ) selected vehicle...
  14. C

    transfer data to other tables ?

    ScottGem, i know i gave you a hard time during all this discussion and i am really thankful to you for bearing this with me :) Now i have this last request for you. As i have attached the database, can you please make the changes that you think should be made to this DB. It will be easier for...
  15. C

    transfer data to other tables ?

    lets make it simple...i would simply like to enter the total petrol used every month and not record the details of when it was filled - just the total petrol usage every month... can you provide your insights on this?
  16. C

    transfer data to other tables ?

    ^ here it is again. Username = Admin PAss= home2000 ( IF It asks for it )
  17. C

    transfer data to other tables ?

    K.. Can you please check this databse and let me know if its OK to do like this. Open the form" tbl_petrol_usage_details" and check if its the right method to record petrol filled date. LINK : http://s5.yousendit.com/d.aspx?id=18NLE0THXPM431K3P59M89JH7P Thanks once again.
  18. C

    transfer data to other tables ?

    I can't really understand this .. Can you please explain this ? When we enter a new record every month for a particular car and employee of thier petrol usage we will have to enter all the data in petrol usage table everymonth which i don't want. Any help ? I am new to Access so please guide me ..
  19. C

    transfer data to other tables ?

    I want to bound "Petrol filled date " field to Petrol usage tabel. So i just have to enter the filled date instead of entering all records in petrol usage table when entering new record of a particular car every month.
  20. C

    transfer data to other tables ?

    I do understand that but by doing that i have to enter all the required info in petrol usage table every month when i update petrol usage. Is there anyway by which i only have to update the petrol filled date ? I tried that by having Petrol filled date as a subform but for some reason its not...
Top Bottom