Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. btrini10

    Limit to how many records can be appended to Linked SharePoint list at one time

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

    Lock violation even though all forms have been closed and I am chaning the value to be updated.

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

    Using the Set command with a counter variable

    Thank you Andy! It worked.
  4. btrini10

    Using the Set command with a counter variable

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

    Query using "IN"

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

    Query using "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...
  7. btrini10

    Query using "IN"

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

    Query using "IN"

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

    Query runs fine but I get an error applying a report filter

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

    Query runs fine but I get an error applying a report filter

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

    Open form in relation to other form on screen

    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?
  12. btrini10

    Open form in relation to other form on screen

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

    Open form in relation to other form on screen

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

    Substitute Me! for Forms![Main_form]

    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] = " &...
  15. btrini10

    DSUM on Query or report - Which would be faster

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

    DSUM on Query or report - Which would be faster

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

    DSUM on Query or report - Which would be faster

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

    DSUM on Query or report - Which would be faster

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

    DSUM on Query or report - Which would be faster

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

Part and Inventory Search

Back
Top