Is it possible to leave a editable while making all others read only in a form in ACCESS 2007?
There are around 40 controls on my form and making them read only one by one will be inconvenient. I want to have one of these fields(an option group) editable so that when user selects an option the entire form becomes editable
HiGu
Last Activity: Sep 20 '13, 08:14 AM
Joined: Feb 12 '12
Location:
-
How to make fields in a form selectively editable?
-
Add new entries to sql table form MS ACCESS front end.
I have two tables which can be represented by this query (I have made this query the Recordsource of the form):
I want the user to be able to add new entries into these table via a form in access 2007.Code:SELECT tblrcmtask.id, tblrcmtask.rcmtask,tblrcmtaskoptions.id, tblrcmtaskoptions.rcm_id, tblrcmtaskoptions.rcmtaskoptions FROM tblrcmtask INNER JOIN tblrcmtaskoptions ON tblrcmtask.id=tblrcmtaskoptions.rcm_id
Columns tblrcmtask.id... -
@Paulo357: How do I do that? -
How about creating indexes for the columns selected in the query then?Leave a comment:
-
- There's huge amount of data in the production environment for closed WO which could not be executed even in 45mins in sql.
- When form2 opens,form1 is only made invisible and when back button of form2 is pressed,form1 is made visible and form2 is closed.
Leave a comment:
-
Hey its only 'WO' and it's the data.There are 3 types of WO or Work Order as it is called.
I felt this problem could be because there are a lot of rows for closed WO but the problem occurs only when the back button is clicked.Leave a comment:
-
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.- 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
-
Hey.I got the problem. The source has some new data in it which is null and the destination table does not allow any null value.
The issue is now resolved.Leave a comment:
-
I found this warning (not an error) in the package. Can this create a problem in running the job?
Warning 1 Warning loading AfToNotificatio nCommentStore.d tsx: The configuration environment variable was not found. The environment variable was: "ETLFramework.C onnectionManage r.NotificationC ommentStore". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the...Leave a comment:
-
There are other similar errors.Leave a comment:
-
This package performs the following:
1. Synchronises NotificationCom mentStore DB with AF2 for keeping NotificationCom mentStore (a sql server 2005 DataBase) up to date. This Package fetches all the wells and equipments from AF2 (i.e. PI Asset framework) and stores the well data in WellFilter table, equipment data in EquipmentFilter s table. This tables are then used to relate wells belonging to respective Area and fields in order to display...Leave a comment:
-
Let me attach a file that would give you more info....Leave a comment:
-
SSIS job fails intermittently only on production.
OnError,__SEQ Insert ETL Logic Here,{795D68BF-C348-4D7E-87BC-756EC7552FBB},{ D3AF4786-E01E-43CC-B57D-BD3D05491B5D},1 5/05/2012 13:25:13,15/05/2012 13:25:13,-1073450952,0x,S SIS Error Code DTS_E_PRIMEOUTP UTFAILED. The PrimeOutput method on component "SCR_SRC Get Equipment" (1) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the... -
I tried setting Limit to list property to NO but it seems to be not working.Leave a comment:
-
That didn't work. :(Leave a comment:
-
Isn't there any soultion to this?Leave a comment:
-
1.cboRCMTast is bound to RCM_ID and cboRCMTaskOptio ns is bound to RCMOptionID.
2.I have written the code in the form_current event thinking that since the rowsource of cboRCMTask Options has to change on selection of value from cboRCMTask.
3.I am changing the rowsource of cboRCMTaskOptio ns in the afterupdate event of cboRCMTask
This was how I thought,there could be a better way of doing this.Please let me know if I'm...Leave a comment:
-
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.... -
Now, this is terrible of me..The reason for the second query not working was that I had column widths set as 0";1".So if I selected only 1 column nothing would be displayed.Leave a comment:
No activity results to display
Leave a comment: