ms-access
Block if without end if - VBA Error
This is a small snippet of the code I am writing. It seems to throw an "BLOCK IF WITHOUT END IF" error on the last line. I can\'t spot an error here, after consulted with this MSDN link[详细]
2023-04-12 05:12 分类:问答Read and write from and to single Ms Access database from many applications simultaneously
I\'ve tested this and I can see is possible to have multiple opened OleDbConnections from multiple applications (or same many instances of the same application) to the same Access database, and even h[详细]
2023-04-12 03:12 分类:问答VBA functions not working, returns error
I have a problem that I have been trying to solve for a couple of days with MS Access and a VBA function.[详细]
2023-04-12 01:01 分类:问答Migrating from Access 2000/2003 to Access 2010
I want to use access 2000 and 2003 databases in access开发者_开发问答 2010. Since I don\'t want to check if everythings\'s working manually I am looking for a tool that analyzes VBA code for errors or[详细]
2023-04-12 00:15 分类:问答Query by form (ala Microsoft Access) but using jQuery
I have a database based website application, and I would like to allow users to be able to create their own custom queries, using a tool like microsoft access\'s query by form.[详细]
2023-04-11 18:53 分类:问答Searching a table to find a certain ID: error 80040e10 no value for one or more parameters
In Access 2007, I am searching a table to find a certain ID. The ID address is given in a text box by the user IDTxt.[详细]
2023-04-11 18:46 分类:问答Read an mdb (ms access) file without using ODBC
I would like to know if it\'s possible to read a .mdb file without the use of ODBC. I need to write a Delphi application that reads 2 columns from a mdb file a开发者_运维百科nd writes those columns i[详细]
2023-04-11 17:29 分类:问答Ms access query for dont show blank filed
I have a query that has a couple of text fields where in the filter criteria I put <> \"Power\". When I put this criteria in, it also does not show me records where the field is blank. If I leav[详细]
2023-04-11 16:58 分类:问答DateDiff split into months access/vba
How would I create a query/vba function similar 开发者_运维百科to DateDiff that splits the result into days per month (i.e. 1/1/2010 - 2/3/2010 = January: 31, February: 3 (disregarding formatting)).OK[详细]
2023-04-11 15:05 分类:问答How to avoid data redundancy when copying between different DBMS?
I\'m planning to create an VB.net application for retrieving data from a database (MS Access) and store it to a web server (MySQL data base). I really have confusion in my mind. I\'m planning to use t[详细]
2023-04-11 14:54 分类:问答