Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Artesha
  • Content: Threads
  • Order by date
  1. Artesha

    HOW CAN 2 PEOPLE SHARE ACCESS DATABASE?

    How come it won't let me and my colleague work at the same time? I've changed the settings to shared and everything and still when we are trying to create stuff (I'm working on a form and she's working on a report) it won't let us save them cuz we are in exclusive mode. Is there anything we...
  2. Artesha

    TRIM text in Access table!!! Help!!!

    I imported an MS Excel file into Access and some of the records have a space in the front. There are about 1000 records and I don't want to go and manually correct. Is there a way for me to correct this for all of the fields at one time? Thanks. Artesha
  3. Artesha

    Complicated WHERE statement needs %!!! HELP!!!

    This is the jest of my query,, Select * From Prospecttbl Where Not Exists(Select * From Membertbl Where Prospecttbl.LastName = Membertbl.LastName and Prospecttbl.FirstName=Membertbl.FirstName) The two fields have to match identically,, well, ive imported a table where the first name and...
  4. Artesha

    HELP WITH SQL query

    This is the jest of my query,, Select * From Prospecttbl Where Not Exists(Select * From Membertbl Where Prospecttbl.LastName = Membertbl.LastName and Prospecttbl.FirstName=Membertbl.FirstName) The two fields have to match identically,, well, ive imported a table where the first name and...

Part and Inventory Search

Back
Top