Great video, as always! One thing real quick though. There's actually a function in Access called vbNewLine that also does a line break if added into a string 😊
Hi, thank you for your great videos. I browsed alot but couldn't find a tutorial, can you please do us the needful by making a tutorial? In access forms, I want an upload file button and a view file button. It can allow me to upload files directly to the sharepoint folder or google drive folder, onedrive etc. If not possible, i upload the file at sharepoint folder and can paste the link in the field. As it is uploaded, there should be view file button that can display the file in browser.
Good idea for a video. Many of these tools like DropBox, Sync, and others have an app you install that allows you to designate a local folder to mirror the remote folder. So, you can use something like FileCopy th-cam.com/video/o8VMtHRW3w4/w-d-xo.html to just get the path and then copy files between folders on your computer or to pick a file to open. The synchronization with folders on the web will happen automatically. This is just one method, there are others too.
Great question! If it is Windows text, you can split to an array: arText = Split(strText, vbCrLf) lngLines = UBound(arText) strLastLine = arText(lngLines) If it is from Linux or Mac, you can try with Chr(10) instead of vbCrLf. Or Chr(13)
Not really; vbCrLf is not a function, so it won't accept (). Also, vbCrLf = Chr(13) & Chr(10), so if you remove the (), you will still just replace the same thing with the same thing. Also Z: would need to be Z =
You can use a similar pattern as this video, except to use QueryDefs instead of TableDefs. th-cam.com/video/ywTfKmei5Qc/w-d-xo.html Make a string as you loop through and put ; as you add each item. Then set the RowSource for your combobox to this string.
Thank you Sir! Commenting for the algorithm.
Great video, as always! One thing real quick though. There's actually a function in Access called vbNewLine that also does a line break if added into a string 😊
Thanks for the info!
Great video, thx.
Glad you liked it! cheers
شكرا
My pleasure!
🎉
I need a loooooooooong break
🥇
Ha!
Hi, thank you for your great videos. I browsed alot but couldn't find a tutorial, can you please do us the needful by making a tutorial? In access forms, I want an upload file button and a view file button. It can allow me to upload files directly to the sharepoint folder or google drive folder, onedrive etc. If not possible, i upload the file at sharepoint folder and can paste the link in the field. As it is uploaded, there should be view file button that can display the file in browser.
Good idea for a video. Many of these tools like DropBox, Sync, and others have an app you install that allows you to designate a local folder to mirror the remote folder. So, you can use something like FileCopy th-cam.com/video/o8VMtHRW3w4/w-d-xo.html to just get the path and then copy files between folders on your computer or to pick a file to open. The synchronization with folders on the web will happen automatically. This is just one method, there are others too.
fantastic
Thanks!
thanks
Welcome!
I want to read the last line from a text. How will I do it?
Great question! If it is Windows text, you can split to an array:
arText = Split(strText, vbCrLf)
lngLines = UBound(arText)
strLastLine = arText(lngLines)
If it is from Linux or Mac, you can try with Chr(10) instead of vbCrLf. Or Chr(13)
can i use this code in access instead ..
Z: Replace([Long_Text],vbCrLf(),Chr(13) & Chr(10))
??
Not really; vbCrLf is not a function, so it won't accept (). Also, vbCrLf = Chr(13) & Chr(10), so if you remove the (), you will still just replace the same thing with the same thing. Also Z: would need to be Z =
great
Much appreciated!
Sir
I want all query name in combo box
Please solve
You can use a similar pattern as this video, except to use QueryDefs instead of TableDefs. th-cam.com/video/ywTfKmei5Qc/w-d-xo.html
Make a string as you loop through and put ; as you add each item. Then set the RowSource for your combobox to this string.