ms-access-2003
Invalid Procedure Call on DateDiff with MS Access Driver
The following query: SELECT DateDiff(\'month\',0,\'2000-01-01 00:00:00\'); Returns a \"[ODBC Microsoft Access Driver] Invalid procedure call\" error, with the bizarre code of 22018.[详细]
2023-02-05 09:29 分类:问答filling several columns with 0 and 1 (creating dummy variables)
I have a ms-access 2003 table with exp and imp columns. In these exp and imp columns I have 75 countries. I want to create dummy variables exp1-exp75, imp1-imp75, in the same table, showing which coun[详细]
2023-02-04 23:55 分类:问答Fire update event on keyup
I have textbox (\"D_find\" in its id) on my form witch i use to filter form\'s data using LIKE query.[详细]
2023-02-04 22:18 分类:问答Counting images in an MS-ACCESS 2003 column
Warning - Newbie ahead I have a table with one column that has an OLE/object format with images in it.[详细]
2023-02-04 14:24 分类:问答Access Input textbox on Data Access page with only select enabled to allow filter by searchs
I have a data access page which gets all it\'s data from a query of another table, problem is all the textboxs I make开发者_Python百科 on the page and bind the Control source to the matching column th[详细]
2023-02-04 00:42 分类:问答condition based on availability of data
I have a table with (EX)ij values for different countries, i,and different sectors,j. So the table includes three fields; country, sector and Export value. Two other tables include Qij and Aij values[详细]
2023-02-03 07:10 分类:问答Free tool to sync data from ms access to sqlite
is there any tool that can compare data from ms-access database table with sqlite table and update it if finds it updated and in开发者_StackOverflowsert if not found?[详细]
2023-02-02 19:30 分类:问答leaving values as they are
I have a short question: I need a command to make some values stay the same in an update query with iff statement.[详细]
2023-02-02 17:30 分类:问答How can I find all the MS Access security groups in VBA
How can I find a list of all the MS Access security groups in my application through VBA? I know I can do it by going to Tools->Security->User and Group accounts, but I\'d like to do it through VBA ([详细]
2023-01-29 02:39 分类:问答SQL Server 2008 Server-Side "Invalid userid" (Error 18456, Severity: 14, State: 5)
Errors Database administrators report Microsoft SQL Server 2008 server-side error \"Invalid Login\" (error 18456, Severity: 14, State: 5).[详细]
2023-01-28 23:53 分类:问答