Search results for query: *

Hello, I am stumped on this issue. 1. I tried to export an Access table to SharePoint. The Table had 27,000 records and 67 fields. The export fails with a MS Access 3981 Bulk update error 2. I then emptied the table and was able to export and link it to SharePoint. I then ran an append query...

Hello, I am running the below code and getting lock violations even though I am closing all forms prior to the update statement. When I grab the code from the Immediate window and run it as a Query I do not get the lock violations. Not understanding the difference. Dim strSQL As String Dim...

Thank you Andy! It worked.

Hi, I am trying to use "Set" to assign a form control but a part of the control name is a counter. I would like to use the second line of code where "cnt" is the counter in order to get the first line. Thanks for any help Set Planned_Datet = Forms!frm_Review_Plan1!Planned_Date1 Set...

Thanks guys for the responses. MajP is correct, I used the radio buttons simply because I preferred the look and the intention was to have them as individual options and not related to each other as in an option group. Still having issues using the "IN" syntax though. Can anyone assist in...

...not work. I hope that makes sense. WHERE (((tbl_CRAS_MRE.[MR Control Effectiveness Rating]) Like IIf([Forms]![frm_Main_Menu]![MREALL]="-1-1-1-1","*"))) OR (((tbl_CRAS_MRE.[MR Control Effectiveness Rating])=IIf([Forms]![frm_Main_Menu]![MREALL]="-1-1-1-1",(tbl_CRAS_MRE.[MR Control...

...Rating]) AS Rating FROM tbl_CRAS_MRE WHERE (((tbl_CRAS_MRE.[MR Control Effectiveness Rating]) Like IIf([Forms]![frm_Main_Menu]![MREALL]="-1-1-1-1","*"))) OR [highlight #FCE94F](((tbl_CRAS_MRE.[MR Control Effectiveness Rating])=IIf([Forms]![frm_Main_Menu]![MREALL]="-1-1-1-1",(tbl_CRAS_MRE.[MR...

...is below. I suspect I need to add an "OR" or use "IN" in the "Then" part of the criteria. Like IIf([Forms]![frm_Main_Menu]![MREALL]="-1-1-1-1","*") Or IIf([Forms]![frm_Main_Menu]![MREALL]="-1-1-1-1","None") Or IIf([Forms]![frm_Main_Menu]![MREALL]="000-1","None") Or...

Thanks Duane, that did the trick.

Hey Duane Below is the code I use to apply the where condition and open my report. DoCmd.OpenReport StDocName, acPreview, WhereCondition:=strFilter How would you recommend I build the filter without a table reference? Thanks

...((REVIEW_TABLE.REVIEW_STATUS)=1 Or (REVIEW_TABLE.REVIEW_STATUS)=2) AND ((tbl_CONTROL_ISSUE.ISSUE_ID)<>22)); ([REVIEW_TABLE]![REVIEW ID] Like '*' OR [REVIEW_TABLE]![REVIEW ID] Is Null ) AND ([CASE_TABLE]![CASE_FILE_ID] Like '*' OR [CASE_TABLE]![CASE_FILE_ID] Is Null) AND...

Hey Aceman, just to be sure I get this. The subform is only loaded when the tab is selected and you are suggesting to load the Recordsource for the specific form only when the tab is selected. Do I unload the recordsource once another tab is selected, or how would that work?

Hey Duane, thanks for your reply. I have a back end database that sits on our server farm and each user has the front end on his/her desktop. I originally had the subforms in tabs on the main form but the main form was taking forever to load on the users' desktops. I removed the tabs and the...

Hello all, I have a main form with buttons that when clicked open various subforms in datasheet view. I would like my subforms to open right below my main form and at the same size. The problem I am having is that I have a multi-user database and users have varying screen resolutions...

Hi all I have two forms with the same subform. On the subform I have a button that when clicked opens another form using the filter below. I owuld like to create the filter so that both main forms can use the same filter. strFilter = "[STATUS_ID] = " &...

Hey Duane, thanks for the response. Below is an example of what the query now looks like. MTH_YR UNIT OPENED CLOSED LOSSES RECOVERIES LITIGATION APR08 1 2 1 1000 500 600 APR08 2 APR08 3 5 2 5000 100 MAY08 1 MAY08...

Thanks for the explanation lameid. OK, I now have a query with the following SQL. SELECT QRY_MTH_YR_UNIT.FULL_DATE, QRY_MTH_YR_UNIT.MONTH_YEAR, QRY_MTH_YR_UNIT.[UNIT ID], QRY_COUNT_OPENED_CASES.CountOfCASE_REAL_ID AS CASES_OPENED, QRY_COUNT_CLOSED_CASES.CountOfCASE_REAL_ID AS CASES_CLOSED...

Thanks for the clarifiaction, Lameid. However I would have a one to one relationship between the Case table and the Currency table, so wouldn't it be nomalized by including all felds in the case table that are solely depndant on the key filed of the Case Table. Wouldn't I create another table...

Thank you so much for all your input here. Duane: 1) The table name is Cases_table. 2) The EOM value will always be the same as the following BOM value and the EOM is calculate based on BOM+Opened-Closed. 3) All currency fields are allocated to the month in which the case is opened. I think...

Duane,lameid, I apologize for being so vague. OK, My PK is [CASE_FILE_ID] which is text and it is made up of the year in which the case is enterd and a counter that numbers each case incrementally. Once the year changes, the counter resets to 001, e.g. 2009-001. I have a...