Recent content by aron.ridgway

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?

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

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.

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

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

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?

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.

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

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

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

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

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..?

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

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

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