Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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 =...
  5. 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...
  6. 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...
  7. 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...
  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

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