Search results

  1. I

    NumLock

    Hi How to make Numlock to be always on in Access
  2. I

    Stored procedure

    Hi I have a little problem..Trying to update field in ODBC linked table from Local table. Here is my code..see pict Code when code reach cmd.Exceute I got this message...see pic Error My sql file in store procesure is ..see updatekolicini.sql Any sugestion or help Thanks in advance
  3. I

    Transferind big amount of data

    Hi I have database and tables in HostGator and it is connected trough ODBC. Everything is fine. I want to transfer several thousand records from local tables to ODBC connecetd tables. I was trying using Access append Query but it is too slow. What is the fastest way to transfer data from local...
  4. I

    Database on HostGator

    Hi I created a database in HostGator, in PhpMyAdmin, and conneted through ODBC with my Access frontend app. My question is how big can this database be in size of MB, becouse I intend 8 pharmacies to be connected on it. For your info, one Pharmacies working for two years, backend database was...
  5. I

    Using Zebra for fast inventory

    hello How can ZEBRA be used for fast inventory in microsoft access.
  6. I

    after closing app file lock still reamins

    hi After closing app file lock is still remaining so I cannot ente in design mode. Also I cannot delete manually this file What can I do?
  7. I

    five caracter string

    Hi how to generate five caracters string of capital letters and number from 1 - 9, for example QQR5T, GH67P...AND SO ON Thanks !
  8. I

    scanning barcode

    Hi. When scanning barcode of a product, scanned barcode stays in a field and need to press Enter to read it...this happens in only one computer. In all others everything is ok...I assumed that the problem is in local comp but how to solve it... Any ideas
  9. I

    Inserting code of other languages in vba procedure

    Hi I have a question. can I insert code of other languages in VBA procedure? like this in HTTP: POST /api/Auth/GetToken HTTP/1.1 Host: api.fzo.org.mk Content-Length: 101 <LogIn> <UserName>farmacevt@fzo.org.mk</UserName> <Password>P@ssw0rd</Password> </LogIn> or like this in...
  10. I

    get token

    Hi Can anyone help me getting token using this: curl --location --request POST 'http://api.fzo.org.mk/api/Auth/GetToken' \ --data-raw '<LogIn> <UserName>farmaceft@fzo.org.mk</UserName> <Password>P@ssw0rd</Password> </LogIn> I am using this code but no success Dim req As New XMLHTTP60...
  11. I

    bearer token

    Hi How do I send a POST Request with Bearer Token Authorization Header? .
  12. I

    IF ChildNode EXIST?

    Hi I want to check if this ChildNodes exirst...(fund_code) in the example ...prescription.SelectSingleNode("./issued_drug/fund_code") Thanks
  13. I

    Values from subform to main form doesnot work on every comp

    Hi..i have a database installed on more than 30 comp in diferent cities..On each one values from subform to mainform is workin perfectly, but only one is not working..I tried to figure out what is the possible problem on that comp..The problem is not on my program..Any ideas..see the pic below..
  14. I

    Pressing F7

    Hi after pressing F7 in a control field (barcode - first field) I got this message (see Pic_2). when pressing F5 everything is ok. Any suggestions?
  15. I

    frozen report section

    Hi is it possible to freeze report header section and only detail section to scroll up and down? Thanks
  16. I

    deleting records

    Hi I have deleted some data from my database. it was about 350 mb. After deleting I did Compact & repair so deleting to take effect. But instead of lowering it has grown up to 530 mb..What went wrong? Any suggestions?
  17. I

    Insert into?

    Hi why this doesn't work mATC_FULL = "escitaloptam tabl. 20 mk" DoCmd.RunSQL "INSERT INTO tblXML_LEKOVI_KOM (GENERIKA_FULL) VALUES (" & mATC_FULL & ")" field GENERIKA_FULL is text
  18. I

    AfterUpdate

    Hi I have two form, the small one and the bigger one. From small one wit double click of a mouse I transferred value to bigger form. See Pic1. After I move mouse to bigger form I get this See Pic2. I put the mouse at the end of a control to avoid black selected. see pic3. On Enter AfterUpdate...
  19. I

    copying and paste a value with a click between two forms

    Hi I have a from with two columns. I like with a click of a mouse (double click) to transfer value from from one field to another field in another form. Is it possible?
  20. I

    sintax error

    Hi Why I get this message..please see pic1 and pic2 Thanks in advance
Top Bottom