Search results

  1. S

    Concatenate 3 rows into 1

    I need to concatenate a few rows into one, I have read and tried a few things on here but can't get anything to work. This is what I have ID Team Player Name 1 Team1 Mark 2 Team1 Paul 3 Team1 Arnold 4 Team2 Ralf 5 Team2 Bill 6 Team2 Simon I want to be left with...
  2. S

    Save text in a text box

    This is going to be a field that has a list of e-mail address. Basically I have a list of reports that go to different people. What I want to do is when a report is ticked a list of e-mail addresses appear, then the user can add or remove e-mail addresses. making the box appear then disappear is...
  3. S

    Save text in a text box

    I have put an Unbound text box on a form. The aim is that extra text is entered into the textbox each time the form is open, either to change data or add data. Problem I have is when the form is closed then opened again the text disappears how can I get the text to remain in the box. I have...
  4. S

    import files

    I have put a web browser on my access form to view files in a particular location. In this case my v drive. Is there a way I can click on one of the files then click a button to automatically import it?
  5. S

    Refresh for Subform Popup

    Is a Macro being run when this button is being pushed? If you you might be able to add a Save option at the beginning of the macro and ask it to save the table. before running the rest of the macro.
  6. S

    Identifying then deleting duplicates from two tables two produce a 3rd table

    You'll need to do a query taking both tables. Link the PAS Numbers and include everything from "NEWTBD" table. Take the "PAS Number "and "Primary" items from the "NEWTBD" table and just the "PAS number" from the "Done" table. In the criteria under "PAS Number" from the "Done" table put Is...
  7. S

    Refresh for Subform Popup

    I had a similar problem. When I was entering data in a form some data wasn't entering into the table. I found that if you enter a new item in a form and click on the button while still in the same cell as the text you've just entered it won't register. You need to tab or click into a different...
  8. S

    Prompt for file name

    Hi Have this function in access that allows me to propmt for a file name to be imported. Function Import_File_Click() On Error GoTo Err_Import_File_Click Dim strFile_Path As String Dim strTable As String 'Prompt user for file path strFile_Path = InputBox("Please enter file path V")...
  9. S

    Importing files - prompt for file name

    I am trying to do this but I keep getting an error saying it can't find macro. am I doing something wrong?
  10. S

    Have access Prompt me for table name

    In an SQL query in Access can I have it so it asks me for the table name? I need to run the same query for 13-18 different tables so I was going to make a union query in SQL and be prompted for each table name. The table names are always changing. many Thanks
  11. S

    Fixtures

    Thanks for coming back. I have looked through the other post but can't find anything where, if two teams share a venue. Thanks Statsman too, but I need something put into Access that I can give someone to use, then once the fixtures are set scores can be added and then tables worked out, etc...
  12. S

    Fixtures

    Hi I run a Pool league. I am looking to make a database that will help me create the fixtures. Thing is we have 4 divisions and some pubs have 2 teams that play out of that pub that are in different divisons. What I want this database to do is make sure the 2 teams aren't drawn at home on the...
Back
Top Bottom