Search results

Out of interest, has anyone found a solution to the behavior of continuous subform allowing user to keep scrolling even when the last record has been passed, leaving us with a blank screen as the last record moves upward and only stopping when the last record is at the top of the detail section...

Note: The FAQ has been updated & expanded. As always, any feedback or corrections, however minor or major, are always welcome.

Here is a tool that can help in avoiding situations where you delivered your database and two months later the client is complaining that it takes FOREVER to get anything done. Is Access really that bad, or is it your code? This is a sample database developed by Patrick Crews and Giuseppe...

Note: You have option of downloading the PDF attachment or reading the FAQ here. This is an attempt to equip the developers who want to use Access as a front-end client to any RDBMS (Relational DataBase Management System) backend (ie, SQL Server, DB/2, Oracle, MySQL, PostgreSQL) with the right...

Sometime I want to get a list of fields of a recordset or table or maybe iterate over the collection in middle of development and I really don't want to go over to table, open it, or run a query or even write a temporary sub just to house the code. Thus I came to do this out of habit using...

I am sure I'm missing something blindingly obvious but here it is: I'm trying to create a recordset in a denormalized fashion for reporting. Part of the requirement is to update a temporary staging table with column containing aggregate results. The general SQL is something like this: CREATE...

I'm trying to figure out what is the best method of communicating a error back to an ADO provider. My initial reaction was to use RAISEERROR, but it is my understanding that ADO doesn't make it easy to retrieve the specific error message raised by the SQL Server. I also considered using a...

For those who are unaware of what 'compiler directive' is, there are two special statements that can be used in Visual Basic for Application to control what block of codes actually get compiled or skipped over. The #Const statement declares a variable that the compiler will use in determining...

I think I'm missing something. I already have a full backup. What I want to do is to create a differential backup, but save it in a separate file, rather than adding it to the existing file. When I tried to make a new file and do a differential backup, the new file was twice as big as the...

Note: This is posted at UtterAccess as well. This topic is nothing new, probably has been rehashed countless times with several people making assertion one way or other. For me, I decided to put several assumptions to test. They can range from "you should use query, not linked table as...

I think this is a case of me not knowing the correct name or keyword to search. I'm looking for a way to get a log that reads all statements sent to SQL Server, primarily for debugging information. Transaction logs, which keep cropping up in my search, isn't correct because it only stores...

I just discovered that Jet derive from standard SQL. In standard SQL, it makes no sense to specify columns in DELETE query because an entire row get deleted as per the definition of delete query and if only partial deletion of columns' data was desired, a UPDATE query is actually appropriate...

Disclaimer: If you are new to database modeling or looking for a way to make Access act like Excel, this demo may not be for you. This demo represents a special case of data entry and is in no way a substitution for proper normalization, single form presentation among other things and in all...

I can't seem to make up my mind on how to manage such cases. Usually, it's option groups or comboboxes where entry is required, or perhaps some kind of logic where the choices are always definite and cannot be left blank/skipped/ignored. In case of an option group, for example, if I somehow...

I'm curious whether anyone else has found a use for D-functions (e.g., DLookup(), DCount(), DMax) where it was easier or better than different approach and in what cases? Since using Access three years ago, my encounters with D-functions were brief and I quickly eschewed them because of...

I am trying to find out if it's feasible to use temporary and local objects (in this specific case, a temporary local table) with Access being involved as front-end clients. I'm trying to do some data processing on server side, with Access feeding the inputs, which ultimately will return a...

Running SQL Server 2005 Developer edition, I'm trying to do a backup of selected tables using Bulk Copy Program, but keep getting an error: SQLState = 08001, NativeError = 67 Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [67]. SQLState =...

As you may know, we can do a bitwise comparison for criteria or flags. This works well if all criteria are required; so if we required 'a, b and d', we can ask thus: If (MyCriteria And a) And _ (MyCriteria And b) And _ (MyCriteria and d) Then '.... Criteria passed Else '...

I'm having an issue forming a stored procedure for SQL Server where I want to use IN() function. The statement would be something like: SELECT a, b FROM foo WHERE a IN ('bar', 'baz'); Hardcoding works, but if I write a SP using a variable: SELECT a, b FROM foo WHERE a IN (@var) and call the...

I am reasonably sure that VBA and JET is single-threaded and thus not thread safe, and the kb article suggests that DAO library can be thread-safe but with caveats. However, I'm not as sure about Access itself. After all, it's a main program and presumably events can be interrupted (but by...