Recent content by token_remedie

Hi all, Basically I'm trying to import each worksheet, but each one needs something different done to it on import so I'm using a for loop: Private Sub Command32_Click() 'import master data click Dim MyXLApp As Excel.Application Dim MyXLWorkBook As Excel.Workbook Dim MyRange As...

good point. It populates the csv file but no data in it. here is the full code: ' Where are all the girls? You said there'd be girls dim cmd, cn, rs, objRoot, objFSO, objCSV, q const FileName ="domaincomputers2.csv" set cmd = createobject("ADODB.Command") set cn =...

this loop isn't working: for each ServerName in ServerList wscript.echo ServerName q = """" if rs.eof <> true and rs.bof <> true then objcsv.writeline(q & rs("name") & q & "," & q & rs("operatingsystem") & q & _ "," & q & rs("operatingsystemservicepack") & _ q...

just keeps saying expected = so I was thinking something like this: If (DoCmd.RunSQL("SELECT master.[asset number], desttable.[asset number] FROM master, desttable WHERE master.[asset number] = desttable.[asset number];")) Then DoCmd.RunSQL ("UPDATE master.[destroyed] = Yes;") but that...

is it possible to do something like this? for each record in a table if table1.field = table2.field then update table1.field2 = yes else next record I've been looking through the MS help and it doesn't really tell me much, using access 2010 if so, how would I go about doing this? Thank you

haha I was so close, I tried: strWhere = strWhere & "([Asset Description] Like """&"*" & Me.txtFilterAssetDescription & "&"*"") AND " and being a noob I'm happy that I was so close on my own before I came here Thank you I'll test it out soon :)

Hey all, I'm using Allen Browne's wonderful search sheet(http://www.everythingaccess.com/tutorials.asp?ID=Build-a-search-criteria-form) and tweaking it for my own purposes and I would like the below text box to be wildcarded on each side, is this possible? strWhere = strWhere & "([Asset...

im importing a workbook and they just come with it into a temp import table and then an append query is run after that. this now isn't working though: DoCmd.RunSQL "INSERT INTO Transactions ( [Asset Number], LOCATION SELECT Master.[Asset Number], Master.LOCATION FROM redisttable INNER JOIN...

that code works perfectly though and I'm just deleting import error tables cos this stupid spreadsheet import imports a bunch of pointless crap with it

oh I'm such an idiot! that's all it was thanks bro :)

Hey lovers, I need a kick in the right direction here, trying to delete (or atm just print to msgbox) a variable table name to get rid of any import errors I might get - they wont be important anyway. it cycles through everything sweet but it wants to delete everything.... Any ideas? Dim...

I've been doing some reading, and where I'm going wrong is, the relative field in every table isn't really viable. Like the only way I can actually link all the tables is to have the foreign key as primary ID autonumber or asset number, if I'm going to put that in every single table I may as...

I thought I had normalised all my data, and then when I ran the query to put it all together it showed the same record a million times over and crashed the DB. So if I could get a hand just telling me what I need to do to normalize this properly I would be forever in debt. The Master Table: UID...

i found it :D - indexed - yes duplicates OK

k so basically we've got a bazillion assets that have been kept in spreadsheets and someone said hey man can you make us a database? SUUURE I said *raise middle finger* Anyway so everything is kept in seperate spreadsheets, so I've got an import button that lets you select the sheet to import...