Search results

  1. pbuethe

    Solved Data Type Mismatch in Criteria Expression

    My source table is tbl011_Level1_8. CaseNbr, ReviewLevel, ReviewerID, ReviewDate are all of type Text. Column is type Number. There is no primary key. My destination table is tblRevResults. CaseNbr, ReviewLevel, and Reviewer are of type Text. ReviewDate is of type Date/Time. These four fields...
  2. pbuethe

    Report shows only one value of group

    I have a report which was working fine with one grouping level, on the field Specialty, with CaseNbr listed in the detail. I am now trying to add another grouping level above this, on the field SampleNbr. The problem is that the report now shows only the specialty "Cardiology". How can I get...
  3. pbuethe

    ODBC call failed message with pass through query

    In the following code I am getting the error “ODBC – call failed” error 3146, on the line Set rstCaseInfoFiltered = qdfCurr.OpenRecordset Function basPreFill(strSample As String, strFacility As String, strCaseID As String) Dim strWSFormName As String, strRationaleName As String, strSQL As...
  4. pbuethe

    runtime error 2465

    I have: Main form – frmDenialTracking Combobox on main form – cboProvider Subform – sfrmDenialTracking (this is the name of the subform AND the subform control) The combobox selection provides criteria to a query which I am changing the recordsource of the subform to. When I select from...
  5. pbuethe

    cannot add record; primary key not in recordset

    This error message “cannot add record; primary key for table 'tlkpReview' not in recordset” appears on selecting from combobox cboDecision when entering a new record. This has been working with the table in Access (in the previous version of this database), but the error started appearing when...
  6. pbuethe

    type conversion failure on time fields

    I have the following scenario: data is entered into a fillable pdf. This is then read into an Access table where all fields are Text. Some of the fields represent time values. I need to append the data from this table to another table where the time values are Date/Time type. When I run the...
  7. pbuethe

    Data type mismatch in criteria expression

    I am getting a data type mismatch error on the following code, on the line in bold: Private Sub cmdMarkEntered_Click() Dim db As DAO.Database Dim rst As Recordset Dim qdf As QueryDef Set db = CurrentDb Set qdf = db.QueryDefs("qryfrmRefTrackingEntryNeeded") For Each prm In qdf.Parameters...
  8. pbuethe

    Help with filter

    I have a lookup table with a compound primary key: CaseNbr and ReviewLevel. An example of the data in these fields is: CaseNbr ReviewLevel 1 PRA 1 MRA1 2 PRA 3 PRA 3 PC1 3 PC2 4 PRA 4 PC1 4...
  9. pbuethe

    object variable or With block variable not set error

    Hello, I have the following code to pre-fill some fields on a PDF form. Function basPreFill(strSample, strFacility, strCaseID As String) Dim strWSFormName, strSql As String Dim AcroApp As Acrobat.CAcroApp Dim theWSForm As Acrobat.CAcroPDDoc Dim rstCaseInfo As Recordset Dim jso As Object...
  10. pbuethe

    want to display specific related record

    I have: tblCase which has Primary Key CaseID. tblReview which has Primary Key as CaseID + PCLevel. There may be 1 or 2 records in tblReview per CaseID. frmCase which is based on tblCase. frmReview which is based on a query which contains fields from tblCase and tblReview. frmTDReason, a pop...
  11. pbuethe

    Need each date in date range on separate page

    I have 1.a table where one of the fields is RequestDate. 2.a form in which a date range (FromDate and ToDate) is entered. 3.a query which will select all records with RequestDate in this date range. 4.a report which prints the results of this query. How do I get the report to print the...
  12. pbuethe

    Append query does not run from code

    Hello, I am calling 3 append queries from my code. The first and the third queries are working fine. The second query works from design view or the database window but does not work from the code. The query is called exactly the same way as the other two. I compiled the code and did compact...
  13. pbuethe

    query does not work after saving

    I have a query which has worked in the past. Today it ran slow, and when it finally came up with results, it hung and did not display the number of records. I tried changing the query. Before saving, I ran the query and it ran quickly, giving the expected number of records (162). After I saved...
  14. pbuethe

    Code stopped working - delete and append

    Here is my code. This has been running OK for years, now suddenly the delete and append queries do not seem to be running. This code is supposed to: 1.delete all data in table FacilityHits 2.Append new data to table FacilityHits 3.Call Calc_Fac_Total to calculate a facility distribution from...
  15. pbuethe

    Report prompts for parameter in design view

    When I open one report in design view, it keeps prompting me for a parameter so I cannot do anything with it. The prompt keeps reappearing whether I enter the parameter, just click OK, click Cancel, or close the prompt. I cannot get out of it except by closing Access with Task Manager. What...
  16. pbuethe

    subreport correct by itself, incorrect in main report

    I have a main report with numerous subreports. Everything is fine except for one report. The subreport is correct when run by itself. However, when I run the main report, one line on this subreport is incorrect. There is no linkage to the main report to worry about, as the main report has no...
  17. pbuethe

    Forced to save query

    Sometimes when I create a quick query just to check something, then try to close the query, I am prompted for the name to save the query to instead of being asked if I want to save the changes to the query. I cannot close it unless I save it. What causes this and how can I fix it so it will ask...
  18. pbuethe

    page number does not change

    I have a text box in my page footer with control source ="Page " & [Page] This is supposed to give Page 1, Page 2, etc. However every page is coming out as Page 1. Any help is appreciated. Thanks!
  19. pbuethe

    print only pages with top value above threshhold

    I am trying to print a report with a page for each facility, and each page shows the patient with the top total payments at that facility, and a list of that patient's claims. However, the page should not display if the total payments are <$1000. I have a main report which displays the facility...
  20. pbuethe

    two similar forms, one is slow

    I have two forms, each with a subform. The two forms and subforms, the underlying queries and tables, have similar structures. One form runs reasonably fast but the other one is a lot slower. When opened it was taking about 12 seconds for all the fields in the form and subform to populate. There...
Top Bottom