Search results

Greetings, I was wondering if there is a way to open one specific form exclusively. I have a SQL statement that is triggered in the OnOpen event procedure. I only want one person in this particular form at a time, otherwise the SQL statement gums up the form. Is this possible? Thanks in...

Greetings, I have a combo box (ProductType) on a subform that when the user enters a value, it restricts the values on the next combo box (Products). The point being, when a user selects the ProductType (eg: Mirrors), only Products fitting that description will populate the combo box. My...

Greetings, I am creating a help document for a database, and due to the size (heavy graphics, about 15MB), I would like to create it in a seperate, empty database. My idea is to have a button on the current db, which when clicked, opens the help db (opening on a "main" help form...no tables)...

What I would like to do is after I select a value in combo box A, I would like that to trigger a default value in combo box B while still allowing combo box B to have all its values. That's the short of it...here are the details... When a user selects a crew chief for a job, I need that chief's...

Greetings, My question is how do I get Is Not Null as the criteria in a query, but not as a string? The criteria on one of my query fields is based on a field on a form. The user has three choices North, South and Is Not Null. The problem is the "Is Not Null" goes to the query as a string...

I have been unable to delete a record from a recordset (from a form) using the below code... Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenDynamic rst.LockType = adLockOptimistic Dim Test As String Dim strSQL As String Test = Me.MWTicketNo...