Search results

  1. C

    Return to same field after requery in subform

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

    Pass New Value from NotinList

    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...
    • cjman
    • Thread
    • Replies: 3
    • Forum: Forms
  3. C

    Default Value Problem

    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...
    • cjman
    • Thread
    • Replies: 1
    • Forum: Forms
  4. C

    Opening another Program Code

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

    Pass Through Query Parameter Date

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

    Validate Quantity AfterUpdate not working

    The following code does not work. I am using Access 2007 Fe to SQL Server 2005 backend. What am I doing wrong? The message boxes don't work and it allows quantities to be entered greater than the quantiy on hand. Private Sub Qty_AfterUpdate() If Me.Qty >...
    • cjman
    • Thread
    • Replies: 6
    • Forum: Forms
  7. C

    Remove Border from image

    I have a SQL Server 2005 backend to an Access 2007 front end (ODBC). When I add an image, the border from the picture is inserted also. How do I remove the border from the picture? I usually compress the pictures to web small in Microsoft Picture Manager but I can't fiquire out how to remove the...
  8. C

    Change SQL Server Password from Access

    I have Access 2007 to SQL Server 2005 setup. I do not control security. I need to change a password through access to SQL Server 2005. I use SQL Server ODBC. The user name and password is all the comes up when opening DB. The error message says I need to change the password but there is no...
Back
Top Bottom