Search results

Thanks that put me on the right path. This worked: Forms("Search Results").qrySearchTransmittal_subform.Form.Requery

I have a search button on my main form labeled 'search' it opens a dialoge box that has two unbound text boxes and a 'run search' button. After entering the two criteria and pressing 'run search' vba code runs a DoCmd.OpenForm called 'search Results'. This form is a container for a subform that...

Hi All, Finally found the solution. This is the web site that had it: http://www.accessforums.net/showthread.php?t=33098 As, I mentioned earlier when I clicked on 'Refresh All' from the home menu the combobox worked fine. So, I added this line to the AfterUpdate code textbox that is used to...

I have been googling to find a solution since my post. On the Home Ribbon -> Refresh All works after I add a new row. So, now, I'm need to know what vba command does Refresh All launch so, I can run it from vba. Any ideas?:mad:

What, I mean is that after adding Me.Requery before DoCmd.SearchRecord line when I used the combobox to select a name from it it did not change the row. Basically, it did nothing.:eek:

I did and now the combo search box dosn't work at all. I removed it.

Hi Form Masters, I have a combobox created with the Access wizard that works fine except when, I add a new record to the table. Here is the code: Private Sub CboFind_AfterUpdate() On Error GoTo CboFind_AfterUpdate_Err DoCmd.SearchForRecord , "", acFirst, "[Upload_Number] = " &...

It' not the connection string since the table is part of the database and it's not the SQL because that was tested from SSMS and it works fine. So, it's something else.:banghead:

I will do that once it is working so no issues going forward.

I changed the code but now get an 3146 error - ODBC call failed. Dim qdef As DAO.QueryDef Set qdef = CurrentDb.CreateQueryDef("") qdef.Connect = CurrentDb.TableDefs("[dbo_CPM_Donors]").Connect qdef.SQL = "EXEC dbo.usp_NewCPM_Item ='" & DonorNum '" 'Simple...

I'm just wondering why, I can't just pass the parameter and be done with it. The table that being inserted to is an SQL table that is linked to this database.

Run-time error 424 object required

Here is the code for the entire procedure: Private Sub txtAddDonor_AfterUpdate() Dim DonorNum As String Dim DonorName As String Dim ValidDonorID As Integer Dim StrFix As String Dim LResponse As Integer DonorNum = Nz(Me.txtAddDonor.Value) 'Name of textbox 'This code pads id with leading zero if...

Hi VBA Masters, I have a stored procedure that I want to run from an Access button. The sproc simple gets an id_number as a parameter and adds a row/record to a table. That is it. This is the code that I use but is not working: "EXEC dbo.usp_NewCPM_Item ='" & DonorNum '" 'Simple adds a row...

SQL Masters, When I open my solution and right click on SSIS packages I get a short cut menu 'Add Existing package' I have used this method to bring in packages. What, I need help with is when I have to bring in code that is in the File System. In SSMS -> Object Explorer Details when I right...

I have revised the code once again and tested it with a MsgBox(). It give the correct record count but leaves me still trying to implement the parameter portion of the code: Private Sub btnQryExport_Click() Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Set dbs =...

No it did not. Sorry, I should have mentioned that I tried that. qdf.Parameters("EventID") = "151"

Please note that the query is completely vetted and is the Data -> Record Source for the report that runs perfectly fine with the exception that text fields are cut off because of the character limitation.

Here is the query code. Please note the genesis of this post. Since an exported Access report can only export text data with a limitation, I opted to export using a query which dose not have the same limitation of 256 characters. My goal is to 'grab' the parameters entered into the report...

June7 The error is on this line: qdf.Parameters("EventID").Value = "151"