Search results

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...

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...

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

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...

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 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...

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...

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...

bit of a noob here, I've got an import function to import different spreadsheets to access, but the field names are slightly different all the time from sheet to sheet. so what's the best way to get my data into a main table appending to the same columns that already exist in the table? at the...

hey, what am I doing wrong here? so far it lets the user select a file, adds the worksheets to a combobox now on the afterupdate() in the combo box i want to docmd.transfer spreadsheet based on the selection in the combobox. here's the code so far: Private strPathAndFile As String ' this is...

so I'm trying to use filedialog to open a file then pass that filename to dim myxlworkbook as excel.application so that it populates a combo box of the sheetnames which ill then take that selection of sheetnames for docmd.transferspreadsheet import. anyway I'm getting runtime error 91 Object...

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...

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...

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 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...

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...