Search results

Several years ago I started having issues with database corruption. It was finally solved by putting the backend into SQL Server Express then a couple years later into SQL Server Standard. It was a learning curve that I do not regret. The corruption was caused by the size of the database...

You forgot the @SqlServervariable and the two' ' similar to "q.SQL = "execute createNewInHeader" & " @TrailerID=" & "'" & Me.TrailerID & "'"

This is code I use with a form with two list boxes. I use a combo box to populate the first list box with email addresses. The combo box then populates the second list box with the reports to send matching the users with their reports. I have other fields on the form for other email fields. I...

What I do is create a pass thru query execute nameofSQLServerSP @StartDate = '01/01/2013', @EndDate = '01/31/2013' In design go to Property Sheet, ODBC Connect Str and hit the ... on the right side of the row to help build the connection string. Give the query a name. (You will need this name...

How about writing the Insert in SQL Server and just passing Execute Name of SP to server. This is how I handle all of my SPs. The SPs that need parameters I use QueryDef method.

I believe a Like search would be better in this instance with only 14,000 records. Even with 200,000 records somtimes it is better depending on the field type you are searching. I would try like search and then practice with the full text search in your test DB.

In Access 2010 inside design on the query, press the design button. then press the property sheet button, then in the properties on ODBC connect str press the button with the ... You can then build your connection string for the pass through query easily.

I like using Stored Procedures for queries which are the basis for reports and searches.

I found this bit of code. It works to return me to the same subform field I was in prior to a requery. I am using Access 2010. Dim strBookmark as String strBookmark = Me.Bookmark Me.Requery Me.Bookmark = strBookmark Me.Field.Setfocus I had also tried this code if there is sequential...

I am using 2010. Sorry about not mentioning that.

I am trying to pass a new description into the Products form. So the users no not need to type the description twice. The user then also adds a category. It works when I am not trying to pass the value. I think the problem is that the new entry is not saved in the text box. Private Sub...

I have the following code on an onclick event. When I change the acFormDS to acNormal it will not put the correct defaults in a new record in the Asset Pictures form. It only puts in the very first records default values. It works with acFormDS. Please advise me. I don't want to put the defaults...

This is the code I used on a Click Event. Dim db As Database Dim Q As QueryDef Set db = CurrentDb() Set Q = db.QueryDefs("AccessQueryName") Q.SQL = "exec SPName" & " @StartDate=" & "'" & Forms!FormName!StartDate & "'" & “,” & “@EndDate” & “’” & Forms!FormName!EndDate & “’”...

Thanks, HiTechCoach. I changed the module name and call it from the button like you said and it works great.

This code opens the zebra program, I choose the label to print and close the zebra program the error "STY SQL FE can't find the module '0.' " is visible. What is wrong with this code. I run the module from a button. DoCmd.OpenModule (OpenZebraProgram.OpenZebraProgram) Use Access 2007 FE, Sql...

Thanks, I wasn't sure what to search for.

Yes, the SP uses the @GreaterThanDateEntered.

I am using a pass through query. This line of code works. exec HardDrivetoCrushSP @GreaterThanDateEntered = '05/01/09' How do I get the date to be a parameter value. I tried = [Enter Date] but that doesn't work. I am new to writing pass through queries. The BE is SQL Server 2005 and the FE...

This is the code that worked. Thanks again pbaldy. Private Sub Qty_BeforeUpdate(Cancel As Integer) If Me.Qty > [dbo_AssetDescriptionQtyVWDetail].Form![QtyonHand] + 0 Then MsgBox "Insufficient Qty on Hand" Cancel = True Else If Me.Qty = 0 Or IsNull(Me.Qty) Then MsgBox "Qty Can Not Equal Zero"...

Thank You, That worked.