Search results

Backend SQL SERVER

Hello after the record is inserted into DB, I want the current field value divided/ 100 Current Record Only Not all records

Friends How can SetField Value after insert I want after insert row Myfield Value for this row divide / 100 You can see the field setting on Table Macro If you could fix DataMacro Thank you so much

converted the format to fixed and the number still 17 thank you

can I use a custom format? ###.000 the textbox is bound to the table and the user enter data inside this textbox

17

Hello I have textbox on a form bound to a table when changing the format to percent it display number 17 to be 1700% I want to show it as 17% thank you

friends; there is 2 table in this DB as an example Category Compay I want on the Query to display the unique company Record but When searching by Category the company related to the category appears I will Search By Category But Company Name must be a unique row How can I do that

I want to store the Path of the file (Online) path inside string field user click on this link or string open the file

up

Hello @arnelgp all file is converted from Attachment to ole object my problem now: Is the size of the DB Do you have any solution for compacting the OLE Field to the lowest size? my plan is: 1- download the file on HD (PDF) 2- Compact the file to minimum quality 3- reattach the file to...

I'm using GoDaddy and access and SQL server I can store the pdf in the web hosting folder but I don't know how to get the path of the file from the Microsoft access

I have a limit for the DB 200 MB Only

Online

Hello I Store PDF in Var Binary field in SQL server Db How can I compact this field to a minimum size Because the DB become bigger after uploading some PDF FIELD Any tips or tricks Thank you so much

Hello friends; Is there any way to compact OLE OBJECT FIELD Contain files to reduce the size of the DB

with Docx extension only I remove this extension and work

one error

Thank you so much Testing now

Hello This error appears @arnelgp I suggest if possible: use the same ID from the import attachment table so I can review between the old table and the new table because I can't review by foreign key because I don't find some fk and all data not imported because the above issue and there...