Recent content by access17401

So i tried to implement the above code this morning as part of the update query and i receive this error = the expression you entered contains invalid syntax, without a corresponding operand, any thoughts Field: CRcode Table: tbltan Update to: IIf([tblver].[Rcode] Not "08","",[tbltan].[CRcode]="7")

They are joined, so that's perfect. I won't be able to test it until tmrw but was eager to see. I guess my skills are improving, even if its a little bit

I have an update query amending information, from tblver to tbltan in the query I want to add something but am not sure if it will work, or if i have the right code. The field i want to update = CRcode This sits in table = tbltan I am updating other fields with the new information coming from...

Thanks pbaldy, I had a look into that and it was fine. I did some more googling and not being a trusted document came up, which ended up being the issue even though there was nothing anywhere in the database that was showing it as not being trusted. Anyway followed a guide and found it. All...

Morning Everyone, I have a database, that we have been using at work and it has been running beautifully for 3 months now. For various reasons I have had to create a new user account for myself at work, the database is accessed on a shared server. The problem is that on my new user i can open...

Ow ok that's perfect thanks ridders. Though no point in asking for help, if I don't learn and understand why. Appreciate the explanation

Thanks arnelgp, I was close. So I understand why is the 'Right' in the line 'strToken = Left(Right(Me.txtString, 6), 2)' is that what changes it to read from the right? I think when I was trying to do it I was trying something like 'strToken = Left(Me.txtString, - 6), 2)'

Hi guys can the answer provided by Mark be altered. To change text in the MIDDLE of a field IF the only constant in the field is the number after the text that needs changing eg. Could be *****01**** Could be ***01**** There is ALWAYS four number trailing the text i want to change, but can...

Wow thanks for the response, i really did have one of those moments. Unfortunately ridders nothing that exciting, basically warm and cold. Unfortunately the last couple (really my first couple) projects at my new job have had these kind of restrictions, having never used access before its been...

I think I am having a rough morning, searched the web and haven't found anything (but to be honest drawing a blank on the wording of what to search) We have a data entry form, its high use hundreds of records a day. I am simplifying some aspects and would like some guidance on one. The data...

Sorted it out thanks for the pointers Mark, works perfect

Not sure about the brackets, they weren't there, I should of checked after i pasted the code in. The fields are there, i only use txt. for the field names as that is the suggestion i received when i started learning a month ago. and AppealID is a text field I keep getting Compile error...

I have implemented example as suggested thanks. I did have a thought though, just in the interest of learning I tried using Dlookup. Would this work? I have received error 2465, it might be in my code Private Sub txt_FirstName_Click() txt_FirstName = DLookup("[ADP_FirstName]", "Master File"...

I do understand that, for most of the records we will input in this database the user will scan in the URN and then scan in AppealID via barcodes, the year field that i am aiming to populate is purely a visual double check

Thanks I have seen the combo method through my research. I just think I should be able to find a way to do it through 2 text boxes. So say I have a table which is three columns AppealID, URN and Year. The urn might be present 12 times but the appealid will differentiate. i should be able to...