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!

Search results for query: *

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

    Duplicate Entries

    I have a database that obtains all of its data from an excel spreadsheet. I have a macro that does the import quickly to a temp table then an update query that will put it into the permanent table. I am looking for a way to write a 'check' that will tell me that record already exists before...
  2. VeryNew

    Choices for report

    Hello, I have a report that the user would like to have quite flexible. sometimes they'd like it limited to a certain date the next time - all dates and only specific employees etc. I know how to do a parameter query - and i know how to have a report linked to a form so they can enter the data...
  3. VeryNew

    Is this possible???

    I have a table that contains dates and Locations as well as detail regarding events.(all one table) I need to create a report that shows me Location and Date at the top of the page and then underneath every event that happened at that location on that date. I keep getting it shown as different...
  4. VeryNew

    very new stumped on VBA code for query

    Hello, Can someone offer some advice. I am trying to write a little function that when called will run a query to tell me if there are matching records in the two tables - if there are i need it to give me a message box stating so. I had tried once and could not make it work. I am looking in an...
  5. VeryNew

    Compare data between 2 tables before query

    Hello, I have an append query that updates a permanent table with data from a temp table. (the temp table contains data from an imported text file). What i need to do is BEFORE the append query is run I'd like to make sure that the data in the temp table is not already in the permanent table...
  6. VeryNew

    Akkk how to add PK to linked Table

    Hello, I am new to the site - desperatly seeking help. I have an Excel sheet that is linked to a table in Access. Is there any way to add a unique identifier to use as a primary key? Any help you can offer would be well appreciated. Thank you. Tal

Part and Inventory Search

Back
Top