Search results

  1. C

    Prevent referencing the same control when using IF in VBA

    Thank you Mark that is correct in what I meant. Apologies I couldn't think of a way to make it any clearer. Select CASE works, thanks MarkK
  2. C

    Prevent referencing the same control when using IF in VBA

    Where the code works I have had to type in the same control each time.
  3. C

    Prevent referencing the same control when using IF in VBA

    Hi, Does anyone know a way I can prevent referencing the same control when using the IF function in VBA. The below does not work Private Sub comboboxA_AfterUpdate() If comboboxA = 1 Or 100 Or 24 Then MsgBox "sdffds", vbOKOnly, "dfgdsfg" End If End Sub Whereas the below does work Private Sub...
  4. C

    Could not update, currently locked (Error 3218)

    Looking into record locks it was set to no locks. Also I found out that someone else in the office has copied the FE & BE from the network drive to self teach themselves Access.
  5. C

    Could not update, currently locked (Error 3218)

    Hi all, I've built a multi-user (approx 150) data entry split db at work. It's been running fine for about 3 weeks but today I came accross 'could not update; currently locked' error. Each user has a front end stored locally on their c drive & back end on a network drive. The users only have...
  6. C

    Date/Time when new record is saved, not created

    Yeah that works, great thank you. The field auto-populates as I set now () as default value when creating the table initially.
  7. C

    Date/Time when new record is saved, not created

    The field auto-populates on creation of a new record? I tried requery upon completing the new record however that didn't work. Do you mean for the users to manually complete that field or is there a way to postpone when that field is populated?
  8. C

    Date/Time when new record is saved, not created

    So my form is a multi-user data entry form, when the user opens the form the current date & time is populated, however the user may not actually need to create a new record for say 30 minutes and when they do so the date/time field remains unchanged.
  9. C

    Date/Time when new record is saved, not created

    Hi all, Is there a way I can I have a new record store the date & time of completion opposed to the date/time of creation?
  10. C

    Save form data into a different table?

    Apologies, just realized I posted this in the queries category opposed to the forms catergory.
  11. C

    Save form data into a different table?

    Hi Guys, I'm attempting to put together a Call Pegging database and myself being a bit of a novice am stuck pretty early on unfortunately. I have a form with 2 combo boxes, combo box 1 = Primary call type, combo box 2 = secondary call type. The combo box values are pulled from 2 seperate...
Back
Top Bottom