Search results

*high five* I'll get on that straight away if you were here I'd buy you a coffee :)

sure does :) it shows matching asset numbers and serial numbers with different locations.

so... something like: If DCount("*", "[master without matching redisttable]", "Expr1 = 0") Then DoCmd.RunSQL "UPDATE Master, Transactions INNER JOIN redisttable ON Transactions.[Asset Number] = redisttable.[Asset Number] SET Master.[Asset Number] = [Transactions].[Asset Number]...

ohhhhhhh my bad I've been working 12 hours a day on this (cos im learning it takes me longer to figure stuff out) so I'm extermely tired at this point but I get what you're saying now :)

wouldn't my query have to be false? because I only want to change locations which are different. If Not (r.EOF And r.BOF) Then r.MoveFirst Do Until r.EOF = True If DCount("*", "[master without matching redisttable]", "'Expr1 = 0'") Then r.MoveNext Else MsgBox "location change" End If Loop...

well its an asset management system where the assets move around, and im trying to put their previous location into another table and then update the main table with the current location. basically like a library system keeping track of who borrowed what books, in fact it's exactly the same just...

you are a legend! so I've got the dcount to work: If DCount("*", "[master without matching redisttable]", "LOCATION = [NEW LOCATION]") > 0 Then I made a query that joins by asset number and serial number so am I right in assuming that the next part will go something like this? loop until eof...

do I just put that in a loop? something like while eof = false do until eof if dcount(query) >1 do stuff else next? by the by I'm fairly new at this so assistance and knowledge is greatly appreciated :)

Hey all, I am trying to find out if a record exists in a query, and if it does then run another one, I was thinking something like: while not .eof do until if strSQL = true (sql code) compare table 1 and 2 - update table 3 else next record. Basically I've got a query that finds duplicates...

so I'm trying to work out the best way to tag a record if something has changed on it. The main table has asset number and serial number, which both need to be checked cos one of the other can duplicate but not both at the same time. If they move locations then I need to keep a record that...

all good I worked it out :) thankyou

yeah I did that, the db is down to 9.2mb it just doesn't like that query. if i open the form attached to that query and jump to the last record it does the same thing :S

the database is now 25 MB, down from 300 so that's AWESOME!!! except now when I run the query to display all the fields together, it shows fine until i try to go to the last record then it says nooo way no how this thing is bigger than 2gb. If I just base my form on that query will it run ok...

thank you so much for your help, I worked it out. I set up the relationships and then just delete them from the query and that works perfectly :)

I deleted everything because I didn't think it was right, but this is my imported table. The F fields can be ignored they've just come across from the excel import. Anyway the only fields that are different every time are asset number, serial number and invent number. Everything else can go...

does that mean that CustomerID will be the same in Table1 as Table2? I'm working with 50000 records, and the unique data I can split up into 15 tables, does that mean each table is going to have 50000 records? Or is there a way to create a table with the unique record (in some tables it's just...

awesome, so I've got all the tables created with unique data in them, which ended up being 15 extra tables, I've only got in each table the information I require and a UID which is the primary key. So asset description just has UID and asset description for example. Now what? I tried creating...

hi all, so I've learn't a lot about databases this week thank you to you wonderful people, and time and time again I'm hearing NORMALIZE YOUR DATA!!! and I have always thought huh? so I read this: http://office.microsoft.com/en-us/access-help/database-design-basics-HA001224247.aspx now my...

that's what I was hoping, I've got this grabbing the sheet selection after the workbooks are dumped into a combobox: Dim MyRange As String MyRange = Me.Combo4 & "!A:ZZ" MsgBox "" & strPathAndFile & MyRange DoCmd.TransferSpreadsheet acImport, , "importtable", strPathAndFile, True, MyRange am...

yah I'm trying to do something like: Dim DB As DAO.Database Dim tdf As DAO.TableDef, fld As DAO.Field CheckField = False '--initialize to False Set DB = CurrentDb For Each tdf In DB.TableDefs If tdf.Name = "importtable" Then For Each fld In tdf.Fields If...