Search results

  1. E

    using a pin

    This will basically be access control in to the database using pins to ID the admin and let them in also at the same time create a history of the logins, Im just working on the History log right now. Well i have been deleting it over and over and starting again each time. I have just got your...
  2. E

    using a pin

    Just a Note, Im not duplicating any data. Also im getting an invalid argument error, on the Set rs = CurrentDb.Op..... line. i have spent a good 2 hours trying to get it to work with no luck.
  3. E

    using a pin

    Hello, I have a textbox "Text2" with a 4 digi pin typed into it, when i click on a command botton i want it to check table "Admins" for that pin in field "Pin_". If it is the correct pin, it will then fill in another table "Access History" with the Date, time and Name of admin in the fields...
  4. E

    Text boxs and tables

    dont worry, i will. i have managed to get it to work using another method.
  5. E

    Delete me

    Thank You for your help i have created a delete query with the where clase directed to the text box and used VBScript to run the query and the reload the form, thank you for helping me with my general Db house keeping.
  6. E

    Delete me

    ok i thank you for your comments and will endevor to try harder, this is the code i had got so far. from past codes google and SQL sever 2005 step by step by microsoft press, and i still cant get it to work. Private Sub Command42_Click() If Not IsNull(Me![Text40]) Then Dim stSQL stSQL =...
  7. E

    Delete me

    Hello I need the code for taking the value entred into a text box and then deleting its record from a table. this will happen on the OnClick event of a command button. The text box is named "Text40" The field the value will be added to is named "Allocated To" The Table the field is located in...
  8. E

    Text boxs and tables

    now i need the the opposite, to be able to remove a record using the same method. any help?
  9. E

    Text boxs and tables

    are there any references i have to add
  10. E

    Text boxs and tables

    yeah i know that i have changed it from "Allocated To" to "Allocated"
  11. E

    Text boxs and tables

    table allocated to has been renamed to Allocated
  12. E

    Text boxs and tables

    now when i click the button it brings up an error and asks me to look at the DoCmd.RunSQL stSQL part of the code and debug it
  13. E

    Text boxs and tables

    Its coming back with complie error invalid character then its highlighting _ any help.
  14. E

    Text boxs and tables

    Hello I need the code for taking the value entred into a text box and then adding it to a new record in a table. this will happen on the OnClick event of a command button. The text box is named "Text40" The field the value will be added to is named "Allocated To" The Table the field is...
  15. E

    Function

    ok then how do i get a macro to run it?
  16. E

    Function

    It is in a standalone module. this is the code i have is it because of this. Option Compare Database Option Explicit Sub sbSendMessage(Optional AttachmentPath) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim...
  17. E

    Function

    Hello Im new to VBA and i would like help with getting a macro to run a VB script. i have tryed runcode but the marco cannot find my module as function. Can anyone help.
  18. E

    Can this be done and how?

    Thats a bit difficult for me i dont know where to put what and linking them together is hard for my head.lol
  19. E

    Can this be done and how?

    basically when the query returns the record an email is automatically sent out as a report of the record. so i have to find a way where no user interaction would send this email.
  20. E

    Can this be done and how?

    cant use sendobject as that requires a person to click allow access to send email. when the code i want to use gets round that.
Back
Top Bottom