Search results

I found a similar question in the below link i hope it helps me: https://www.experts-exchange.com/questions/26923910/How-to-save-and-read-files-stored-as-FileStream-in-SQL-Server-2008-from-MS-Access-2007-vba.html

I would like by using ms access (FE) read pdf files from shared folder and then write this pdf file in varbinary (max) column of sql server table. And also reading this pdf file by accesing to this varbinary (max) column. I found a almost similar question in the net that was using ADO stream...

If it is possible please explain more about importing E-data in local table. You mean I have to create the local table (MyEdataImport) in sql server and then making a link from ms access FE to that? About importing E-data into local table, you mean puting E-files in "File table" of sql server?

Thanks a lot for break down my question actually i do not know what is the procedure and sequence if i want to upload E-files from ms access to Sql server and then can view that from ms access. What i know is just a very a little about 1-upsize 2_ADO 3-filestream 4-filetable But i do not know...

I have upsized my access database to sql server. Now there are linked tables from ms access (FE) to sql server (BE), I would like to upload files in sql server from ms access (FE) and can view and download also from ms access (FE). I would like to know what changes i have to do in design of sql...

yes you are right my query did not work for some cases and also it was slow. i checked with another query (group by) first tried to catch date when val(rev) is max for each docno then with group by query get max(rev) like below i checked it works, but i would like to do it totaly with...

with using val() function and sub-query I used below query,it seems also this one works.

I could not define as number , i have different value in "rev" field some of them are like numbers and some are number+alphabet , i would like in the query for example: 1<2a<3 I mean number is main part of my "rev" field , is there any way?

I have a table , it has 2 field (docno,rev) and type of both of them is (text) now i would like to return maximum value of (rev) for each (docno) data of my table is like below: docno rev doc-0001 1 doc-0001 2 doc-0001 2a doc-0001 11 doc-0002...

I have a form, its name is "form3" there is a button on the form and click event of this button is like below: Option Compare Database Public Sub Command0_Click() 'DO SOME THING End Sub Now i wanted to call this sub from a macro, i have created a function like below and try to call...

thanks, this query quickly comes up. but surveying in the query is slow.

I checked the query with more than 1000 records in the table was very slow. I put indexes on the table but still query is very slow. please help how i can solve the problem

I have a table and its name is “ztbl_Line_Trend” and its data is like below: Date_List DISCIPLINE Done_Doc 9/21/2009 Building 2 9/22/2009 Building 1 9/23/2009 Building 3 9/21/2009...

Before i was using F11 shortcut key for displaying navigation (forms, tables, queries,...) now i have changed my computer to mac and installed windows 10 and ms office. Now after opening ms access file and press F11 does not work. I would like to know which shortcut key works like f11 on mac key...

i am a bit confused about using # for date criteria in query. what i know, when I enter hard coded date in design query, i have to use # at first and of date in criteria for example #4/24/2016# also i have see in some books in functions use # with form controls and some times in parameter query...

Thank you, maybe my problem is in designing of query, in designing of query i have sorted by another fields and then i try to sort by date in data sheet view of query. I will change sorting of fields in design query.

Field in my table is text but datevalue() field in my query is data/time. And actually opened this query and try to sort by datevalue() column in query data sheet view.

In the maked query i have made experession with datevalue(field column) and checked this expression with isdate() function that returns true. Actually i do not understand what is difference between usage of datevalue() function and cdate() function?

I am in data sheet view if a maked query. Query has been sorted by another field, when i click on coulmn header of date field it does not sort properly.

In my table , i have a field and it's data type is date/time and all of values of this field are date. like below for example: 3/4/2015 12/5/2015 Actually i checked with isdate() function this field all returns "true". Now when i sorting table (ASC) by this field it sorts...