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!

Register Log in
  • Congratulations derfloh 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. tpoettker

    Use Null in SQL

    I have a stored procedure with the following sql statement: GreaterExpenses = Case When expenses.reserve_amount > (Expenses.paid_total - Expenses.collection_total) Then Expenses.reserve_amount else (Expenses.paid_total - Expenses.Collection_total) End This statement is not working because...
  2. tpoettker

    Formatting cross tab report

    Thank You. I feel like an idiot!! :0
  3. tpoettker

    Formatting cross tab report

    I don't see the group option "print for each month". I can only select ascending or descending. What am I missing? Tina Poettker
  4. tpoettker

    Uncheck item in listbox

    Thank you so much. It looks so easy yet I couldn't get it. Tina
  5. tpoettker

    Uncheck item in listbox

    I have a listbox on a form. The style is set to checkbox. I am able to obtain the items checked, populate my tables but I can't uncheck the boxes when I am ready to begin again. Can someome help? Thanks, Tina Poettker
  6. tpoettker

    Error with recordset code

    I had to remove "set" from all the statements. The "set" caused the error "invalid use of property". After I removed the "set", it ran but with the same error: "Rowset cannot be restarted".
  7. tpoettker

    Error with recordset code

    still errored. Same line of command (ADOrs.movefirst) and same error (rowset position cannot be restarted).
  8. tpoettker

    Error with recordset code

    I received the error "Rowset position cannot be restarted" on the adors.movefirst line of code. Here is the code in it's entirity: Private Sub cmdOK_Click() On Error GoTo Err_Run_Duplicate_Event_Report_Click Dim stDocName As String Dim cnn As New ADODB.Connection Dim cmd1 As New...
  9. tpoettker

    Error with recordset code

    the first error I received (arguments....) errored on Adors.Open cmd1.Execute, cnn, adOpenDynamic, adLockOptimistic The second error was received on Adors.movefirst
  10. tpoettker

    Error with recordset code

    I had original coded it that way. I then receive the error "Rowset position cannot be restarted" when I try to MoveFirst the first record. Here's the code that follows: Set Adors = cmd1.Execute Do Until Adors.EOF = False MsgBox "That event number does not exist in RiskMaster"...
  11. tpoettker

    Error with recordset code

    I made the changes (thank you for pointing that out :) and still received the errors.
  12. tpoettker

    Error with recordset code

    Hi, I am having problems with my code in MS Access. I receive an error that says "arguments are of the wrong type, are out of acceptance range, or are in conflict with one another". Here's the code. It errors on the last line shown here: Dim stDocName As String Dim cnn As New...
  13. tpoettker

    Compile Error

    My co-worker was connected to the network and the database is setup for any user.
  14. tpoettker

    Compile Error

    I have a unusual problem (or it seems to me). I created a database in MS Access. I imported a table, form and report from another database. I have VBA code behind the form. I added the following references: Visual Basic for Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.51...
  15. tpoettker

    Report_Open Problems

    I have a report that uses an inputbox to request an event number. It then calls a stored procedure using the event_number as a parameter and brings back a recordset. I use the data to populate a table and run the report. This works fine. The problem lies when after the table is populated...
  16. tpoettker

    Open Report Problem

    Hi, I am new to Access and have been asked to create a report and, using data from a SQL query and some logic, post the data into the report. I have created the report, connected to SQL server using ADODB connection and executed the stored procedure. This part works fine. It's the next...
  17. tpoettker

    Report Problem

    Here's my full code. Let me know what your think. Private Sub Report_Open(Cancel As Integer) On Error GoTo Err_Run_Duplicate_Event_Report_Click Dim stDocName As String Dim cnn As New ADODB.Connection Dim cmd1 As New ADODB.Command Dim Adors As ADODB.Recordset Dim sqltext As...
  18. tpoettker

    Report Problem

    Hi, I am new to Access and have been asked to create a report and, using data from a SQL query and some logic, post the data into the report. I have created the report, connected to SQL server using ADODB connection and executed the stored procedure. This part works fine. It's the next...
  19. tpoettker

    Puzzling SQL

    this code only gave me patients and not visitors. However, I do finally have the solution. It is: SELECT e.Event_Number, e.DtTm_Rcd_Added, ep.First_Name + ' ' + ep.Last_Name PatientName, ev.First_Name + ' ' + ev.Last_Name Vistor, v.Pi_Type_Code, g.System_Table_Name FROM Event e JOIN...
  20. tpoettker

    Puzzling SQL

    Here are a small version of the tables. These will cover the basics of my SQL Create table event (event_id int, event_number char(25), dttm_rcd_added char(14)) create table person_involved (event_id int, pi_eid int, pi_type_code int) create table entity (entity_id int, entity_table_id...

Part and Inventory Search

Back
Top