Hi folks,
I've got this strange problem with Access 2000. I have an unbound ComboBox control that will be accepting an 8 character string. The row source is a query containing an 8 character text field. This field is really a series of numbers, some starting with zero (ie 01123400). This...
I have a program that must process a large number of records in a transaction block. I was getting error 3052 "File Sharing Lock Count Exceeded." According to an article from Microsoft's Knowledge Base (and another in this forum), the recommendation is to increase the default setting...
I need to increment a field within a transaction block. I call a function like the following within the transaction (there is more to the function, but this is the relevant portion).
Public Function UpdateGL() As Boolean
Dim rsGL As Recordset
Dim NewGLID As Integer
Dim db as Database...
I have a query in Access that is using a linked Excel table. I want to return only those records where the phone number is null. When I enter "Is Not Null" into the criteria for the phone number field, the result set still returns "blank" phone numbers. Excel is storing...
I have an access program that links to Pervasive SQL 7 tables via ODBC. On one PC the performance is adequate. On another, the performance is much too slow. The only difference between the two PCs (as far as I can tell) is that the "slow" pc had Windows 98 and the "fast"...
I have a label on a form that provides various messages to the user. The label is initially hidden. I want this label to become visible after a button is clicked and the code begins to run. The only way I can get the label to become visible is if I interrupt the code with a message box. I'v...
|-I I really need an answer on this. Please Help!
I have an application that keeps one popup form open at all times, but minimized. When Access 2000 itself is minimized and then restored, the minimized popup form always maximizes and appears on top, even if it was not the form last viewed...
I have an application that keeps one popup form open at all times, but minimized. When Access 2000 itself is minimized and then restored, the minimized popup form always maximizes and appears on top, even if it was not the form last viewed. This can be confusing to the user, who expects to go...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.