Search results

  1. A

    Encrypting - Decryption Password SQL Table

    How could i use SQL security by a stored procedure? After more thought i only want to encrypt the password and when a user types there password it encrypts before checking they match?
  2. A

    Encrypting - Decryption Password SQL Table

    Its not a single field i want to encrypt all entries made the Password column. I have the format on text boxes already, but currently if i open the Table in SQL Server management and open the User table the passwords are all visible. I think what i need is a function that encrypts to hide the...
  3. A

    Encrypting - Decryption Password SQL Table

    Hi There Just wondering what the best way is to Encrypt and decipher a field in SQL. Basically i have a User table that has a Password. I want to make this encrypted so the password cannot be viewed. What is the best way to achieve this? any help/pointers would be great.
  4. A

    Slow Combo box on Continuous Form

    I want to be able to search "Hotel" and all the items with that in the text anywhere show up. So as they type its filtering what is shown in the combo? Can that be achieved with just a combo box then? thanks
  5. A

    Slow Combo box on Continuous Form

    I have a Continuous form that is used to place orders in my Purchase order Database. I have a combo box with a Textbox over laid, so the users can type in the Textbox and it filters the combo box as they type. This is to search Nominal ledger codes that the current user has set up. This has...
  6. A

    Continuous Form Combobox Search as you Type

    Hi There What i want is to have a combo box on a continuous form that as you type it filters the Query it is based on using a Like *. and drops downs so the user can see the updated list after each key press? Does anyone know if this is possible?
  7. A

    Add an Animated gif onto a Form

    Hi There, im trying to add an animated gif file onto a form in access 2013. Im trying to add a active x control Animation control but get an error, Database doesn't support this active x? If anyone could help that would be great.
  8. A

    Sample code for sending email

    Hi There, has anybody got any sample code for sending an email from access via outlook with VBA. I want to be able to add a hyperlink into the body of the email if possible? many thanks
  9. A

    Continuous Form vba Format

    The attached is the form in design view to give a better idea of all the buttons. yes that is correct depending on the button click on the menu will depend on what buttons are hidden on the frmOrderView Form. All the buttons are made visible on the form close. I have run through the code and...
  10. A

    Continuous Form vba Format

    Im not sure if the code is triggering or not? i have updated the and added the labels into the code. As if i manually change the size on the form it adjusts the button and the label equally. I have also attached a screen shot of my form which shows the missing gap that i want to eradicate...
  11. A

    Continuous Form vba Format

    thank you i have got the following, i have just tried the buttons are staying in the same place? do i need to do the same process with the labels too? Private Sub cmdRecordInvoice_Click() Dim i As Integer Dim l As Single On Error GoTo cmdError DoCmd.OpenForm "frmOrderView", acNormal...
  12. A

    Continuous Form vba Format

    ok i understand, i have five buttons which are called, cmdEditView, cmdReceive, cmdAmmendR, cmdRecInv, cmdAmmendI. how can i merge your code to fit with my buttons? as they are not called btn1 etc..?
  13. A

    Continuous Form vba Format

    Thank you for the reply, i will try and use the code. could you explain briefly what the code is actually doing? thanks
  14. A

    Continuous Form vba Format

    There are quite a few buttons so i wanted to conserve space as the form is already quite wide?
  15. A

    Continuous Form vba Format

    I have a continuous form that has several buttons, i am hiding them depending on which buttons they press before hand. Is there a way to hide the spaces left by the invisible buttons using vba? or is there a simpler way? thanks
  16. A

    Looping through Form recordset and looking up Value

    Hi There, Im still struggling with working with recordsets. What i want to achieve is to loop through a continuous form recordset, Using the OrderDetailFK from the record set and the OrderDetailPK in the OrderDetail Table Looking at the Status FK in the OrderDetail Table. IF the OrderDetail...
  17. A

    VBA Insert Into SQL help

    I have worked it out! It was a conflicting userFK in the query! i removed the extra FK and its working fine! thanks for the help!
  18. A

    VBA Insert Into SQL help

    frmReceive is the master form, the code is running in a subform on frmReceive (the Master), i have minusNum which is an integer variable. could this be causing the error? The value im trying to insert it into is a number field. minusNum = Me.txtQty.Value * -1
  19. A

    VBA Insert Into SQL help

    I have re tried see bellow, still getting the same error. I cant make it get to the debug.Print stage! mySQL2 = "INSERT INTO [tblReceive] (OrderDetailFK, Qty, DateReceived, UserFK, ReceiveFK) VALUES (" & _ Me.OrderDetailFK & ", " & minusNum & ", " & Date...
  20. A

    VBA Insert Into SQL help

    i tried it but it produced the same error, i have an insert which uses now(), so i know that it works.
Top Bottom