Search results for query: *

Hi, The checkboxes in the subform are under a column called "delete", and after users select which record they want to delete from the record table (there are two columns in the record table, one is called Delete, and the other is called Approved. Both columns are needed for other reasons.)...

Hi, I am sure that it's a simple question to all the experts on this site. I have a subform that is a continuous form which returns records from a SQL stored precedure. Each returned record has an associated checkbox,txtCurRec, in the subform. The checkbox's control source is set to be...

Hi, I have a stored procedure that runs after Access form passes the global variables to SQL. New records will be inserted into a SQL table at the end of the stored procedure and the primary key for the table is an auto-id. I would like to pass the auto-id inserted into this SQL table back to...

Hi, I am not sure that this can be done in Access Project... I have a search form created in Access, and when users click on a command button, the event will launch the SQL stored procedure to search for results based on the search criteria. Search results will be returned to a different...

Oh my goodness. It's finally fixed... I modified the line of code to Forms!frmAuditList.subfPreviewNewList.Form.RecordSource = strList and the system was able to find the second form and the subform and return the records, strList, to the subform. Thank youuuuuuu all for brainstorming with...

I will give it a try! Thank you:)

Hi IGPCS, Thank you for clarifying it for me. I have a silly question: the stored procedure returns multiple values (for example, report number, employee name, record date and etc.), and there are also multiple fields in the subform (for example, report number, employee name, record date and...

Hi, I am not sure if it can be done. I have a form which shows several records. Users get to check the checkbox associated to each record if they want to delete the record. After users click on a command button on the form, the on click event is supposed to pass the ID number of any (can be...

Hi IGPCS, I added a line of code, MsgBox strList to show the value of strList, and the message box shows Exec s_ViewAuditList 2 (Note: 2 is based on the report number I selected on the first form) So, it seems that strList is grabbing and passing the parameter correctly to the stored...

Hi Randall, Could you post the exact code you tried that worked since there are different suggestions to my question and I am a little bit confused now...? Thank you very much!

Hi IGPCS, Thank you for the suggestion! I replaced my Me!subfPreviewNewList.Form.RecordSource code with your suggestion but it did not work. The stored procedure returns values for multiple fields, and that's why I wrote the vba code to pass records to the subform instead of value to a...

Hi Randall, Thank you for your idea:) I guess I need to fix the data source in the properties of the subform. Can you make some suggestion? What should I enter in RecordSource in the subform's Properties in order to show the results from the executed stored procedure? Thanks a bunch!

I run these code in a private sub on click of a command button in the first form.

Hi IGPCS, Thank you for the idea! I thought about that before but I got stuck when I tried to pass the result from the stored procedure executed in the first form, frmMain, to the subform in the second form, frmList. Part of my current code in the first form: Dim strList AS String strList =...

Hi all, Thank you for all your help! DMaxt worked out perfectly! Thank you, PHV, and of course, other ideas! Happy holiday:D

Hi, I have two forms in the Access Project file. When I click on the command button on the frmMain, a value should be loaded into the other form, frmList. However, my code does not seem to retrieve and load the value into frmList properly. Any advice will be greatly appreciated! Here is...

Hi, I have a form which has two controls, txtViewReportNum and txtViewDescription, and a subform which shows results from a SQL stored procedure named s_ViewList. The problem with my vba code is that the string which execute and return values from the stored procedure always seems to execute...

Hi, Does QueryDefs work in both Access 2000 and 2003? Also, I have not declared database and recordset set since the application is created in Access Project, and has been connected to specific database. Do I still need to declare the database and recordset? Thank you very much!

Hi, I am trying to run a SQL stored procedure with the output in an Access (.adp file) form. Here is my vba code which does not work when it tries to execute the stored procedure... Any advise will be greatly appreciated! Private Sub cmdCreateAuditList_Click() Dim strRecordSource As String...

Hi guys, Sorry for bugging you on the same issue again. I tried ESquared's suggestion and updated my Insert trigger to: CREATE TRIGGER [tr_InsertTimeOff] ON [dbo].[TimeOff] FOR INSERT, UPDATE AS DECLARE @EmpName AS varchar(50) DECLARE @Manager AS varchar(50) DECLARE @RequestID AS int...