I need to call a DLL function from Access using VBA. The prototype for the DLL function is int __stdcall myFunction(const char* data, int rows, int cols, int sl, int fullsize, double aspect_ratio, double y, void** ppResult); The one I declared in Access: Private Declare Function DllImport_myFunction _ Lib...
I have two tables. Widgets, which has information about each widget (Color, size, etc); each widget has a unique ID, WidgetID. The other table is Tests, and it contains information about multiple tests that were run on each widget. This table, therefore, has multiple rows for each WidgetID. It contains information that we can call (Widg...
The database that I am working on (in MS-Access XP) seems to have become corrupted somehow. It no longer supports any events - clicks, change, update events, nothing seems to work. This is the error that I get: What can I do to make events start working again? I have tried Tools->Database Utilities->Compact and Repair Database..., bu...
I am trying to migrate Access 2003 (running fine) to Access 2007. The code written in VBA creates some issues. Like I have one main form and 2 subform. In main form recordsource set set by a Dynamic query but based on main form data when I am trying to set the Recordset of subform then access 2007 crash & close itself. Could you please ...
If I want to code the following in VBA how do I do it QUERY1: SELECT field1, Min(field4) AS MinField4, Max(field5) AS MaxField5 FROM Table1 GROUP BY field1; SELECT Query1.field1, Table1.field2, Table1.field3, Query1.MinField4, Query1.MaxField5 FROM Query1 INNER JOIN Table1 ON (Query1.field1 = Table1.field1) AND (Query1...
I've been toying around with switching from ms-access files to SQLite files for my simple database needs; for the usual reasons: smaller file size, less overhead, open source, etc. One thing that is preventing me from making the switch is what seems to be a lack of speed in SQLite. For simple SELECT queries, SQLite seems to perform as ...
What's the equivalent of mysql Limit in ms access. TOP is not sufficient since I'm going to use it for pagination. Thanks ...
I have a form where users input information for a test run on a particular date. This creates a table that i then link with another table based on the date and an ID. In this other table (filled by a form created by someone else) all of the times are 7:00 AM. Whoever created the form for that table did what I'm now asking about; since...
I have an Access 2003 application set up with user-level security. Is it possible, after opening and logging into Access, to be able to change users? Ideally, my client would like to be able to click a button (or something) and be prompted for a different user login. I told him I didn't think it was possible without closing and re-ope...
Hello! Creating a mini-database with access, i came across this problem: For the background, i have two tables: Table: Items and Table: Actions ID(PK) Name ID(PK) Name ------------------ ---------------- 1 Thing1 1 Move 2 Thing2 2 Delete 3 ...
I manage an SQL Server 2005 Database and I would like to give read-only access to the necessary tables to a group of 20-30 networked users who are able to use the GUI in MS Access 2007 to write or modify their own queries to the database, with some help. I would like to distribute an Access database with a single form that would create ...
I'm trying to change a password with a DDL statement like: CurrentProject.Connection.Execute "ALTER USER barney PASSWORD "[]!@#$%^ oldpassword" Yes, that's a nasty password, but someone tried something like that. Notice the beginning quote of the password is not part of the sql syntax here. I need something like mysql_real_escape_st...
Why doesn't the average of the score of an employee of each month, when summed, equal the average of the employees score (ever)? Average SELECT Avg(r.score) AS rawScore FROM (ET INNER JOIN Employee AS e ON ET.employeeId = e.id) INNER JOIN (Employee AS a INNER JOIN Review AS r ON a.id = r.employeeId) ON ET.id = r.ETId WHERE (((e.id)=@em...
How do I store numbers in an Access column and then associate some meaningful string to each value? Because I don't want to be seeing raw numbers when I can define the meaning of each value once at for all, and have those meanings displayed in the Datasheet View, like: ID Name Type 1 Jack 1 (Friend) 2 Jill 1 (Frien...
I am trying to find a function in MSAccess that can be used to return the size of data (in bytes). e.g something like SELECT x.id, sizeof(x.custom_data) AS size Specifically for OLE data types but anything more general would be cool. ...
I have a table full of items that each have a unique ItemID. There is another table with information on tests that are done on these items around once a month (some may have multiple tests per month and some may have none some months) and each test entry has a full date mm/dd/yyyy. I would like to display the average of one of the fiel...
All, Trying to implement a recordset approach in VB.NET and (with the wonderful help of this community) have gotten to the point where things almost run. :) Code: Dim strSQL As String Dim rsMaster As New ADODB.Recordset strSQL = "select * " & "from tblDQ " & "order by xid, xcode, xDOS" rsMaster.Open(strSQL, objConn, adOpenForwardOnly,...
I'm using Access 2003 on a duo-core machine with 4GB of RAM, running Windows XP (Service Pack 3) [5.1.2600] Periodically, I get an error msg "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." A check of Task Manager indicates that there is plenty of free memory. Closing other op...
I read/update data from MS Access using C#. My code is: public static void UpdateLastLogin(int userid, DateTime logintime) ///logintime = DateTime.Now { string sql = @"UPDATE [Customers] SET [LastLogin]=?"; OleDbParameter[] prms = new OleDbParameter[] { new OleDbParameter("@LastLogin",logintime) }; using (DAL dal =...
I have a series of "on Change" Enabled/Disabled subroutines in the VBA for a form. When scrolling through the form to view records however, only the main routine runs--the subroutines don't. As a result, questions appear disbaled that have responses displayed. How do I get the subroutines to run when a record is viewed/changed? ...