Search results

  1. D

    Add Time

    This is my code, but it keeps on returning -1 If Me.description = "15 minutes" Then txtTime15 = DateAdd("m", 15, [HrsRecu]) Else txtTime30 = DateAdd("m", 30, [HrsRecu]) End If
  2. D

    Add Time

    I have a textbox named txtHrsDebut what I would like to do is add 30 minutes to that time and then save. Can anyone tell me how to do this....
  3. D

    Create a query

    Hello, I have an independant form that I enter data and then after I click on the OK button all the fields are saved into my table named Data_tb and Agent_tb. When the form is closed I have an updated query that runs so we can update the code of the agent from 0 to 2. This is what the code...
  4. D

    Force Fields

    Hello, I have a form that contains a few combo boxes, but I am trying to force the fields to be filled, therefore idf the first field is not filled up you cannot go to the second...This works fine but the problem occurs when I choose data from a combo box and then if I decide to erase with data...
  5. D

    Problem with Continuous Form

    Hey I have a continuous form and I am trying to make one of the fields calculate the time the call has been open, therefore the time will increment until the call is ended... I have a label named lblClock and the textbox is name txtCallTime. My field sin my table that the time comes form is...
  6. D

    Calculating Time

    Hello, I have a continuous form tha is linked to my table named Agent_tb. My form looks something like this... Seq Date Agent TimeRcvd TimeStart TimeWtng TimeFin Clock 1 07-09-02 Dina 08.20 08.25 What I would like to do is that under the label named Clock I...
  7. D

    Password Form

    Thank You JIM
  8. D

    Password Form

    Hello, I created a logIn form for my database and I am working on a form that the user can change his password or reset it.... my table is named "tblUsersÈ and it looks like this... LastName FirstName User Password EmployeeNo ABBRUZZESE SAMMY abruzess *****...
  9. D

    LogIn Screen

    Hello, I am trying to make a login screen for my database, but I need to track down the user that is enetering the information. Therefore I created a form named frmLogin this is the code for that form ************** Private Sub User_AfterUpdate() Me![Password].SetFocus End Sub Private...
  10. D

    LogON Screen Example

    THANKS
  11. D

    LogON Screen Example

    I need the user to log into the whole db...and if the db is open and a new user comes along then the other user has to lof off and the new one has to re login
  12. D

    LogON Screen Example

    I have create a dbs in Acess and I need to create a form that I can make the user LogOn with username and ID. Does anyone have an example....... Thanks
  13. D

    DO While Loop

    Hello I am having some problems with my Do Until Loop...... My code is fine for everything else except I am confused on when to use Do While or Do Until. What I want my form to do is that everytime the user clicks on the command button named "Btn_Ajouter" I want him to get prompt withthe...
  14. D

    Adding New Records

    Can anyone please tell me if it's possible to make the last line of the form invisible. What I mean is I have a continuous form that allows you to add records, but I don't want to the user to see the last record with the * new to exit to add the records......I was able to remobe the star but I...
  15. D

    Open Form

    I tried that and it didn't work.
  16. D

    Open Form

    Hello, I have to forms that are linked to each other. For example: If I double click on DataID from MyForm2, it will bring me to the Specific DataID in MyForm1. That works fine, but the problem is from my SwitchBoard, when I click on MyForm1 II should have a blank form with no data, but...
  17. D

    Removing Choosen Item from ComBo Box

    I looked at that article but that is not what I am trying to do... Let's say I have 3 combo box that come from table named: tblName tblName ------- Dina Cathy Maria Carlo When I go to my form and go into the first combo box and choose Dina in cbo1 then if I go into cbo2, Dina should not...
  18. D

    Removing Choosen Item from ComBo Box

    I have a form that has a few combo box and what I would like it to do is that if I choose a name in the first box, well that name should not appear in the second combo box, and if I choose one from the 1 and 2, well does name should not appear in the 3rd box. Therfore I want to refresh the...
  19. D

    Adding New Agent in Same Form but diffenrent record

    Hey David, I am restructuring all me tables. I will let you know if I stil need help, Thanks for allyour help
  20. D

    Customize ComboBox Display

    I did change it but it still has the same effect
Back
Top Bottom