Search results

  1. T

    Sub form data not refreshing

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

    Search ComboBox not Working

    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] = " &...
  3. T

    Execute sproc in VBA

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

    Add Existing package to solution

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

    Run Sproc with parameter in VBA

    I have an Access textbox with an after Update event that run this code. Simply put it gets a ten digit string that is passed to an SQL sproc that creates a record and inserts it into a table. Here is the code: I get a runtime error message 3265: Item not found in this collect. Does anyone see...
  6. T

    DoCmd.OutputTo parameters

    Hi Report Masters, I have an Access report with a long text/Memo field column that keeps getting cut off. After doing research I found out that reports that are exported using the Database Tools -> Export ->Excel get truncated since the only export to older versions of Excel. This is true and...
  7. T

    run time error 3146 odbc call failed

    Hi All, I have this run time error that is strange. I say this because the error is occurring in my development environment but not in my production environment and the code is exactly the same. As, I add new features, I move this copy into the production folder for users to use. In fact, I...
  8. T

    32 Bit Issue

    Hi All My version of Access is 32 bit. When certain users try to access it using a Citrix server they get this error: Your Microsoft Access database or project contains a missing or broken reference to the file 'MSCOMCTL.OCX' VERSION 2.2. When they click OK this msg comes up: Compile error...
  9. T

    VBA Code Not Working

    Hi VBA Masters, I have the following code that I adopted from the web. It is cool because the loop checks any control whose tag is set to 'v'. It returns the name of the offending control and puts the focus on it so the user can fill it in. The issue that I have is the call to the function...
  10. T

    VBA Code Improvement

    I have code used to give access to a button in my application. What, I want to do is improve it and make it more flexible to update. Specifically, a new users is needed but since I coded it (see below), I have to wait until the end of the day to make the change. Is there a table based method...
  11. T

    Best Practice Form Validation

    Hi Form Masters, I have a form (see attached) that does not validate all sections. For example, there are three sub-forms placed on top of each other. The radio buttons un-hide each of the sub-form (Gift Allocation, Associated Credits, and Notification) when selected and hides the others. As, I...
  12. T

    Record Display not refreshed

    Hi All, I have several outstanding issue that, I would like to bring to rest. The first is that this code: Me.lblRecCnt.Caption = _ "Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount does not refresh as I use the vba navagation buttons on the form. In order to see the...
  13. T

    Form Data entry with wired error

    Hi Form Masters, I'm getting very strange results with an Access form that has an SQL database back end. When data is entered into it records are displayed strangely. What, I mean by strangely is that the primary key is repeated in two row showing the same data twice. Another strange thing is...
  14. T

    Best Event location

    Form Masters, I have a slit form let's call it formB that gets data automatically from another form let's call it formA upon saving. Users now want to do manual enter into formB so I've added a button labeled 'Add Item' When this button is clicked the caption is changed to 'Save and Exit'. I...
  15. T

    Refreach Issue

    I have put the following code into the After Update event of a text box on a form: Private Sub PreDepositedCheck_AfterUpdate() If Me.PreDepositedCheck.Value = 1 Then Me.PreDepositSource.Value = "SDE" 'This value should be set Me.PreDepositOrigBank.Value = "C0010" 'This value...
  16. T

    Error in For loop code

    VBA Masters, I have this simple for loop that gives me an error but, I can't see what's wrong any help is appreciated. Error msg is: Next without for For Each ctl In Me.Detail.Controls With ctl If .ControlsType = acTextBox Then If IsNull(.Value) Then If...
  17. T

    VBA code not working as expected

    Hi VBA Masters, I have this simple code: 'THIS CODE POPULATES THE GIFT TYPE COMBO BOX strPerson = "Soft;Joint;IHO;IMO;Faculty & Friends" strOrg = "Soft;IHO;IMO;Faculty & Friends" If Nz(DLookup("PersonorOrgan", "dbo_tblTransmittalInfo", "GiftID= " & [GiftID] & " "), "P") = "P" Then...
  18. T

    SQL Select Case to Access vba code

    Hi VBA Masters, I have SQL code with a Select Case for a column that I need to implement in an Access query as follows: SELECT DISTINCT c.CONTACT_DATE, c.DESCRIPTION, c.Purpose, c.Contact_Type_DESC, c.Id_Number, Case When m.MAIL_LIST_CODE = "MMS" THEN "Med_Contact" Else...
  19. T

    Help with formatting String

    I have code to dynamically assign a string to a Combo Box's Row Source. If, I type it into the Row Source property Sheet it works fine: "Soft";"Joint";"IHO";"IMO";"Faculty & Friends" But here is the vba: Dim strPerson As String Dim strOrg As String strPerson =...
  20. T

    Dynamic row source

    I want to dynamically select two different 'Value List' based on the value of a column in a table. The values are P for person and O for organization. If the value is P then the Value List should be : ["Soft";"Joint";"IHO";"IMO";"Faculty & Friends"] but if the value is O then the Value List...
Top Bottom