Search results

  1. N

    Solved How reference an IP Address Control In MS Access

    Many thanks this is what I wanted
  2. N

    Solved How reference an IP Address Control In MS Access

    I want to reference an Ip Address from a text control in a form to VBA , currently I'm hard coding it like below: stUrl = "http://192.168.8.110:8080/xxxxxxxxxxxxxxxxxxxxxxxxxxxx"[CODE] Now instead where I'm putting "192.168.8.110" I want to use a control as reference ,example...
  3. N

    Solved Forwarding a port number such 8080 via in bound rules-MS Access FE

    Many thanks for the detailed answer sir. Regards
  4. N

    Solved Forwarding a port number such 8080 via in bound rules-MS Access FE

    Support three computers are using MS Access, now to communicate to the virtual server using the windows resources stored on the local server we need to forward the connection port such us 8080, via the windows firewall, correct? What if all three computers on the same network are using...
  5. N

    Solved How to increment a number with VBA

    Many thanks to all .
  6. N

    Solved How to increment a number with VBA

    Dear all I'm now screwed out here : I want to increment a number in format (1) 0000010 to 99 (2) 0000100 to 199 (5) 0000200 to 299 ETC I have tried to use the primary key but its considering the zeros Private Sub itemTyCd_AfterUpdate() Me.itemCd = Ctri("000000") & Me.ProductID End Sub
  7. N

    Solved How to format unbound MS Access to Receive a Pure String

    Thank you people all your answers are valuable no answer is wrong , it now turned out that I just needed to enter the value the way it is in unbound control and Json accepted it as a string
  8. N

    Solved How to format unbound MS Access to Receive a Pure String

    Do you mean you want to validate the data in an unbound control to ensure it's a string? If so, the Before Update event is the place to do that. Here is what I want to enter : CZ110062536406AETY
  9. N

    Solved How to format unbound MS Access to Receive a Pure String

    I think I neglected this one, how do we format unbound control in MS Access form to hold a pure string that can be referenced in VBA and recognized as a string?
  10. N

    QR Code In MS Access

    Hi I'm trying to implement a QR Code with VBA in Access sales invoice, this is done by reference a URL received through Json from the virtual server and then stored in my BE in the same line for the sales invoice and date such that if I pull the invoice, it will also show the URL received from...
  11. N

    Solved Saving one field from Json String received in MS Access

    Many thanks to you people for assistance all is fine now With Regards
  12. N

    Solved Saving one field from Json String received in MS Access

    Sorry people I thought this was going to be very easy, but I seem to run into trouble again, I do not seem to be able to grab the resultCd field from the received Json string could it be there is an error again in my code: Json string received {"resultCd":"000","resultMsg":"It is...
  13. N

    Solved MS Access Unbound Combo Box

    Ok thanks minty
  14. N

    Solved MS Access Unbound Combo Box

    I want to use this unbound combo box on a subform for the purpose of looking up only because the same form support imported data, but when the users select the product name you find that that product name repeat itself in the second line which I do not want to see or happen. Any idea to stop...
  15. N

    Solved Evaluating conditions in MS Access with VBA

    My apologies people I'm sorry the original code actually works , I forgot that it was on after quantities updates, however, many thanks to all the contributors. If (Me.TaxClassA = "B") And (((((Me.RRP) / 1.16) * Me.Quantity) * 0.16) > ((((Me.UnitPrice) / 1.16) * Me.Quantity) * 0.16)) Then...
  16. N

    Solved Evaluating conditions in MS Access with VBA

    The result that must be archived is that , if RRP is higher UnitPrice then return : (Me.RRP / 1.16) * Me.Quantity * 0.16 Otherwise RRP < UnitPrice then return : Me.Taxamount =(Me.UnitPrice / 1.16) * Me.Quantity * 0.16
  17. N

    Solved Evaluating conditions in MS Access with VBA

    I'm trying to evaluate four conditions in Ms Access in such a way that tax must be charged on the higher price not the lower, but I keep on get one way evaluation even if I try to lower the other figures to see if there will be a change in calculations nothing happens: VBA Code Affected If...
  18. N

    Solved Just seeking an independent check on line counting and referencing in MS Access VBA

    We already had this topic, didn't we? Sum(Round([NetValue] * Tax), 4) vs. Round(Sum([NetValue]) * Tax, 4) It doesn't have to be the same. The double being suggested here is very poor in terms of handling financial data, the correct and accuracy way is to use currency data type
  19. N

    Solved Just seeking an independent check on line counting and referencing in MS Access VBA

    Hi Josef P My question is all about accuracy not the speed, did you find any issues with the code in terms of accuracy processing? Best Regards
  20. N

    Solved Just seeking an independent check on line counting and referencing in MS Access VBA

    Okay thanks I will have to switch on the error handling , its off The good Json is below { "tpin": "1002623668", "bhfId": "000", "cisInvcNo": "CIS001-0002950", "orgInvcNo": 0, "custTpin": "1002623668", "prcOrdCd": 0, "custNm": "SAMPLE CASH SALES", "salesTyCd": "N"...
Back
Top Bottom