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!

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

Recent content by Artesha

  1. Artesha

    HOW CAN 2 PEOPLE SHARE ACCESS DATABASE?

    Thanks all! I am going to make a working copy for designs and let my asst create reports in the other database.
  2. Artesha

    HOW CAN 2 PEOPLE SHARE ACCESS DATABASE?

    No, I haven't set up any passwords or anything. I just created the file on the network drive and made sure the Shared option was checked. Other than that, I've done nothing.
  3. Artesha

    HOW CAN 2 PEOPLE SHARE ACCESS DATABASE?

    Thanks, Bob. I tried that and I am still getting the exclusive message when we are both trying to change things. It is not set-up with the multiple front-end applications. How can I go about doing this? Will it allow both me and my asst to make changes and create applications at the same time?
  4. 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...
  5. Artesha

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

    Dan, Thanks a lot! It worked like a charm :)) Artesha
  6. 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
  7. 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...
  8. 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...
See more

Part and Inventory Search

Back
Top