Recent content by ChrisNeal1990

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

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

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...

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.

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...

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

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?

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.

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?

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

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...