Search results

  1. S

    Button to add new record to another table

    I had actually started something similar but you solved my problem. Thank you so much... Regards, Steindi
  2. S

    Button to add new record to another table

    Ok, how would the code look like? I'm not much of a code builder you see... :)
  3. S

    Button to add new record to another table

    Hi there, I have a form wich users input information into and it goes in one table. Several buttons on my form send a report from that table to people. What I need to to is that every time one of these buttons are pressed and a report is sent, a timestamp and wich button was pressed needs to...
  4. S

    I need to log user logon...

    Nope, still get an error. Run time error 3290 Syntax error in create table statement. The same part of the code is highlighted.
  5. S

    I need to log user logon...

    How do you post code the correct way?? I've marked the red part with bold.
  6. S

    I need to log user logon...

    :) Ok, now I get some of the code red and I get a Syntax error. Code: Private Sub txtPassword_AfterUpdate() 'Check that EE is selected If IsNull(Me.cboUser) Then MsgBox "Veldu nafn af listanum", vbCritical Me.cboUser.SetFocus Else 'Check for correct...
  7. S

    I need to log user logon...

    Hi again, thank you for your help. I've tried this and get this error. " I get a run-time error 3292 Syntax error in field definition."
  8. S

    I need to log user logon...

    Yes here is the code for the login form. Private Sub txtPassword_AfterUpdate() 'Check that EE is selected If IsNull(Me.cboUser) Then MsgBox "Veldu nafn af listanum", vbCritical Me.cboUser.SetFocus Else 'Check for correct password If Me.txtPassword = Me.cboUser.Column(2) Then...
  9. S

    I need to log user logon...

    Still having trouble with this... Is there no way i can put some code in the logon form that populates a field, with the user name in my userlogs table? regards, Steindi
  10. S

    I need to log user logon...

    I'm working on a split database, Access 2010 The user chooses his username from a combobox. I got the basic code online and built arround it myself. Thank you April15hater, I'll try your suggestions. Steindi
  11. S

    I need to log user logon...

    Hi everyone, I have a large database and it has a login screen wich user has to log on with a user name and password. I need to log the user logon with a timestamp in a seperate table. Can anyone help. I have a basic understanding of working with code and I'm a fast learner :) Thanks...
  12. S

    List box - totals - count

    In the report I group each customer I would like to see in the group footer how many times we called them and how many times the customer called us. In the report footer I would like to see how many time our company called all the customers and how many times all of the customers called us...
  13. S

    List box - totals - count

    Hi, thank you for your reply. My english is not quite my best feature, but i'll try... I need to publish in a monthly report how many times we contacted each person and how many times that person contacted us. I use gruping and i group each customer and at the bottom of the report i need a...
  14. S

    List box - totals - count

    Hello all, I have a database that holds info about phonecalls to and from our company. I have several list boxes in the table and one of it is a list box with 3 values "We called him" "He called us" "Other" In a report i would like to count how many times this month we called him and how...
Back
Top Bottom