My back end database is almost 490 mb. and was going slowly through network.
After deleting almost a more than miliion of records the size didn't change at all. it still remain 490 mb..How is that possible. Any ideas?
Thanks
Hello
I am sending query to Excel and everything is ok if in References is Excel 15.0 Object Library. To avoid Excel version I made it late binding..and everything is ok until the code reach this line:
.Range("A4:F4").Borders(xlEdgeTop).LineStyle = XlLineStyle.xlContinuous
I got this message...
I am trying to solve this:
Dim xml As String
Dim req As New XMLHTTP60
Dim resp As New DOMDocument60
xml = "<?xml version='1.0' encoding='UTF-8' ?>" & vbNewLine _
& "<root>" & vbNewLine _
& "<SecurityKey>633862AD-22B0-4813-93A0-...
After using function key F5 or F10 in a certain field I want the cursor to stay in the field but the cursor is going to another field. Using a function key calls a procedure. Key preview is set to yes. Why my cursor is being moved?
HI
How to solve this comma problem?
DoCmd.RunSQL "INSERT INTO tblMAK_FAKTURI (NUMBER, DATE_DOK) SELECT ('" & mNUMBER & "'" & ", " & "'" & mDATE_DOK & "'" & ")"
all values are strings
I got this message Syntax error (comma)
Thanks
Thanks a lot
After a short thinking I found this solution..and it works perfectly
Code Tags Added by UG
Please use Code Tags when posting VBA Code
Please feel free to Remove this Comment
https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/...