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...

Hey Andy, to be honest the only reason I created the "Rating" field was because I was having difficulty creating a query to filter the Null values in "MR Control Effectiveness Rating". The "Rating" field replaced the Null with None. I would prefer to not create the "Rating" field and instead...

Thank you for the response guys. Andy, I have four separate radio/option button controls not checkboxes. And I may be wrong, but I don't think the control I use would make much of a difference. I would still need to figure out the logic to account for all the user options. Hey Skip, thanks...

Hello, I have four radio buttons on a form that allows a user to select any combination of the 4. I have an unbound field "MREALL" that is holding the values of the four radio buttons. I am then trying to filter a query depending on the combination of radio buttons selected by the user. I am...

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

Hello All, I have a report which is based on a query.The query runs fine on its own. I have a form which builds a filter for the report. When I attempt to apply the filter to the report I get the message "The specified field '[REVIEW_TABLE]![REVIEW_ID]' could refer to more than one table...

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...