Recent content by Rubius

Hey, I need to have code that does the same thing as this code, except it needs to run A LOT faster! The database is huge so when you go through the code, remember that there are a lot of entries. the problem is with IC-JOBITEM as it is a query with 32000 entries and it checks it every loop. I...

thanks peeps..both work and the knowledge of the one I didn't use will come in handy another day!

&nbsp;&nbsp;&nbsp;&nbsp;check = &quot;Me!cost' & i&quot;<br>here it auto puts the last quote on the end<br><br>&nbsp;&nbsp;&nbsp;&nbsp;If rst!cost &lt;&gt; check Then<br>this line probably works but I donno, doesn't matter because<br>&nbsp;&nbsp;&nbsp;&nbsp;&quot;Me!cost' & i&quot; =...

In access I have a form with a bunch of text boxes that I'm going to fill using code. they are named cost1, cost2, etc..<br><br>in vb code I want to be able to do this like this:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If rst!cost &lt;&gt; &quot;Me!cost*i*...

jesus I got it..<br><br>tempsql = tempsql & &quot; WHERE PONumber = '&quot; & Me!ponumlog & &quot;';&quot;<br><br>gotta make it look like that....wow what a bad day today...<br>thanks for your help everyone.<br>

Alrighty then...that worked...now that I look completly stupid, I'll ask this:<br><br>&nbsp;&nbsp;&nbsp;tempsql = &quot;SELECT PONumber, InvoiceNumber, Vendor, [Part Rec'd], NumofPieces, [Date Rec]&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;tempsql = tempsql & &quot; FROM...

I've got the following:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dim dbs As Database<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim qdfTemp As QueryDef<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim tempsql As String<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim rst2 As Recordset<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>then tempsql...

This is the SQL I have:<br>tempsql = &quot;SELECT PONumber, InvoiceNumber, Vendor, [Part Rec'd], NumofPieces, [Date Rec]&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;tempsql = tempsql & &quot; FROM [SR-LOG]&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;tempsql = tempsql & &quot; WHERE [Date Rec] Between &quot; &...

Private Sub Command23_Click()<br><br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dim dbs As Database<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim qdfTemp As QueryDef<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim rst As Recordset<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Set dbs = CurrentDb<br>&nbsp;&nbsp;&nbsp;&nbsp;Set qdfTemp =...

I have a form that has a bunchof different fields. You can enter search data into each field to search a table. Lets say that each piece of searchable data is a number.<br>So we have 1, 2, 3, 4, 5<br>Now I want to make a bunch of buttons that will display tables based on a query that uses...

Is there a way to suppres question boxes such as &quot;you are about to run a append query... blah blah&quot; with code?<br>I know you can do it through tools/options, but I want this to only happen when this button is clicked and on every computer, not just mine, without having to go around and...

Doug!<br>So very close!!<br>DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, &quot;Tablename&quot;, ExcelVendorName, True<br><br>I need to make it look at a different Tablename every loop. Because just like how the filename changes every time as by the vendor, the table needs to...

This is what I need to do:<br>I have a table, the table has a bunch of entries that are sorted by a vendor. Now each vendor will have 1 to a bunch of entries, but not every vendor is on the list. What I did so far is create a query that lists the vendors on the table and no dupes. Another query...

What I need to do is create a distrubution list that does the following:<br><br>&nbsp;Every e-mail address is different, but the subject and the message is the same. Now there is a attachment that needs to be attached to each message and every e-mail address needs to have a different attachment...

Version 5.1 and or 5.2