Search results for query: *

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

First Time poster long time watcher. :) <br><br>I need to create a way to make a e-mail message that I can double-click, then have the subject and the message already filled in. When it's double-clicked, the user can then type a e-mail address, attach a file and send it, then open it again, type...

In the combo box properties, set column count to 150....and the row source is a query that you create..but 150 columns is totally nutty buddy!<br><br>

Ok I need to import a exported spreadsheet into a table in Access. I am able to import the data from the text file which is delimited and sepereated with commas, only if the field headings are at the top. My deliemma is that when the file is exported, I can't get it to export the proper...

OK, I have noticed that when you create a table, and when the column is set as a number the justification of the data is to the right, but when it is text, the justification of the data is to the left. I need to know how I can change that to whatever I want, left, right or centre. Because we...

THANK YOU SO MUCH FOR ALL YOUR HELP! After I typed the last message, I thought to myself, why in gods name do I even HAVE vendname! Deleted it and made the code look like this:<br><br>Private Sub ponum_AfterUpdate()<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me!vend =...