Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ailyn
  • Order by date
  1. ailyn

    outside form

    Anyone any idea, please?
  2. ailyn

    outside form

    Then where should I post it?
  3. ailyn

    outside form

    Sorry, I didn't mean an access db. There are forms on different websites on the internet and I wish to fill all those forms only once. Then the application should be able to send that info I filled to those forms and submit it for me. Is this still confusing?
  4. ailyn

    outside form

    I probably shouldn't be posting this here, but I don't know to which forum it belongs because I don't even know if this is possible. Could you from your computer fill in a form and then make it go to a specific internet address and fill in the data and submit it for you? Is that possible? In...
  5. ailyn

    hide access not working

    Ok, forget what I just said I tried the minimize option! Now on hide it gives me the following error: "cannot hide access unless a form is on screen
  6. ailyn

    hide access not working

    Thanks, PHV. Now it makes a very weird thing. I open the mdb that opens acces for a split second then everything hides(minimices) and then it jumps on the screen again. ?.? I thought it was supposed to leave only the acces form visible and hide access itself. Isn't that what it is supposed to do?
  7. ailyn

    hide access not working

    Hi I tried to use the hide access options from this script: Option Compare Database Option Explicit '************ Code Start ********** ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in...
  8. ailyn

    Unbound sum record problem

    Well, I solved it by setting the TOTAL value from tblProformas in the ctrl Totalctrl and setting its value from the previous form. I really couldn't get it to work otherwise. Thanks a lot for your help, guys!
  9. ailyn

    Unbound sum record problem

    Could it be some mysterious option of the form? I copied and pasted the same boxes from another form and they show their values but keep having the same problem with the freightcharges. Any ideas? I tried this simple code but in this form nothing seems to work! Private Sub Form_Current()...
  10. ailyn

    Unbound sum record problem

    Sorry I didn't but now I did and it didn't work. I always get only the FreightCharges. I'll have to recheck all the values one by one, because otherwise I don't see what could be wrong.
  11. ailyn

    Unbound sum record problem

    Sorry, Zameer already tried but the result is the same.
  12. ailyn

    Unbound sum record problem

    This is the code for the button that is supposed to set the info: Private Sub SvProforma_Click() On Error GoTo Err_SvProforma_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'set Total in Proformas Dim strSetTtl As String Dim strTotal As Currency...
  13. ailyn

    Unbound sum record problem

    anyone can help on this one, pleeaaase?!
  14. ailyn

    Unbound sum record problem

    thanks for the help, Jerry but I get the same results.
  15. ailyn

    Unbound sum record problem

    Thanks Zameer! I just realised that the update was not recognising the ProformaId for the Where value so I changed it too. The problem is that it doesn't save the appropriate value yet. You click on save once, it saves the transport costs, the second time you try it saves the right amount...
  16. ailyn

    Unbound sum record problem

    Hi! I have an several unbound boxes, that calculate the final price for an order. The first one gets the subtotal from the subform the second one discounts the reduction percentage, the third one adds the VAT and the last one gets the transport costs and adds them getting the total. It's pretty...
  17. ailyn

    UPDATE not working

    Thanks KenReay, the first problem is solved. now the appropriate field gets marked but only for the first orderdetail (first productId and first blowerId).How do I do it to mark them all?
  18. ailyn

    UPDATE not working

    I have a form Orders(tblOrders) with a subform OrderdetailstblOrderDetails). In the subform we can fin ProductId and BlowerId that come from tblProducts and tblBlowers. This way we can make one order and order several products. the thing is when I click on a button for saving the order and the...
  19. ailyn

    stLinkCriteria and Null

    THANKS! It works! That deserved a star. XD
  20. ailyn

    stLinkCriteria and Null

    Hi! I'm trying this to see if I need to make a new record or I just open the existing one: Dim stDocName As String Dim stLinkCriteria As String stDocName = "Proformas" stLinkCriteria = "[Proformas_OrderId] = " & Me![OrderId] If IsNull(stLinkCriteria) Then DoCmd.OpenForm stDocName, , , ...

Part and Inventory Search

Back
Top