Search results

  1. 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.
  2. 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...
  3. 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?
  4. 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.
  5. 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
  6. 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
  7. 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...
  8. A

    VBA Insert Into SQL help

    I have the following SQL string that i want to run, but i get an application or object defined error. Can anyone notice a mistake with my string? mySQL2 = "INSERT INTO [tblReceive] (OrderDetailFK, Qty, DateReceived, UserFK, ReceiveFK) VALUES (" & _ Me.OrderDetailFK & ", " & minusNum & "...
  9. A

    Loop recordset with IF greater than?

    Im trying to create a record set that compares a quantity value in the recordset to a Value in a temporary table that holds the most recent remaining quantity. I have the following code in the after update of a text box, but it does not trigger. I want it to run after a value is entered into the...
  10. A

    Update query Criteria

    I have the following update query, im a little stuck in formatting my WHERE clause. I only want it to run an update if ALL the records in tblOrderDetail.StatusFK = 2. Currently it runs if only one has StatusFK = 2. Im sure its simple but cannot figure it out. UPDATE (tblOrder INNER JOIN...
  11. A

    help with my recordsetcode

    Im trying to get a recordset loop code working, i have my bellow code which keeps inputing a zero. My second piece of code is identical code but displaying the qty in a message box. The number it is displaying is the number i want to input into my field. I just cant seem to get it to put the...
  12. A

    Help with recordsets

    Hi, I need to loop through and edit a subform. The subform is for receiving an order, i want to run a receive all with a button click. So i have a query that works out what is remaining, i then want to update the qty in the subform with the remaining qty. I have tried several ways with no joy...
  13. A

    Run Update query on each line of continuous form

    Hi There, i have set up an update query. is there a way of looping through a continuous form record set and running the update on each line?
  14. A

    Form design help

    i need to run a condition that compares 2 field quantities together based on the same item. If they both equal the same then i want it to run a code and change a property for that record. I will have a OrderQty and a Total receivedQty when these 2 equal each other then it updates the items...
  15. A

    Form to view newly created records

    I have a piece of code that is creating new records when the form loads using recordsets. I need a subform to show only the newly created records, any help would be great! thanks
  16. A

    Loop through a recordset while adding new records to another?

    Is there a way of looping through a form record set, while adding new records to a different form record set? using some data from the 1st record set in the new records? any pointers would be great! thanks
  17. A

    Order Receive Form Detail

    Hi There i need some pointers as im struggling with a form setup, I have a Purchase Order system with an OrderDetail and Order Table. I have created an ReceiveDetail and Receive Table. i need to receive the order, i currently have a main form with a subform. Im struggling with the subform...
  18. A

    Loop through SubForm recordSet

    Is there a way of looping through a non update able continuous subform, and using information from each line. Which creates a new record in another table? so if there are 3 records in the subform it creates 3 new records in the other table and so on? thanks!
  19. A

    Add new records to subform on load

    I have got a received form that has 2 subforms. The main form is based on Received Table The 1st subform is based on a query that shows the order detail and how many units are outstanding. The 2nd subform is based on a receivedDetail table. so will have a list of items with the original order...
  20. A

    Sum a field then minus

    Im trying to sum a qty field naming it 'TotalRecieve' and then minus a qty from that sum? i've tried the following RemainingQty: Sum([tblReceiveDetail].[QTY])-[tblOrderDetail].[Qty] but i get an error saying 'Your query does not include the specified expression as part of an aggregate...
Top Bottom