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

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

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

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

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

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

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

Table looks like:<br>PONumber&nbsp;&nbsp;Vendor<br>PO1022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MUW-001<br>PO9303&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KEK-203<br><br>This code is attached to a ponum combo box, what I need to happen is if the ponum exists in the table, then fill the vend combo box on the form...

I have a box that is bound to column 1 of a combo box called &quot;PONumber&quot;, it opens the name of the vendor and automatically fills it in when a PO number is selected. Now some PO's are not in the system and need to be given a vendor name when a referencing PONumber doesn't exist. What I...

What I have is a query that has a few fields but the only important one is the problem one. the products are all sorted by the job's so one job can have the same problem more then once. Now, I need to generate a table that has another column that says how many times it has had this problem so...

I have a query with 5 fields. 2 of the fields have a couple variables. What I'm doing is displaying a report based on selected values on the form. <br>Ok so in the query the 2 fields are just integers, one says Between [Clockstart] and [clockend]<br>the other says<br>Between [jobstart] and...

This is what is happening now:<br><br>I have a query that has a few fields and it has an Item prompt and it asks for the item number and I type it in and it displays the one item field. (one item to one item number obviously).<br>So now we are receiving some inventory and lets say we get 10 of...

Ok, here we go again! I have a report that has the following pieces of data. Name, key, sn, job, desc, cost<br><br>I'll give you some typical data<br>John Doe 12 001 5050 blah&nbsp;&nbsp;20.00<br>John Doe 12 001 5050 blah1 30.00<br>John Doe 12 001 5050 blah2 40.00<br>John Doe 13 002 5051 blah4...

I have a database that I have to work on, and I copied it from the server to my computer, so whatever edit's I make don't matter until I apply the changes. Anyway, my problem right now is that the sysadmin of the company put a bunch of security on some important forms and queries that I need...

I have a query that prints a bunch of stuff releative to one job number. When it prints, on the top of the printout is the name of the query. Is it possiable to make that line a variable that corresponds to the Job number??<br>So right now every report prints &quot;JOB PICK&quot; which is the...

I have a query with an item field and a location field. Currently all the location fields are empty. I have it so that it prompts for an item name and it will display the item and the location field. now I need to make a list of misc items say &quot;WHEEL&quot; in the corrosponding location...

I run War-FTPD (ftp server) from my windows nt workstation box and it is just in the startup to run when windows boots. How can I make it so that I can have it running while I am not logged in?? So how can I make warftpd.exe a service running whenever windows is on, but still appear in the...