Search results

if both "Not In" and "<>" is not working for you, try this strSQL = "SELECT tblQ.[Q No] " strSQL = strSQL + "FROM tblQ INNER JOIN tblAQ ON tblQ.[Q No] = tblAQ.[Q No] " strSQL = strSQL + "WHERE tblAQ.ID = " & Me.cboP & " AND tblQ.[Q No] NOT IN " strSQL = strSQL + "(SELECT tblAQ.* FROM tblAQ...

I don't believe "Not In" will work here It can be something like this strSQL = strSQL + "WHERE (((tblQ.[Q No]) <> ([tblAQ].[Q No])) If you want to use a subquery, "WHERE Not In (Select col1, col2,,, from table where id = id) Check or refer to the correct syntax at Allen Browne's site. And...

My guess would be the missing "&" at 2) txtScore.Value = DLookup("[Score]", "tblAQ", "ID = '" & Forms![frmQ]!cboP & "'" & " And [Q No] = '" & Forms![frmQ]!txtQ & "'")

The Len() function will cause an error if the textbox is Null. You'll have to remove the Null condition with this.... If Len(Me.CompanyName & "") Then Note: There is no space between the double quotes.

This the Perform Name AutoCorrect feature in Access. You had renamed the controls, but in the process you left two spaces when you save the form. There are two underscores actually, not one as in missinglinq post. For example, if you name your control as “First Name” with a space, Access will...

If the back-end server is Oracle/SQL Server/MySQL then use Access ODBC connection to link the tables. As far as I see it, Cognos is a front end application.

In the table or the form? (I mean, formating the control or field in the table.) In the control properties, set the Format to "Fixed" and "Decimal Places" to 0. In the Table of the Column/field, select the column/field you want to edit and in the "General Tab" set the "Format" to Fixed and...

Is this correct? Can you confirm this? str_Filter = "[Case Number] = & Case" It should be...look at the qoutes str_Filter = "[Case Number] = " & Case If [Case Number] is integer/Long. and DoCmd.OpenReport "unrelated SCT1", acViewNormal, str_Filter is "unrelated SCT1" correct? Should it be...

If Me.Dirty Then 'Save any edits. Me.Dirty = False End If The above code saves the current input record on the form. If the current record is not save, you will not be able filter to this record as it is not in the table. If Me.NewRecord Then 'Check there is a record to print...

Hi, If you use named queries, then = "YourQueryName". Another is on the form just below the option declaration.. Option Compare Database Option Explicit Dim YourSQLString As String ' or just put this into the open event Somewhere in your open event of your form... YourSQLString =...

Hi, It's a search form, but you'll get the idea. You might want to start something like... Select ...From Table Where...Order By Forms!YourFormName!SearchCombo In the combo Row Source Type to "Value List" and in Row Source key in "Column1;Column2..." where column1 is the field of the...

Hi, You didn't say much about why on changing the recordsource. It appears that you are only sorting the ascending or descending order. You should use a combo box to sort the order instead. Here's one form Allen Browne. Sort by combo

Your code works on my end. Maybe you need to check the "DatabaseDir". Is it pointed to the correct path?

Remove the colon from the following.... Then tell us what is the error.

Hi Molly, I have resolved this form "frmAuthorEntry" for the onload event Private Sub Form_Load() 'Dim Args As Variant Dim Args() As String If Not IsNull(Me.OpenArgs) Then Args() = Split(Me.OpenArgs, ",") Me.AuthorLastName = Args(0) Me.AuthorFirstName = Args(1)...

Molly, It appears that the line to requery your combo is missing in your code. DoCmd.OpenForm "frmAuthorEntry", , , , acFormAdd, acDialog, NewData Response = acDataErrAdded me.cboAuthor.requery ' add line here Else MsgBox "Please choose an author from...

What is your macro doing? Just a guess…. Open up your macro "mcrUpdatePolicyByEmpIDAfterNewAdd" and check whether is there any SetWarning in your “Action” field and at the bottom of the “Action Arguments” is it set to “No” and at the end of the field set it to back to “Yes”. If your macro...

It’s not a bug. It’s a security issue. The tendency to forget that the era of Windows 98 is gone is all too common. Security settings in Windows XP and Vista are very different from Windows 98. You cannot install an application if the user is not the administrator. Give the package to someone...

Here's form Help. One thing i can come up with, is that your form property is set to PopUp or Modal. Is any of your form set to it or any code in both the forms is causing error? It might be better that you display the code here so that we help you further.

I was hoping that none of veterans would reply on this and that you’ll give me the input regarding the “>0” on why did you need this. I was wrong on both counts! The purpose was to check whether you understood this. Since the outcome of the DCount is rated “Low” to “Serious”, I’ll try to...