Search results

Unforunately the field doesn't always lead with zeros, so I think there would be too much confusion format the field so that the zeros appear.

Crap, well I was told that this bit of code wouldn't work: Private Sub YC_TAG_BeforeUpdate(Cancel As Integer) If DCount("YC_TAG", "Asset Details", _ "YC_TAG = " & Me.YC_TAG <--- this syntax will only work if the YC_TAG is not a text data type.) = 0 Then DoCmd.GoToRecord acDataForm, Me.Name...

I have a numerical field that's format is ##-#### much of the time the field begins with zeros, for example: 00-1234. My issue is that I've left the data type for the field as text because it allowed me to enter whatever I wanted, however I have a vb code that doesn't work with a text field, I'm...

Thank you so much for your help, I have two questions, the yc_tag field consists of records formatted as ##-#### much of the time the id tag starts with 00-#### though, so I've left the field as text because I didn't know which numerical data type to choose, and seemingly any time I choose one...

I've been attempting to have a field within a form check whether or not a duplicate record exists and deliver a message immediately after you navigate away from the field. I'm uncertain whether the code I have is what I really need, it's the only code so far however that's produced something...

Thank you very much for pointing me in the right direction. I've been trying to implement the code but haven't had much luck. I attempted to change the event to before update of the Asset ID textbox field, the name of it within my database is YC_Tag, so that instantly when someone enters an...

I'm pretty new to Access, I've been working with it for about three weeks now. My issue is that I have a form for entering assets and have set the primary key to a unique id tag we use for inventory, that's all well and good for preventing duplicate data, however I'd like to know if there is a...