Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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