Search results

I ended up using first: SELECT First(find_books_dupes.[Asset Number]) AS [FirstOfAsset Number], First(find_books_dupes.id) AS FirstOfid FROM find_books_dupes; And then a delete DELETE books.*, books.ID FROM books WHERE (((books.ID) In (SELECT firstofid FROM firstoffbooks))); Problem was...

Hey, need a little help here, I have a query that finds duplicates and returns a single value in an attempt to identify duplicates in a table. SELECT DISTINCT Books.[Asset Number], Books.[Serial No], Books.CoCd, Books.Class, Books.[Asset Description], Books.[Invent No], Books.CostCentre...

so I want an update query, my first few attempts haven't worked they just append not update the table. Anyway what I want it to do is: check table 1 against table 2 is the record is found then check location in table 2 against table 3 if they are different then update the location from table 1...

I actually think I did it: INSERT INTO Transactions ( CoCd, Class, [Asset Description], [Invent No], CostCentre, Plnt, Location, [Location Code], [Location Name], FundTyp, ProgSrc, SubClass, Vendor, Manufacturer, Cost, [W Start], Remarks, R2, Formula, [Asset Number] ) SELECT importtable.CoCd...

bit of a noob... so I'm working with access's template of the library database, and so far so good, I've managed to import data into a new table to work with in the hopes of cleaning it and putting it in the main table called books. So the import table is called importtable, main table is...

actually i dont even want that stupid message box. all i really need to do is, if its a match from Tabletest then move that entry from books to transactions, delete it from books and reinsert the entry with the new details into books...

Tabletest is the import, Books is the main asset table matched assets is the query matching imports to the main table and transactions is a history table. any idea where am I going wrong here? Private Sub Command0_Click() Dim strFile As String 'Filename Dim strFileList() As String...

perfect! that was exactly what I needed. I've managed to get it to import into a table, and run a duplicate find query at the end of that code, now I'm thinking to get those duplicate entries back into the main table i need an append query yes? I've got the query to run which looks for...

Hey, So I'm just brainstorming a little here and I need the foundation to be right which is where I've gone wrong in the past. I need a database to be able to read four dynamic spreadsheets but only one particular sheet of it, then filter or clean that data and ammend or add to an existing...

I worked it out, I put table.field: If Not IsNull(Me.txtFilterMainName) Then strWhere = strWhere & "(deployed.location Like ""*" & Me.txtFilterMainName & "*"") AND " End If this returns a result thank you so much for your help... although I'm not done you helped me through a...

if i enter the invent no it pops up asking for an asset number now and vice versa no searches work still. the combo boxes are unbound and the display boxes under results are bound to the deployed table which is what I'm searching. when the form opens it displays the 44754 records but wont...

I think I've worked out the report part of it, I'll just docmd.open,,,Dim args that's cool but no there's more it's pretty much your code - why reinvent the wheel when I have a superfast low profile racing wheel here right? Private Sub cmdFilter_Click() 'Purpose: Build up the criteria...

this is exactly what I wanted to do I just couldn't work out how to do it and I was on the right track looking at old code. Anyway there's something just not right and I'm sure it's because I've been staring at it too long. here's what I've done with your code, if you could point me in the...

I can't get this to work and I've tried several methods. ok so basically I'm trying to create a query or report (I don't care which) based on criteria filled out from several comboboxes. The tables fields are: Asset Number, Location Name, Asset Description, Serial no, Invent no, Location...

just in case anyone is wondering I ended up working it out: <code> Public Sub Command101_click() Dim SQL As String Dim chk As String 'checks for duplicates between the two tables SQL = "SELECT deployed.* FROM deployed LEFT OUTER JOIN redistributed ON redistributed.[asset number] =...

its just managing assets. I need to record the movement of an asset, thats pretty much it and be able to search by any aspect of the asset, e.g asset number, warranry date current location, when it was distributed etc.

pretty much all I'm doing is: I have one table which the main form is built off, then i have a redistributed table which is every asset that's been redistributed t hat feeds a subform on the main form based on form!asset details!item (which is the current record asset number). so all im doing...

basically I've built an asset management db but when an asset gets redistributed I want to add it to the redistribution table with a yes\true value in the check field so that the next form can find that value and add the current location to it and then update the deployed (main table) table with...