Search results

  1. A

    Export Query

    Afternoon I have made a query called "NAB Export Query", to send out a text file. I have then created a command button on a form to run the export, with the following code: Private Sub Command101_Click() DoCmd.TransferText acExportDelim, , "NAB Export Query", "NAB.txt", False End Sub I have...
  2. A

    Creating Salutation Rules

    You sir are a legend, finished, sorted and working. Plus I have got the override sorted. Thank you.
  3. A

    Creating Salutation Rules

    Cool well i nearly have it (changed field names in my form) Private Sub ADP_Title_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 title and last name is...
  4. A

    Creating Salutation Rules

    Ok so this is what i have so far, please be kind only been writing code for two weeks, I am a very basic and early learning but trying really hard. Private Sub Form_AfterUpdate() ' Telling it that is firstname is more then 2 characters use first name If (Me.A_FirstName) >= "***" Then...
  5. A

    Creating Salutation Rules

    So I have a complicated question (it’s probable not that hard but I am struggling), I have the following fields. A_Title – Title, data input A_FirstName – First name, data input A_MiddleName – Middle name, data input A_LastName – Last name, data input Salutation – changes according to above I...
  6. A

    Export Query To Comma Delimited Text File

    I know this is a very old question, but in this how would I define the export location?
  7. A

    Button highlight

    That is perfect, just what i wanted and worked a treat. Thank you
  8. A

    Button highlight

    I am sure there is an easy way of doing this but i can not work it out or find an answer anywhere. I have a form, with 4 input fields and a button to go to the next record. I open up on the first field and you can see the cursor, as i tab through, set up via tab order, you see the change in...
  9. A

    change table input through form

    So I have tried to alter your code and make it fit but I am having a little trouble, could you please guide me using a basic example? attached. If you open the report and enter the date 28/08/2017, what I am trying to accomplish is where records 3, 6, and 8 appear with the name 'Anonymous', I...
  10. A

    change table input through form

    Firstly thanks Galaxiom I was way off on the coding thought, and can not wait to develop some of this Monday. I need to be more precise with my responses the field name i could not remember exactly it is not actually name, however I had not thought about reserve words before and will have a...
  11. A

    change table input through form

    Yes definitely understand that. Did you have any thoughts on my follow up question? Or is it too different?
  12. A

    change table input through form

    That worked a treat. But I have also worked out the export code, thanks to your (plural) help. I will also look into the encryption option too, i really want to learn as much as possible. I might be able to help others then in return. In addition to this say I want to create an export report...
  13. A

    change table input through form

    Hi guys is there a way to create a button on a form that if clicked will change data in a table. For example i am inputting credit cards numbers, which then get exported in format to a text file to be uploaded to the bank. I would then like a button on my form which when clicked changes the...
View older results
Back
Top Bottom