Can't seem to duplicate your error message - I got a different one "The expression is too complex to be evaluated.... blah blah blah", but you are right this is a little strange as you can indeed specify as criteria a vB function and Left(string,len ) is a legitimate function. I have never tried to use the function in the way you seem to be though.
It looks to me like [employee]![dob] is a reference to a field in a table...
zzqxxq
Last Activity: Oct 21 '06, 03:01 AM
Joined: Jul 13 '06
Location: Chelsea, MA
-
MS Knowledge Base Article KB207642 describes how you can control when the scrollbars display - the code below counts the number of rows that will be displayed before displaying the scrollbars.
Private Sub Form_Current()
' If the number of records in the subform
' is greater than 4, display the
' horizontal and vertical scrollbars.
If Me.RecordsetClo ne.RecordCount > 4 Then
...Leave a comment:
-
MS Knowledge Base Article KB101084 does not EXACTLY deal with your issue but does shed some light as to where you might look to troubleshoot.
It states: "For Microsoft SQL Server, Sybase SQL Server, and ORACLE Server databases, your SQL database administrator can choose to disable this feature, requiring all users to enter their login IDs and passwords each time they connect to a SQL database."
The "feature"...Leave a comment:
-
Don't know if this will help however, I got similar error when I forgot to reference the Microsoft DAO 3.6 Object Library in the second dB. This Obj Lib is not referenced by default.
MS only mentions this error in regards to dB conversion from 2003 or 2000 to Access 97 but I have gotten "random" errors when I did not explicitly reference the DAO 3.6 Library. (By random errors I mean an error occurred but the error message...Leave a comment:
-
I would really like to help you out but I am unclear as to what you are actually trying to do and HOW the data is stored. Do you have separate tables for the countries, the publications and the statistics? Are the statistics the same kind of statistics for each country? What is the user really looking for by selecting countries and statistics are you looking for the common publications? Maybe you can see where I am going with this - write back...Leave a comment:
-
An update query should do this
1. create a select query that displays the table
2. with the query grid displayed -change the query type to Update Query (on the toolbar)
3. A new row called Update To: appears
4. Find the column (field) that contains the information you want to change
5. In the Update To: box for that field try the following
"EC" & Right([FieldNameWhereR oomNumberIsCurr ently],4)...Leave a comment:
-
http://www.accesstogo.org.uk/index.html
This site has dB's you can buy but it also has some free ones too...Leave a comment:
-
There is the ever popular Val(stringexpre ssion) function.Leave a comment:
-
Here is what Microsoft says about the error:
SYMPTOMS
When opening and closing connections or recordsets using the Microsoft ODBC Driver for Access or the Microsoft OLE DB Provider for Jet, the following error may be reported:
Object invalid or no longer set.
After this error is reported, no more recordsets or connections can be opened from the same process.
Other possible error messages reported...Leave a comment:
-
Here's how I would handle it
I would make a new query based only on the department combo box - then when a user selects a department all the employees in that department would fill the listbox - just like you want to do
then use the original query with the section box so that if a user selected a section AFTER selecting department he would get the list box of just that sections' employees - like you get now.
...Leave a comment:
-
Vb does this much easier
Dim mystring as String
mystring = "these are some words " & "+ " & "? " & "these are some other words"
tsubject = TRIM(mystring)
the result is "these are some words + ? these are some other words"Leave a comment:
-
You just have the syntax slightly wrong:
Should be: Len(Me![txtProductCode]) You have: Len(Me.txtProdu ctCode)
Should be: IsNull(Me![txtProductCode]) You have: IsNull(Me.txtPr oductCode)
You've got the parenthesis right bit the Me is followed by a ! not a period and the actual field name must be in square brackets - it should work then
If IsNull(Me![txtProductCode]) Then
' do whatever...Leave a comment:
-
Here are a couple of suggestions for you. First I would try to compact and repair the database. You sometimes get small glitches and hiccups when you havent done that in a while.....or at all..... you really need to compact and repair on a regular basis - this is located under Tools / Database Utilities.
If that does not solve the problem, open the form from the Database window - not through the switchboard - now try clicking on...Leave a comment:
-
Ok let me try - if you can open the form in design mode you can accomplish what you want to do. First get the form on the screen, then look for View on the menu bar, click View and then when the menu drops down select design view. Next, look for Edit on the menu bar and click that. When that menu drops down look for "Select Form" and click that (you may have to wait for ALL the options to display - just be patient they will after a few...Leave a comment:
-
As I was reading this in the US, the thought struck me as to how you denoted the dates you gave as examples you typed 01/01/06 to 31/01/06 - not US format, which would be 01/01/06 to 01/31/06 - check your windows regional setting to make sure they match what you are entering. If windows itself is set for US format mm/dd/yy and you enter dd/mm/yy that might be the problem. Either enter dates in US format or change the windows regional settings....Leave a comment:
-
Unfortunately, AUTOnumbers are just that automatically created numbers - ideally these numbers were never intended to be used for any purpose other than to provide a unique identifier for a particular record so there is no simple mechanism to alter their format. If you need a particular format you therefore must create it and put it into a field that is not defined as an autonumber field but as a text field (your codes are alphanumeric).
...Leave a comment:
-
If I am understanding you right, you have a product table and an attributes table - and each product can have many attributes. You could have a product called peach and its attributes would be sweet, fuzzy skin, grows on a tree. Then you could have a product called grape with attributes sweet, smooth skin, grows on a vine. As you see each SET of attributeS describes ONE product. this is a ONE (product) to many (attributes) relationship. You...Leave a comment:
-
I suggest that you check out the enabled and locked properties of the field you need to control. These properties can be tested and altered in VB for example
If txtMyHoldField > 0 then txtMyHoldField. Enabled = False
Else
txtMyHoldField. Enabled = True.
Endif
Making enabled = false "greys out" the field and prevents anyone from tabbing or clicking into the field or changing the value...Leave a comment:
-
The problem I see right away is that the "house part number" and the "alternate part numbers" could be a many to many relationship - that is that any house part number can have more than one alternate part number and vice versa.
Think about it for a second. What if 123 was the alternate part number for a Delco spark plug AND it was also the Ford part number for a tailpipe for a 1963 Edsel, if you type in 123...Leave a comment:
-
Check out the MousePointer property in VB also some ActiveX and other controls have property settings that allow you to control the pointer display when the mouse is over the controlLeave a comment:
No activity results to display
Leave a comment: