- form1 has has queries which are run everytime a WO button is clicked.
- There is more data for Closed WO than that for Open or Overdue WO.
- form2 dispays detail
26 results in 0.0046 seconds.
-
MS ACCESS form taking too long to navigate.
I have form1 which has 3 types of something called as WO.Now, when I click on a 'closed WO' form2 opens displaying details.And when I click the back button, it takes atleast 2 minutes to go back to form1.However, this is not the case with Overdue and Open WO and the perfomance is good. -
cascade combobox problem.
I have two comboboxes on a subform.The first combobox is used to populate the second combobox.These are placed in the detail section of the form.I want them to work this way:when I select any value from the first combobox,I want the second combobox of the same row to get populated by relevant value.
As of now, I have tried to implement this and as I select any value from the first combobox of row 1 I see the second combobox of the same row... -
ODBC call failed in ms access 2007.
Run-time error ‘3146’:
ODBC—call failed.
[Microsoft][ODBC SQL SERVER Driver][SQL Server]The ORDER BY position number 0 is out of range of the number of items in the select list.(#108)
The text above is the error that I am getting when I try to sort a column in my form.I am not able to understand what this error is supposed to mean.
Here is the code that I am using to sort the column,in case required.... -
What's wrong with this query?
This query works in the query design window but doesn't display any data in the combobox in the form.
...Code:select distinct '<ALL>' as equipment from tblmimain UNION ALL SELECT DISTINct tblMIMAIN.A_EQUIPDESCR AS Equipment FROM tblMIMAIN WHERE (((tblMIMAIN.A_LOCATION)>IIf (GetAsset()="**ALL**","a","ZZ") Or (tblMIMAIN.A_LOCATION) =GetAsset()) AND ((tblMIMAIN.A_SYSTEM)="NEN"))
-
How to clear filter to display all data in ms access 2007?
I have a combobox that filters data on the form in the afterupdate event.
Following is the query I have been trying to use to filter data.This code filters data effectively but the problem that I am facing is that when I select "<ALL>" from the combobox no data is displayed.What could be wrong?How can I display all the data of the form on selection of "<ALL>"
...Code:Dim strCriteria As String strCriteria
-
Adding 'ALL' in rowsource of combobox.
I have acombobox used to filter data on selection of any value.I want to add a value 'ALL' in my combobox for users to select all the values i.e. remove filtering.union all is not working somehow.Here's the query:
...Code:[*]SELECT DISTINCTROW tblMIMAIN.A_JOBNO AS Jobno, tblMIMAIN.A_EQUIPDESCR AS Equipment, tblMIMAIN.A_LOCATION AS Location, tblMIMAIN.A_ID, IIf(IsNull(tblMIMAIN!A_PROJECTID)," ","**13Mplan**") AS 13Months
-
How to sort date column in ms access?
I need to sort a field that displays date on a form.This field is a textbox that simply displays a column 'date' from sql database i.e. it is not of type datetime when displayed.I had two ideas in mind; either I can convert the format to yyyy/mm/dd which helps sorting text or I should convert text into date format and then sort it.The problem in the first one is that even if I convert to yyyy/mm/dd I need to display as mm/dd/yyyy and the problem... -
How to filter form when value selected from combobox is null?
I have a combobox which has null as a valid value.I want the form to get filtered when user selects null as a value also.However no filtering happens when the value is null.All I would like to know is whether it is possible to filter if the record selected is null as the filter criteria will be empty string then?I am not posting any code as my question is just that can criteria be null and still filter? -
Multiple criteria in where clause to open a form?
Is the following statement correct/
I am trying to give two conditions to open a form here.However nothing happens.Code:DoCmd.OpenForm Me.Name, , , "[A_PRIORITY] = '" & _ cboPrior & "'" AND "[A_LOCATION] = '" & _ cboLocate & "'"
-
"Recordset is not updateable" for combobox in Ms Access 2007.
I have a combobox that has the following as its rowsorure:
The problem is that the combobox drops down but when I try to select any record, the status bar text is: "Recordset is not updateable"Code:SELECT qryMIMATRIX.A_JOBNO FROM qryMIMATRIX;
qryMIMATRIX:
...Code:TRANSFORM First(qryMIMATRIXSELECT!A_PLANDATE) AS [FirstOfvolgende inspectie] SELECT qryMIMATRIXSELECT.A_ID, qryMIMATRIXSELECT.A_PLANDATE, qryMIMATRIXSELECT.A_LOCATION,
-
HiGu started a topic How to filter a form based on user input when the input can occur in any format?in AccessHow to filter a form based on user input when the input can occur in any format?
I have a form which displays a column named A_JobNo(e.g. value: "E1Y4000") from a table in a textbox.There is an input mask applied to this texbox:
>L\-0A\-0000
which makes the value appear like "E-1Y-4000" on the form.
Now, I need a textbox/combobox for users to enter a value in it so that the form is filtered based on that value.
What I am not able to understand is how do I apply filter as the... -
HiGu started a topic How can I make intellisense appear as user types in a textbox in ms access 2007?in AccessHow can I make intellisense appear as user types in a textbox in ms access 2007?
Is it possible for a textbox to predict phrase as user types in?I know comboboxes can make it happen but what if I want a text box to do the same and predict string? -
Problem Opening Query in VBA
I need to filter a form using the selection made by user from a dropdown.I have used the following code which throws an error: invalid argument
...Code:Private Sub cboLocate_AfterUpdate() Dim rst As DAO.Recordset, db As Database Dim strCriteria, SQL As String strCriteria = "[A_LOCATION]=" & cboLocate Set rst = Me.RecordsetClone 'rst.FindFirst (strCriteria = "[A_LOCATE]=" & cboLocate)
-
How to populate foreign key field in MS Access 2007 after import of data?
I have a question on Access 2007,
I will give you an example..
Table A has the folowing fields:
ProcessID - PK
High level process names
Process owner name
------
-----
etc
Table B fields
DetProcessID - PK
ProcessID - FK
Detail process names-
Activitiy
-----------
----------etc
I have uploaded... -
HiGu started a topic How to set controlsource of a textbox on a subform from the code in its parent form?in AccessHow to set controlsource of a textbox on a subform from the code in its parent form?
On a subform I have a textbox of which I would need to change control source property on click of a label on the parent form.I do not know how to do this as my trials resulted in errors.I have tried the following with no result:
...Code:1. Form_frmWOMAINMENU.[frmWOMAINSUBMENU].Form.[txtDate].Control.ControlSource = "Raised" 2. Forms("frmWOMAINMENU").[frmWOMAINSUBMENU].Form.[txtDate].ControlSource = "Raised"
