Search results

  1. A

    Update Query

    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")
  2. A

    Update Query

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

    Update Query

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

    Database issue

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

    Database issue

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

    Change text input

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

    Change text input

    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)'
  8. A

    Change text input

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

    Change text input

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

    Change text input

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

    Using Text box as search function

    Sorted it out thanks for the pointers Mark, works perfect
  12. A

    Using Text box as search function

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

    Using Text box as search function

    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"...
  14. A

    Using Text box as search function

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

    Using Text box as search function

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

    Using Text box as search function

    Good morning, I have created a search function using a text box and command button bellow. This searches and returns from table according to the URN. Private Sub Command200_Click() If (txtGoTo & vbNullString) = vbNullString Then Exit Sub Dim rs As DAO.Recordset Set rs =...
  17. A

    Order by in UNION Query

    I have a union query below, it combines three queries. I want the output to show results in order, so all of first query results, all of second query results and then all of third query results. I have tried several ways found on line using ORDER BY with no luck. My output always goes back to...
  18. A

    Export Query

    Sorry just thought of something else, the current file exports the data but without the headings is there a way to add in the table headings?
  19. A

    Export Query

    Both worked perfectly, thanks
  20. A

    Creating Salutation Rules

    For anyone who may need the help in the future this is the code that worked: Private Sub ADP_Firstname_AfterUpdate() ' Telling it that is firstname is more then 2 characters use first name If Len(Me.ADP_FirstName & vbNullString) > 2 Then [txt_Salutation] = [ADP_FirstName] ' if the...
Top Bottom